Search button with check boxes

Category: ASP.NET
13 Nov 2015 09:50
Joined: 13/03/2015
Level: Silver
Points: 144
Points: 1
Search button with check boxes
hi friends,
how to search the data with check boxes in asp.net
Thanks and Regards,
#763189
13 Nov 2015 09:52
Joined: 13/03/2015
Level: Silver
Points: 144
Points: 1
please check the screen shot.
Delete Attachment
#763191
13 Nov 2015 11:31
Joined: 28/04/2006
Level: Gold
Points: 29959

Points: 4
Hai Sadiq,
There are 2 ways to get the data filtered based on the checkboxes.
1. If the data is limited, you can get all the data at once and then when the user checks a checkbox, filter that data and display.
In this case, you need not to hit the database again and again for the different checkbox checked option.
var dv = _dsBaseDataSet.Tables[0].DefaultView; dv.RowFilter = "filter_criteria";
2. if the database if big, then you can't use the first approach as it will make the performance degrade for the whole application.
In this case, you need to get the data from the database each time when you check the checkbox.
Hope it will be helpful to you.
Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com
#763192
14 Nov 2015 12:22
Joined: 13/03/2015
Level: Silver
Points: 144
Points: 1
Thank you for response,
Can you please send the any source
#763205
16 Nov 2015 09:49
Joined: 16/11/2015
Level: Bronze
Points: 0
Points: 0
#763209
16 Nov 2015 10:04
Joined: 13/03/2015
Level: Silver
Points: 144
Points: 0
#763223
18 Nov 2015 04:03
Joined: 06/10/2010
Level: Gold
Points: 634
Points: 4
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

Joined:	13/03/2015
Level:	Silver
Points:	144

Joined:	13/03/2015
Level:	Silver
Points:	144

Joined:	28/04/2006
Level:	Gold
Points:	29959

Joined:	13/03/2015
Level:	Silver
Points:	144

Search button with check boxes

Email subscription