数据控件-DataGrid数据控件

DataGrid数据控件是3个数据控件中功能最强大的一个。使用DataGrid控件可以自动显示表的内容。利用DataReader对象或者DataSet对象和DataGrid控件进行绑定，就可以进行数据输出。
1、利用DataGrid控件实现分页

< asp:DataGrid ID = " dg "  runat = " server "  AllowPaging = " True "  BorderColor = " Black "
            CellPadding = " 2 "  OnPageIndexChanged = " ChangePage "  PageSize = " 5 " >
             < PagerStyle HorizontalAlign = " Right "  NextPageText = " 后页 "  PrevPageText = " 前页 "   />
             < AlternatingItemStyle BackColor = " #FFFFCD "   />
             < HeaderStyle BackColor = " #AAAADD "   />
</ asp:DataGrid >

protected   void  Page_Load( object  sender, EventArgs e)
    {
        BindGrid();
    }

     private   void  BindGrid()
    {
         string  Provider, DataBase, ConnStr, SQL;
        Provider  =   " Microsoft.Jet.OLEDB.4.0; " ;
        DataBase  =  Server.MapPath( " person.mdb " );
        ConnStr  =   " Provider= "   +  Provider  +   " Data Source= "   +  DataBase;
        SQL  =   " select * from grade " ;
        OleDbDataAdapter da;
        da  =   new  OleDbDataAdapter(SQL, ConnStr);
        DataSet ds  =   new  DataSet();
        da.Fill(ds,  " grade " );
        dg.DataSource  =  ds.Tables[ " grade " ].DefaultView;
        dg.DataBind();
    }

     public   void  ChangePage( object  sender, DataGridPageChangedEventArgs e)
    {
        dg.CurrentPageIndex  =  e.NewPageIndex;
        BindGrid();
    }

可以把前页和后页改成数字显示。修改为PagerStyle-Mode="NumericPages"可以实现数字显示。
一般用表格显示数据的时候，将某列显示成超级链接的形式，用来进一步显示该记录的详细信息。
利用HyperLinkColumn控件设置显示链接的列，DataNavigateUrlField属性表示链接的字段，DataNavigateUrlFormatString属性表示链接的地址。

< asp:DataGrid ID = " dg "  runat = " server "  AllowPaging = " True "  BorderColor = " Black "
            CellPadding = " 2 "  OnPageIndexChanged = " ChangePage "  PageSize = " 5 "  AutoGenerateColumns = " False " >
             < PagerStyle HorizontalAlign = " Right "  NextPageText = " 后页 "  PrevPageText = " 前页 "  Mode = " NumericPages "   />
             < AlternatingItemStyle BackColor = " #FFFFCD "   />
             < HeaderStyle BackColor = " #AAAADD "   />
             < Columns >
             < asp:HyperLinkColumn DataTextField = " 学号 "  HeaderText = " 学号 "
            DataNavigateUrlField = " 学号 "
            DataNavigateUrlFormatString = " test.aspx?id={0} "
            Target = " _blank "   />             
             < asp:BoundColumn DataField = " 姓名 "  HeaderText = " 姓名 "   />
             < asp:BoundColumn DataField = " 数学 "  HeaderText = " 数学成绩 "  ItemStyle - HorizontalAlign = " Right " />
             </ Columns >
         </ asp:DataGrid >

protected   void  Page_Load( object  sender, EventArgs e)
    {
        BindGrid();
    }

     private   void  BindGrid()
    {
         string  Provider, DataBase, ConnStr, SQL;
        Provider  =   " Microsoft.Jet.OLEDB.4.0;