Implement Infinite Scroll in ASP.Net using jQuery AJAX and Linq

Last Reply 9 months ago By dharmendr

Posted 9 months ago

Implement Infinite Scroll (Endless Scroll) in ASP.Net using jQuery AJAX how to do this using Linq

public static DataSet GetCustomersData(int pageIndex)
    string query = "[GetCustomersPageWise]";
   SqlCommand cmd = new SqlCommand(query);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
    cmd.Parameters.AddWithValue("@PageSize", 10);
    cmd.Parameters.Add("@PageCount", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
    return GetData(cmd);
private static DataSet GetData(SqlCommand cmd)
    string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
        using (SqlDataAdapter sda = new SqlDataAdapter())
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataSet ds = new DataSet())
                sda.Fill(ds, "Customers");
                DataTable dt = new DataTable("PageCount");
                dt.Rows[0][0] = cmd.Parameters["@PageCount"].Value;
                return ds;
You are viewing reply posted by: dharmendr 9 months ago.
Posted 9 months ago
Pushpa says:
I am not getting Columns for below stored procedure.

 Will you please explain the above statement in more details.