search data from table without send the request to db?

Prasad Bhagat

10y868.NET

Dear All,

i have a procedure for binding the data to html table ,its displyaing all records perfectly,but 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# ,ajax,jqueary web methods.

3 Replies

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

Prasad Bhagat10y ago
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 < dt.Rows.Count; 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 < data.d.length; 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 Kumar10y ago
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 Kumar Singh10y ago
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