binding search results

aditya immadi

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

5 Replies

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

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

Regards,
Iftikar
aditya immadi13y ago
dlPaging is not in current context this error coming...
Iftikar Hussain13y ago
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 immadi13y ago
   Width="100%" BorderColor="#336699" BorderStyle="Solid" BorderWidth="2px"
    OnItemCommand="dlPaging_ItemCommand" OnItemDataBound="dlPaging_ItemDataBound">





               ImageUrl='<%# Bind("image", "~/Images-candidates/{0}")%>' />


    '">
















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() {

$("#<%=txtSearch.ClientID%>").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 Hussain13y ago
Hi,
Please provide your normal datalist query bind code.

Regards,
Iftikar