search in asp.net values in a datalist view

modeste modeste

13y4.4k.NET

hi every one am coming back again here for that i need your help
i have data in a datalist view and i want to put a textbox above that datalist view so that if the use type for search something in that datalist view the datalist will display what he want in that datalist view if it is available . THANKS SO MUCH

2 Replies

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

modeste modeste13y ago
Much thanks Sanjeeb for your help. today you made may day . am grateful about your help . let me try with this if i get problem i will let you know thanks .
Sanjeeb Lenka13y ago
in your datalist bind method try to code like this:

private void BindData()
{
SqlConnection Con = new SqlConnection("your connectionstring");

if(textbox1.Text==string.Empty)
SqlCommand cmd = new SqlCommand("select * from Depttable ", con);
else
SqlCommand cmd = new SqlCommand("select * from Depttable where id= '" + textBox1.Text + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dtalist1.DataSource = ds;
dtalist1.DataBind();
}

then call this method in your search button click event

this is a sample code if any doubt reply