Search and filter GridView on TextBox KeyUp event without stored procedure using jQuery AJAX in ASP.Net

Question

How to do it without creatinf procedure and with MySQL

dharmendr · Accepted Answer

Hi  hansheungI have created sample that full fill your requirement You need to change all SqlClient to MySqlClient and the query to my sql queryFor this sample I have used of NorthWind database that you can download using the link given belowDownload Northwind DatabaseHTMLlthtml xmlns34httpwwww3org1999xhtml34gtlthead id34Head134 runat34server34gt    lttitlegtlttitlegt    ltstyle type34textcss34gt        body                    fontfamily Arial            fontsize 10pt                table                    border 1px solid ccc                table th                    backgroundcolor F7F7F7            color 333            fontweight bold                table th table td                    padding 5px            bordercolor ccc            ltstylegt    ltscript type34textjavascript34 src34httpsajaxgoogleapiscomajaxlibsjquery183jqueryminjs34gtltscriptg

Search and filter GridView on TextBox KeyUp event without stored procedure using jQuery AJAX in ASP.Net

Company

Explore

Follow us

Contact Us