<%
@ 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> |
DataGrid 示例
最新推荐文章于 2021-11-21 21:29:01 发布