ASP.NET Exception : The data source does not support server-side paging

The data source does not support server-side paging
SqlDataReader class does not support paging in ASP.NET.  In above snapshot you can see that your GridView is bind with DataReader instance so if you want to remove this error , replace your DataReader with DataSet or DataTable.

Here are given some easy steps to bind your GridView with Dataset.

 Use DataSet for enable paging

DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();

Paging Example in ASP.NET

ASP.NET Exception : The data source does not support server-side paging ASP.NET Exception : The data source does not support server-side paging Reviewed by Jacob Lefore on October 30, 2013 Rating: 5

No comments