search data from table without send the request to db?

Question

Dear All i have a procedure for binding the data to html table its displyaing all records perfectlybut now am going to search data based on that table content its means search data from the given bellow html table disply in same table .am how can i do that basically if we want to search anything we write a procedure with like function but my mngr asking for after databinding to html table search the record within the html table only dont wont go for database .so please give me some example on the same . am using asp.net c# ajaxjqueary web methods.

Prasad Bhagat · Answer

Dear AMIT i have a code like bellow: [WebMethod] public static List GetBind() { List obj = new List (); SqlConnection conn = newSqlConnection(ConfigurationManager.ConnectionStrings[CS].ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand(usp_searchdata conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); DataTable dt = ds.Tables[0]; //JavaScriptSerializer objse = new JavaScriptSerializer(); //data = objse.Serialize(ds); EMP emp; for (int i = 0; i { emp = new EMP(); emp.id = Convert.ToInt32(dt.Rows[i][id].ToString()); emp.Name = dt.Rows[i][Name].ToString(); emp.Salary = dt.Rows[i][Salary].ToString(); emp.Phone = dt.Rows[i][Phone].ToString(); obj.Add(emp); } return obj; } } now my ajax call is : $(document).ready(function () { debugger bindData(); }); function bindData(str) { var str = $(#txtSearch).val(); $(#tbDetails).empty(); $.ajax({ type: POST url: Default.aspx/GetBind data: {} contentType: application/json; charset=utf-8 dataType: json success: function (data) { debugger for (var i = 0; i { $(#tbDetails).append(  + data.d[i].id +   + data.d[i].Name +   + data.d[i].Salary +   + data.d[i].Phone +  ); } } error: function (response) { debugger alert(error); } }); } after these operation i want search using some parameters but that request don't go for database need to fetch the data from above data only .please tell me if possible

Amit Kumar · Answer

Hi dear First you have to take table data in DataView like: dt is a table which contains all data Dim dv As New DataView(dt) (vb.net) DataView dv =new DataView() (C#.net) After that you can use search machenism like: dv.RowFilter = String.Format(Category=' + searchvalue.Trim() + ') Then Bind your control like .. Gvd.DataSource=dv; Gvd.DataBind(); Please use it .It work properly..

Amit Singh · Answer

1.http://www.dotnetcurry.com/aspnet-mvc/1046/search-table-grid-aspnet-webapi-jquery-knockout 2.http://www.webcodeexpert.com/2013/09/how-to-bind-and-implement-search.html