This is application logic this code demonstrates access to the access Database. The result sets are stored in the DataSet and it is assigned to the Datagrid for Datasource.
The result set data's are viewed as per the paging properties which is in HTML view (presentation logic) which is given later.
- using System;
- using System.Collections;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.HtmlControls;
- using System.Data.OleDb;
- namespace Sample {
- /// <summary>
- /// Summary description for WebForm1.
- /// </summary>
- public class WebForm1: System.Web.UI.Page {
- protected System.Web.UI.WebControls.Label Label1;
- protected System.Web.UI.WebControls.DataGrid DataGrid1;
- protected System.Web.UI.WebControls.TextBox TextBox1;
- public DataSet ds = new DataSet();
- public OleDbDataAdapter odap;
- public OleDbConnection con;
- private void Page_Load(object sender, System.EventArgs e) {
- // Put user code to initialize the page here
- if (!this.IsPostBack) {
- con = new OleDbConnection(@ "Provider=Microsoft.JET.OLEDB.4.0;data source=c:\robert\emp.mdb");
- odap = new OleDbDataAdapter("select * from emp", con);
- odap.Fill(ds, "emp");
- DataGrid1.DataSource = ds;
- DataGrid1.DataBind();
- Label1.Text = "Enter the Employee Name";
- }
- }
- # region Web Form Designer generated code
- override protected void OnInit(EventArgs e) {
- //
- // CODEGEN: This call is required by the ASP.NET Web Form Designer.
- //
- InitializeComponent();
- base.OnInit(e);
- }
- /// <summary>
- /// Required method for Designer support - do not modify
- /// the contents of this method with the code editor.
- /// </summary>
- private void InitializeComponent() {
- this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
- this.Load += new System.EventHandler(this.Page_Load);
- }#
- endregion
- private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) {
- DataGrid1.CurrentPageIndex = e.NewPageIndex;
- BindData();
- }
- public void BindData() {
- con = new OleDbConnection(@ "Provider=Microsoft.JET.OLEDB.4.0;data source=c:\robert\emp.mdb");
- odap = new OleDbDataAdapter("select * from emp", con);
- odap.Fill(ds, "emp");
- DataGrid1.DataSource = ds;
- DataGrid1.DataBind();
- }
- }
- }
This part presents the presentation logic.
Paging properties are set in the Datagrid Web Control.
Sanjay DavidPosted Apr 24, 2007, 6:07 AM
Hi could u Explain the Caching Mechanism done in the Pagin in Datagrid. for Each Page Caching the Pages.
Paul NPosted Jan 25, 2007, 5:20 AM
But how do you handle pageindex bound jumps