how to use a loop with radiobutton to retrieve data

Question

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(); }

Nitin Sontakke · 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.

Rajneesh Chaubey · Answer

Use this: RadioButtonList1.SelectedValue.ToString();

john kanyora · Answer

Thanks alot Rajneesh , it has worked

john kanyora · Answer

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 kanyora · Answer

Thanks alot Rajneesh..this has been of great help to me..

Rajneesh Chaubey · Answer

protected void radioButton1_CheckedChanged(Object sender, EventArgs e) { string value=radioButton1.SelectedItem.Value.ToString(); if (value== "Patients" ) { 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" ) { //Suppliers conn.Open(); SqlCommand cmd = new SqlCommand( "select * from SuppliersInformation" ,conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); GridView1.DataSource = ds; GridView1.DataBind(); } }

john kanyora · Answer

ThanksNitin, may you kindly show me a sample of how to implement that