filtering gridview with two textboxes in c#

prasanna shah

dear friend,

i have two textboxes for id and name and below the textboxes i have a gridview. So i want to filter the gridview by entering id or name or both. But if i enter id then name, the data should not be appeared in gridview if both id and name do not match. It should only show the data if both id and name matches. I did it on text change event.

for example, sunil chaudhari has id 1. If i put 1 in id tetxtbox it shows the data, but if i put ramesh in name textbox then the id and name does not match and the data should not be shown on the gridview.

please any could help me. I would be very thankful.

thank you

prasanna

6 Replies

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

Upendra Pratap Shahi11y ago
Hello prasanna shah,

Kindly accept the solution for better discussion on forum.
prasanna shah11y ago
thanks, it worked, thank you very much for the help.
Govinda Rajulu Yemineni11y ago
Hi,

In Gridview define Search Not Found if data is not match with search criteria
protected void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection ("server=servername;Uid=uid;pwd=pwd;Database=dbname");
string strsql = "select * from tblname where id like '%" + txtid.Text + "%' and name like '%" + txtname.Text + "%' order by id";
SqlCommand cmd = new SqlCommand(strsql , con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt)
gvUsers.DataSource = dt;

gvUsers.DataBind();
}
Amitesh Verma11y ago
try using if else condition .if textbox1 is not null ,then condition,else if textbox1 and textbox2 is not null then condition.
Upendra Pratap Shahi11y ago
Hello,

Use below code for your problem-

protected void btnSearch_Click(object sender, EventArgs e)

{

string searchsql = "select * from tblname where id like '%" + txt_id.Text + "%' and name like '%" + txt_name.Text + "%' order by id desc ";
SqlCommand cmd = new SqlCommand(searchsql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt != null)
{
if(dt.Rows.Count>0)
{
gvUsers.DataSource = dt;
gvUsers.DataBind();
}
}

}
Raja T11y ago
Hi,

try below code like add one Search button

protected void btnSearch_Click(object sender, EventArgs e)
{
string searchsql = "select * from tblname where id like '%" + txt_id.Text + "%' and name like '%"+txt_name.Text+"%' order by id desc ";
SqlDataAdapter da = new SqlDataAdapter(searchsql, con);
DataTable dt = new DataTable();
da.Fill(dt);
gvUsers.DataSource = dt;
gvUsers.DataBind();
}