ComponentArt Method------NeedDataSource etc.

public void OnNeedDataSource(object sender, EventArgs oArgs)
  {
    buildGrid();
  }

 private void buildGrid()
  {
    string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; 
    conStr += Server.MapPath("~/common/db/demo.mdb"); 
    System.Data.OleDb.OleDbConnection dbCon = new System.Data.OleDb.OleDbConnection(conStr); 
    dbCon.Open(); 

    string sql = "SELECT * FROM Posts ORDER BY LastPostDate DESC"; 
    System.Data.OleDb.OleDbDataAdapter dbAdapter = new System.Data.OleDb.OleDbDataAdapter(sql, dbCon); 
    DataSet ds = new DataSet(); 
    dbAdapter.Fill(ds); 
    ds.Tables[0].TableName = "Inbox"; 

    Grid1.DataSource = ds;
  }

1 public void OnPageChanged(object sender, ComponentArt.Web.UI.GridPageIndexChangedEventArgs oArgs)
2  {
3    Grid1.CurrentPageIndex = oArgs.NewIndex;
4  }
5
6  public void OnSort(object sender, ComponentArt.Web.UI.GridSortCommandEventArgs oArgs)
7  {
8    Grid1.Sort = oArgs.SortExpression;
9  }

1private void InitializeComponent()
2    {    
3        this.Load += new System.EventHandler(this.Page_Load);      
4    Grid1.NeedRebind += new ComponentArt.Web.UI.Grid.NeedRebindEventHandler(OnNeedRebind);
5    Grid1.NeedDataSource += new ComponentArt.Web.UI.Grid.NeedDataSourceEventHandler(OnNeedDataSource);
6    Grid1.PageIndexChanged += new ComponentArt.Web.UI.Grid.PageIndexChangedEventHandler(OnPageChanged);
7    Grid1.SortCommand += new ComponentArt.Web.UI.Grid.SortCommandEventHandler(OnSort);
8  }