how to use a loop with radiobutton to retrieve data

john kanyora

Hi, kindly requesting to be assisted on how to use radiobuttons to retrieve data from a table in the database. i have three radiobuttons, such that once the user selects one the data is retrieved from a table to the gridview and if the other is selected the same happens.

this is my .aspx code containing the radiobutton.

<asp:RadioButtonList ID="Radiobuttonlist1" OnCheckedChange="Radiobuttonlist1_CheckedChange" runat="server">
<asp:ListItem Text="Patients" Value="Patients">asp:ListItem>
<asp:ListItem Text="Suppliers" Value="Suppliers">asp:ListItem>
<asp:ListItem Text="Employees" Value="Employees">asp:ListItem>
asp:RadioButtonList>
<asp:GridView ID="GridView1" runat="server" />

this is my code behind which i have just created only for one radiobutton..kindly help on how to implement the loop.

protected void radioButton1_CheckedChanged(Object sender, EventArgs e)
{
string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
SqlConnection conn = new SqlConnection(connect);
conn.Open();
SqlCommand cmd = new SqlCommand("select PatientName,PatientCellPhone from CustomerInformation where SampleColumn='"+radiobutton1.value.Text + "';",conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
DO NOT keep on repeating your data access code.

Move that code some other class (abstraction) and write methods which will return datasets only.

No database access code in UI classes / pages.
john kanyora8y ago
ThanksNitin, may you kindly show me a sample of how to implement that
john kanyora8y ago
Thanks alot Rajneesh , it has worked
Rajneesh Chaubey8y ago
Use this:
RadioButtonList1.SelectedValue.ToString();
john kanyora8y ago
Am getting an error in this line string Value = radiobutton1.SelectedItem.Value.ToString();
which says that object does not contain a definition for selectedItem
john kanyora8y ago
Thanks alot Rajneesh..this has been of great help to me..
Rajneesh Chaubey8y ago
1. protected void radioButton1_CheckedChanged(Object sender, EventArgs e)
2. {
3. string value=radioButton1.SelectedItem.Value.ToString();
4. if(value=="Patients")
5. {
6. conn.Open();
7. SqlCommand cmd = new SqlCommand("select PatientName,PatientCellPhone from CustomerInformation",conn);
8. SqlDataAdapter da = new SqlDataAdapter(cmd);
9. DataSet ds = new DataSet();
10. da.Fill(ds);
11. conn.Close();
12. GridView1.DataSource = ds;
13. GridView1.DataBind();
14. }
15. else if(value=="Suppliers")
16. {
17. //Suppliers
18. conn.Open();
19. SqlCommand cmd = new SqlCommand("select * from SuppliersInformation",conn);
20. SqlDataAdapter da = new SqlDataAdapter(cmd);
21. DataSet ds = new DataSet();
22. da.Fill(ds);
23. conn.Close();
24. GridView1.DataSource = ds;
25. GridView1.DataBind();
26. }
27. }