binding search results

Question

Hai All i have a search box in master page ....i completed auto completion for that search box.now i need to bind the record as per search in datalist when user clicks search button i dont know how to start any suggestions?? Thanks an Regards

Iftikar Hussain · Answer

where you have declared your datalist? is it in same page or not? Regards Iftikar

aditya immadi · Answer

dlPaging is not in current context this error coming...

Iftikar Hussain · Answer

try like this protected void BtnSearch_Click(object sender EventArgs e) { string strConnString = ConfigurationManager.ConnectionStrings[conString].ConnectionString; var name = txtSearch.Text; using (SqlConnection con = new SqlConnection(strConnString)) { string query = select *from User where Name like '% + name + %'; con.Open(); SqlCommand cmd = new SqlCommand(query con); DataTable dt = new DataTable(); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(cmd); sqlDataAdapter.Fill(dt); dlPaging.DataSoure = dt; con.Close(); } } Regards Iftikar

aditya immadi · Answer

Width=100% BorderColor=#336699 BorderStyle=Solid BorderWidth=2px OnItemCommand=dlPaging_ItemCommand OnItemDataBound=dlPaging_ItemDataBound> ImageUrl=' ' /> '> '> '> '> '> with the help of this code i m goin to bind all the records and the jquery i used for the auto completion search is script src =scripts/jquery-1.4.1.min.js type =text/javascript> script > script src =scripts/jquery.autocomplete.js type =text/javascript> script > script type =text/javascript> $(document).ready( function () { $( #  ).autocomplete( Search.ashx  { width: 200 formatItem: function (data i n value) { return  + value.split(  )[1] + '/>  + value.split(  )[0]; } formatResult: function (data value) { return value.split(  )[0]; } }); });

Iftikar Hussain · Answer

Hi Please provide your normal datalist query bind code. Regards Iftikar