How to Play with DataGrid Control - The Page_Load Event Handler

(Page 3 of 7 )

When the page loads each time, either when the user opens the page for the first time or in response to a click by the user on the paging controls, our Page_Load event handler is executed. Here I am not using any business process or initializing DataGrid and their properties.

Subroutine BindGrid()

void BindGrid()
{
 try
 {
  dgNonApproveList.DataSource=GetRecord(recordstring);
  dgNonApproveList.DataBind();
 }
 catch(Exception e1)
 {
  Response.Write("Error! "+e1.Message+" Please contact your software development team.");
 }
}

Here we simply bind the dgNonApproveList.DataSource=GetRecord (recordstring)

private ICollection GetRecord(string recordstring)
{
 string strConn=System.Configuration.ConfigurationSettings.AppSettings["strConn"];
 SqlConnection sqlConn = new SqlConnection(strConn);
  
 SqlCommand sqlCommUserList = new SqlCommand(recordstring,sqlConn);
 SqlDataAdapter da = new SqlDataAdapter(sqlCommUserList);
 DataSet ds = new DataSet();
 da.Fill(ds,"table");
 return ds.Tables["table"].DefaultView;
} 

Here in GetRecord we are passing the querystring and this function will return DataView as Icollection.

We have selected the text-style paging option and entered different text for the pager lines. We have also changed numbers of rows that should appear in each page, and you can see the results.

public void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e)
{
 dgNonApproveList.CurrentPageIndex = e.NewPageIndex;
 BindGrid();
}

As you can see, all we have to do is collect the index number of the page that the user selected from the NewPageIndex property of the page DataGridPageChangedEventArgs object that is passed to our event handler when the event occurs. We have assigned this value to the CurrentPageIndex property of the DataGrid, and then call our BindGrid routine to fetch, bind and display the appropriate page of data rows.

Next: Editing >>
 

More ASP.NET Articles
More By Mayank Gupta

Comments On: How to Play with DataGrid Control

>>> Be the FIRST to comment on this article!