Hi, i have a code that is using radiobutton to get data from a data table..i want once you click on the radiobutton it display the data on the gridview but it is not doing so..kindly help..below is the code am using.
- 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();
- }
- }