DataGrid 示例

<% @ Page Language="C#" %> <% @ Import Namespace="System.Data" %> <% @ Import Namespace="System.Data.SqlClient" %> < HTML >   < HEAD >    < TITLE > 1 TITLE>   <SCRIPT language="C#" runat="server">   private void Page_Load(object sender, System.EventArgs e)   {    if(!IsPostBack)    {     dgBind();    }      }   private void dgBind()   {    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["pubs"]);    string sqlStr = "SELECT au_id, au_lname, au_fname, address FROM authors";    SqlDataAdapter da = new SqlDataAdapter(sqlStr, conn);    DataTable dt = new DataTable();    da.Fill(dt);    da.Dispose();    conn.Close();    dg.DataSource = dt;    dg.DataBind();   }   #region Web 窗体设计器生成的代码   override protected void OnInit(EventArgs e)   {    //    // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。    //    InitializeComponent();    base.OnInit(e);   }      ///    /// 设计器支持所需的方法 - 不要使用代码编辑器修改   /// 此方法的内容。   ///    private void InitializeComponent()   {        this.dg.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg_PageIndexChanged);    this.dg.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_CancelCommand);    this.dg.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_EditCommand);    this.dg.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_UpdateCommand);    this.dg.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_DeleteCommand);    this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);    this.dg.SelectedIndexChanged += new System.EventHandler(this.dg_SelectedIndexChanged);    this.Load += new System.EventHandler(this.Page_Load);   }   #endregion   private void Button1_Click(object sender, System.EventArgs e)   {   }   private void dg_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)   {    dg.EditItemIndex = -1;    dg.SelectedIndex = e.Item.ItemIndex;    dgBind();   }   private void dg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)   {    string au_id = dg.DataKeys[e.Item.ItemIndex].ToString();    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["pubs"]);    string sqlStr = "DELETE FROM authors WHERE au_id = '" + au_id + "'";    SqlCommand cmd = new SqlCommand(sqlStr, conn);    conn.Open();    cmd.ExecuteNonQuery();    conn.Close();    dgBind();   }   private void dg_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)   {    dg.EditItemIndex = e.Item.ItemIndex;    dg.SelectedIndex = e.Item.ItemIndex;    dgBind();   }   private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)   {    dg.Controls[0].EnableViewState = false;   }   private void dg_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)   {    string au_id = dg.DataKeys[e.Item.ItemIndex].ToString();    string au_fname = ((TextBox)(e.Item.Cells[2].FindControl("_ctl2"))).Text;    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["pubs"]);    string sqlStr = "UPDATE authors SET au_fname = '" + au_fname + "' WHERE ";    sqlStr += "au_id = '" + au_id + "'";    Response.Write(sqlStr);    SqlCommand cmd = new SqlCommand(sqlStr, conn);    conn.Open();    cmd.ExecuteNonQuery();    conn.Close();    dg.EditItemIndex = -1;    dg.SelectedIndex = -1;    dgBind();   }   private void dg_SelectedIndexChanged(object sender, System.EventArgs e)   {    Label1.Text = dg.DataKeys[dg.SelectedIndex].ToString();    dg.EditItemIndex = dg.SelectedIndex;    dgBind();   }   private void dg_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)   {    dg.EditItemIndex = -1;    dg.SelectedIndex = -1;    dg.CurrentPageIndex = e.NewPageIndex;    dgBind();   }    SCRIPT>   <META content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">   <META content="C#" name="CODE_LANGUAGE">   <META content="JavaScript" name="vs_defaultClientScript">   <META content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">   <LINK href="style.css" type="text/css" rel="stylesheet">   HEAD>  <BODY>   <FORM id="Form1" method="post" runat="server">    <ASP:LABEL id="Label1" runat="server">Label ASP:LABEL><BR>    <BR>    <ASP:DATAGRID id="dg" runat="server" bordercolor="#CC9966" borderstyle="None" borderwidth="1px"     backcolor="White" cellpadding="4" allowsorting="True" allowpaging="True" pagesize="7" width="600px"     autogeneratecolumns="False" datakeyfield="au_id">     <SELECTEDITEMSTYLE font-bold="True" horizontalalign="Center" forecolor="#663399" backcolor="#FFCC66"> SELECTEDITEMSTYLE>     <ITEMSTYLE horizontalalign="Center" forecolor="#330099" backcolor="White"> ITEMSTYLE>     <HEADERSTYLE font-bold="True" horizontalalign="Center" forecolor="#FFFFCC" backcolor="#990000"> HEADERSTYLE>     <FOOTERSTYLE forecolor="#330099" backcolor="#FFFFCC"> FOOTERSTYLE>     <COLUMNS>      <ASP:BUTTONCOLUMN text="选择" datatextfield="au_id" headertext="au_id" commandname="Select">       <HEADERSTYLE width="100px"> HEADERSTYLE>       ASP:BUTTONCOLUMN>      <ASP:HYPERLINKCOLUMN datanavigateurlfield="au_lname" datanavigateurlformatstring="userlist.aspx?lname={0}"  datatextfield="au_lname" headertext="au_lname">       <HEADERSTYLE width="80px"> HEADERSTYLE>       ASP:HYPERLINKCOLUMN>      <ASP:BOUNDCOLUMN datafield="au_fname" headertext="au_fname">       <HEADERSTYLE width="80px"> HEADERSTYLE>       ASP:BOUNDCOLUMN>      <ASP:TEMPLATECOLUMN headertext="address">       <ITEMSTYLE horizontalalign="Left"> ITEMSTYLE>       <ITEMTEMPLATE>        <%# DataBinder.Eval(Container.DataItem, "address") %>        ITEMTEMPLATE>       ASP:TEMPLATECOLUMN>      <ASP:EDITCOMMANDCOLUMN buttontype="LinkButton" updatetext="更新" canceltext="取消" edittext="编辑">       <HEADERSTYLE width="70px"> HEADERSTYLE>       ASP:EDITCOMMANDCOLUMN>      <ASP:BUTTONCOLUMN text="删除" commandname="Delete">       <HEADERSTYLE width="50px"> HEADERSTYLE>       ASP:BUTTONCOLUMN>      COLUMNS>     <PAGERSTYLE nextpagetext=">>" prevpagetext="<<" horizontalalign="Center" forecolor="#330099" backcolor="#FFFFCC"> PAGERSTYLE>     ASP:DATAGRID>    FORM>   BODY> HTML>