Hi
I am shailendra singh. Can any one help me.
I want to checked radio button and show data in gridview by function .
My following Function.
public void FillGrid()
{
string qry = "";
if (rbtnstudnm.Checked)
{
qry = "Select StudentId,Name,FathersName,Class,Board,Category from tblStudReg where Name ='" + txtstudname.Text.Trim() + "' and StudStatus='Active' Order By StudentId";
}
if
{
(rbtnstudnm.Checked) qry = "Select StudentId,Name,FathersName,Class,Board,Category from tblStudReg where name like '" + txtstudname.Text.Trim().Replace(" ", "%") + "%' and StudStatus='Active' Order By StudentId";
}
if (rbtnstudcls.Checked && drpalpha.SelectedValue == "All")
{
qry = "select StudentId,Name,FathersName,Class,Board,Category from tblStudReg where Board='" + drpboard.SelectedValue.ToString() + "' and Class='" + drpclass.SelectedValue.ToString() + "' and Medium='" + drpmedium.SelectedValue.ToString() + "' and StudStatus='Active' Order By StudentId";
}
if (rbtnstudcls.Checked && drpalpha.SelectedValue != "All")
{
qry = "select StudentId,Name,FathersName,Class,Board,Category from tblStudReg where Board='" + drpboard.SelectedValue.ToString() + "' and Class='" + drpclass.SelectedValue.ToString() + "' and Medium='" + drpmedium.SelectedValue.ToString() + "' and StudStatus='Active' and name like'" + drpalpha.SelectedValue.ToString() + "%' Order By StudentId";
}
da = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
da.Fill(dt);
lblcount.Text = "No.Of Student Searched : " + Convert.ToString(dt.Rows.Count);
GridView1.DataSource = dt;
GridView1.DataBind();
}
this my function please help me.
Thanks for advance.