GridView ObjectDataSource Paging

Took me a lot of time to figure it out...

First, paging doesn't seem to work when ObjectDataSource Select function returns SqlDataReader so it returns DataView now.

The code looks like this:

   1: [DataObjectMethod(DataObjectMethodType.Select)]

   2:     public static DataView GetRows(int statusid, int experienceid, string submitter, string idsid, string SortExpression)

   3:     {

   4:  

   5:         StringBuilder strSql = MainSelectSql(idsid, statusid, experienceid, submitter, SortExpression);

   6:  

   7:         SqlConnection connection = Connection.GetConnection();

   8:         SqlCommand command = new SqlCommand(strSql.ToString(), connection);

   9:         command.CommandType = CommandType.Text;

  10:         SqlDataAdapter adapter = new SqlDataAdapter(command);

  11:  

  12:         //connection.Open();

  13:         DataTable dt = new DataTable();

  14:         adapter.Fill(dt);

  15:         connection.Close();

  16:         int totalRecords = dt.Rows.Count;

  17:  

  18:         DataView dw = new DataView(dt);

  19:  

  20:         return dw;

  21:     }

 

The GridView has to have its "AllowPaging" set to true and PageIndexChanging method looks like this:

   1: protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

   2: {

   3:     GridView gv = (GridView)sender;

   4:     gv.PageIndex = e.NewPageIndex;

   5:     gv.DataBind();

   6: }

 

Also can change the page size in properties...