Comments by Member 14574143 (Top 13 by date)

function OnSuccess(response) {
$("[id*=GridView2]").DataTable(
{
bLengthChange: true,
lengthMenu: [[5, 10, -1], [5, 10, "All"]],
bFilter: true,
bSort: true,
bPaginate: true,
data: response.d,
columns: [{ 'data': 'sitecode' },
{ 'data': 'siteid' },
{ 'data': 'region' },
{ 'data': 'bsc' },
{ 'data': 'office' },
{ 'data': 'tier' },
{ 'data': 'category' },
{ 'data': 'subcategory' },
{ 'data': 'owner' }]
});
};


and this is the class icretaed public class Customer
{

public string sitecode { get; set; }
public string siteid { get; set; }
public string region { get; set; }
public string bsc { get; set; }
public string office { get; set; }
public string tier { get; set; }
public string category { get; set; }
public string subcategory { get; set; }
public string owner { get; set; }


}
please support me

i dont know if all row loaded in one go or noti folloed the guide oyu sent to me this is my code:
[WebMethod]
public static List<customer> GetCustomers()
{
MySql.Data.MySqlClient.MySqlConnection conn;
MySql.Data.MySqlClient.MySqlCommand cmd;
string queryStr;

List<customer> customers = new List<customer>();

string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();
conn = new MySql.Data.MySqlClient.MySqlConnection(connstring);
conn.Open();
//queryStr = "";
queryStr = "SELECT * FROM webappdemo.dailtest;";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);

MySql.Data.MySqlClient.MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
customers.Add(new Customer
{
sitecode = dr["sitecode"].ToString(),
siteid = dr["siteid"].ToString(),
region = dr["region"].ToString(),
bsc = dr["bsc"].ToString(),
office = dr["office"].ToString(),
tier = dr["tier"].ToString(),
category = dr["category"].ToString(),
subcategory = dr["subcategory"].ToString(),
owner = dr["owner"].ToString()

});

}

return customers;
}

----------------------------------------------
protected void Page_Load(object sender, EventArgs e)
{
//label11.Text = "dd";



if (!this.IsPostBack)
{
// GVbind();
DataTable dummy = new DataTable();
dummy.Columns.Add("sitecode");
dummy.Columns.Add("siteid");
dummy.Columns.Add("region");
dummy.Columns.Add("bsc");
dummy.Columns.Add("office");
dummy.Columns.Add("tier");
dummy.Columns.Add("category");
dummy.Columns.Add("subcategory");
dummy.Columns.Add("owner");
dummy.Rows.Add();
GridView2.DataSource = dummy;
GridView2.DataBind();
GridView2.UseAccessibleHeader = true;
GridView2.HeaderRow.TableSection = TableRowSection.TableHeader;
}

-----------------------
and this is my page


<asp:gridview id="GridView2" runat="server" cssclass="display compact" autogeneratecolumns="false" onselectedindexchanged="GridView1_SelectedIndexChanged">
<columns>
<asp:boundfield datafield="sitecode" headertext="firstname">
<asp:boundfield datafield="siteid" headertext="middlename">
<asp:boundfield datafield="region" headertext="lastname">
<asp:boundfield datafield="bsc" headertext="email">
<asp:boundfield datafield="office" headertext="phonenumber">
<asp:boundfield datafield="tier" headertext="username">
<asp:boundfield datafield="category" headertext="password">
<asp:boundfield datafield="subcategory" headertext="salt">
<asp:boundfield datafield="owner" headertext="saltpassword">

$(function () {
$.ajax({
type: "POST",
url: "daily.aspx/GetCustomers",
data: '{}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(response.d);
},
error: function (response) {
alert(response.d);
}
});
});
function OnSuccess(response) {
$("[id*=GridView2]"

it seems it doesn't work with tables have more 10000 row is the database, could you advise please

i tried it and it say localhost:44386 says undefined

thanks alot for your support i will try and feedback you

thanks alot i will try it and feedback you but what about changing the pagination button styles ?

how could i make it please also another thing the paging buttons are so classic i want to add button on the page number, thanks alot for your support you are amazing and intelligent!

thanks a lot Richard it is working now , but while the page load it takes about 6 sec to apply the jQuery , is there is any solution to make apply the jQuery immediately.