Display search record in GridVIew

Question

Hi, I am working in Jquery and I want to search record through autocomplete textbox and after click on button all related record display in gridview please help how can do this ?

Davin Martyn · Answer

script type ="text/javascript"> $(document).ready( function () { $( "#btnLoad" ).click( function () { $.ajax({ type: "POST" , url: "Default.aspx/GetEmpNames" , data: "{}" , contentType: "application/json; charset=utf-8" , dataType: "json" , success: function (r) { for ( var i = 0; i $( "#gvAuthors" ).append( " " + r.d[i].Loan_id + " " + r.d[i].Name + " " + r.d[i].Name + " " ); } } }); }); }); $( function () { $( "[id$=txtSearch]" ).autocomplete({ source: function (request, response) { $.ajax({ url: ' ' , data: "{ 'empName': '" + request.term + "'}" , dataType: "json" , type: "POST" , contentType: "application/json; charset=utf-8" , success: function (data) { response($.map(data.d, function (item) { return { label: item.split( '-' )[0], val: item.split( '-' )[1] } })) }, error: function (response) { alert(response.responseText); }, failure: function (response) { alert(response.responseText); } }); }, select: function (e, i) { $( "[id$=hfCustomerId]" ).val(i.item.val); }, minLength: 1 }); }); Please check my code my record in display textbox but when we click on button gridview not display please check ?

Davin Martyn · Answer

Please check my code : $(document).ready(function () { $("#btnLoad").click(function () { $.ajax({ type: "POST", url: "Default.aspx/GetEmpNames", data: "{}", contentType: "application/json; charset=utf-8", dataType: "json", success: function (r) { for (var i = 0; i " + r.d[i].Loan_id + " " + r.d[i].Name + " " + r.d[i].Name + " "); } } }); }); }); $(function () { $("[id$=txtSearch]").autocomplete({ source: function (request, response) { $.ajax({ url: ' ', data: "{ 'empName': '" + request.term + "'}", dataType: "json", type: "POST", contentType: "application/json; charset=utf-8", success: function (data) { response($.map(data.d, function (item) { return { label: item.split('-')[0], val: item.split('-')[1] } })) }, error: function (response) { alert(response.responseText); }, failure: function (response) { alert(response.responseText); } }); }, select: function (e, i) { $("[id$=hfCustomerId]").val(i.item.val); }, minLength: 1 }); }); I am facing a problem after search record in textbox my record is display but when we click no button then gridview value is not display please check and assist to me very urgent?

Davin Martyn · Answer

Please check my code : $(document).ready(function () { $("#btnLoad").click(function () { $.ajax({ type: "POST", url: "Default.aspx/GetEmpNames", data: "{}", contentType: "application/json; charset=utf-8", dataType: "json", success: function (r) { for (var i = 0; i " + r.d[i].Loan_id + " " + r.d[i].Name + " " + r.d[i].Name + " "); } } }); }); }); $(function () { $("[id$=txtSearch]").autocomplete({ source: function (request, response) { $.ajax({ url: ' ', data: "{ 'empName': '" + request.term + "'}", dataType: "json", type: "POST", contentType: "application/json; charset=utf-8", success: function (data) { response($.map(data.d, function (item) { return { label: item.split('-')[0], val: item.split('-')[1] } })) }, error: function (response) { alert(response.responseText); }, failure: function (response) { alert(response.responseText); } }); }, select: function (e, i) { $("[id$=hfCustomerId]").val(i.item.val); }, minLength: 1 }); }); I am facing a problem after search record in textbox my record is display but when we click no button then gridview value is not display please check and assist to me very urgent?

Rajeesh Menoth · Answer

Hi, Check the grid bind section..

Davin Martyn · Answer

I have searched record from textbox and after click my gridview not display please help?

Rajeesh Menoth · Answer

Hi, Ref the following article : 1) http://jqueryasp.net/search-gridview-records-on-textbox-keypress-using-jquery-in-asp-net/ 2) http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html

Shridhar Sharma · Answer

Hi Davin, Please follow this url for search values from database autocomplete textbox http://www.c-sharpcorner.com/code/1573/search-data-from-database-using-auto-complete-functionality.aspx After getting that value you can bind it in GridView. Hope this will help you.

Raja T · Answer

Hi, please check out... http://www.aspsnippets.com/Articles/Search-GridView-records-data-on-TextBox-KeyPress-using-jQuery-in-ASPNet.aspx http://www.encodedna.com/gridview/tutorial/search-records-in-gridview-using-filterparameters.htm

Display search record in GridVIew

Answers (8)