retrieve data from database table using radiobutton

john kanyora

Hi, am trying to get data from a database table using radiobutton.kindly help on a way to implement it.

below is my code with the radiobutton..i need help with the code behind on how to implement the radiobutton to retrieve the data and also display it on a gridview.

9 Replies

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

Rajneesh Chaubey8y ago
Accepted answer
It is one of column of your tables and used when there is some condition(say
You want to display results where patientname is 'abc').
But I think in your case, you have to display all data from database so remove where condition.
john kanyora8y ago
Thanks Rajneesh, so now it should be like this SqlCommand cmd = new SqlCommand("select PatientName,PatientCellPhone from CustomerInformation ,conn);
john kanyora8y ago
Hi Rajneesh, in reference the below code you did send me i would like to know what does samplecolumn="" mean..

for me i want to have the select statement as select patient name,patientnumber from customerinfo ..
john kanyora8y ago
Thank Rajneesh, would you kindly give me a sample code of ow to implement it
Rajneesh Chaubey8y ago
You can do If else, i.e. first get the value of radiobutton selection and compare if it is patient then bind gridview with query select * from patient.
and similarly for other cases.
john kanyora8y ago
Thanks Rajneesh, i can now see the logic ..my question kindly is also this one, because i want also when i choose patients or suppliers or employees it binds to the gridview, am i going to use a loop or what and if so kindly help me on how to
Rajneesh Chaubey8y ago
It would be something like this:-
radioButton1_CheckedChanged(Object sender,  EventArgs e)
{
string query="select * from Patient Where SampleColumn='" + radiobutton1.value.Text+ "';"
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}
john kanyora8y ago
Thanks Rajneesh, thats great help..would you kindly help me with a sample of how my code behind sholuld be like.in my table i have the name and phone number of patient and that is what i want it to be displayed on my gridview..kindly help
Rajneesh Chaubey8y ago
do you want to bind gridview on the basis of selection of radio button??
If so then bind the gridview on Oncheckedchange of radiobutton.
"Radiobuttonlist1" OnCheckedChange="Radiobuttonlist1_CheckedChange" runat="server">
"Patients" Value="Patients">
"Suppliers" Value="Suppliers">
"Employees" Value="Employees">


"GridView1" runat="server" />
Now specify your logic in that function to bind gridview.
Hope it Helps.
Thanks