数据未加载RadioButton的GridView

Question

我有一个代码，我打算使用"单选"按钮从表中检索数据并将其加载到网格视图上。但是，一旦我单击"广播"按钮，GridView中没有加载数据。以下是我的代码：

protected void Radiobuttonlist1_CheckedChange(Object sender, EventArgs e)
{
    string Value = Radiobuttonlist1.SelectedItem.Value.ToString();
    if (Value == "Patients")
    {
        string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
        SqlConnection conn = new SqlConnection(connect);
        conn.Open();
        SqlCommand cmd = new SqlCommand("select PatientName,PatientCellPhone from CustomerInformation", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    else if(Value== "Suppliers")
    {
        string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
        SqlConnection conn = new SqlConnection(connect);
        conn.Open();
        SqlCommand cmd = new SqlCommand("select VendorName,VendorPhone from VendorInformation", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    else if ( Value== "Employees")
    {
        string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
        SqlConnection conn = new SqlConnection(connect);
        conn.Open();
        SqlCommand cmd = new SqlCommand("select EmployeeName,EmployeeMobilePhone from PayrollEmployees", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
}`

Answer 1

由于您使用了DataSet而不是DataTable，因此您需要使用DataSet的Tables属性：

GridView1.DataSource = ds.Tables[0];

或喜欢：

da.Fill(ds,"tbl");
GridView1.DataSource = ds.Tables["tbl"];