private void search1_TextChanged(object sender, EventArgs e)
{
String keywords = search1.Text;
if (keywords != null)
{
DataTable dt = dal.Search(keywords);
dataGridView1.DataSource = dt;
}
else
{
DataTable dt = dal.Select();
dataGridView1.DataSource = dt;
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
//Get Keyword from Text box
string keyword = txtsearch.Text;
//Check if the keywords has value or not
if (keyword != null)
{
//Show user based on keywords
DataTable dt = dal.Search(keyword);
dgvusers.DataSource = dt;
}
else
{
//show all users from the database
DataTable dt = dal.select();
dgvusers.DataSource = dt;
}
}