Hi,
protected void Btn_Search_Click(object sender, EventArgs e)
{
try
{
SqlConnection Con_CheckBox = new SqlConnection(Connection);
Con_CheckBox.Open();
if (Chk_Male.Checked == true)
{
string sql = "SELECT * FROM [HumanResources].[Employee] where Gender='M'";
SqlDataAdapter Adb_CheckBox = new SqlDataAdapter(sql, Con_CheckBox);
DataSet DS_Check = new DataSet();
Adb_CheckBox.Fill(DS_Check);
GridView1.DataSource = DS_Check;
GridView1.DataBind();
}
else
{
string sql = "SELECT * FROM [HumanResources].[Employee] where Gender='F'";
SqlDataAdapter Adb_CheckBox = new SqlDataAdapter(sql, Con_CheckBox);
DataSet DS_Check = new DataSet();
Adb_CheckBox.Fill(DS_Check);
GridView1.DataSource = DS_Check;
GridView1.DataBind();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
}
}
Hope this will help
Regards
Sriram.R