DataGrid 示例

最新推荐文章于 2025-04-14 10:11:15 发布

原创最新推荐文章于 2025-04-14 10:11:15 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#datagrid #asp #stylesheet #server #generator #textbox

ASP.NET笔记专栏收录该内容

27 篇文章

订阅专栏

博客涉及ASP相关内容，包含datagrid、textbox等组件，还有server和generator等元素，以及stylesheet样式表相关信息。

部署运行你感兴趣的模型镜像

<HTML>

<HEAD>

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>

</HEAD>

<BODY>

<ASP:LABEL id="Label1" runat="server">Label</ASP:LABEL>

<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">

<ASP:BUTTONCOLUMN text="选择" datatextfield="au_id" headertext="au_id" commandname="Select">

</ASP:BUTTONCOLUMN>

<ASP:HYPERLINKCOLUMN datanavigateurlfield="au_lname" datanavigateurlformatstring="userlist.aspx?lname={0}" datatextfield="au_lname" headertext="au_lname">

</ASP:HYPERLINKCOLUMN>

<ASP:BOUNDCOLUMN datafield="au_fname" headertext="au_fname">

</ASP:BOUNDCOLUMN>

<ASP:TEMPLATECOLUMN headertext="address">

</ITEMTEMPLATE>

</ASP:TEMPLATECOLUMN>

<ASP:EDITCOMMANDCOLUMN buttontype="LinkButton" updatetext="更新" canceltext="取消" edittext="编辑">

</ASP:EDITCOMMANDCOLUMN>

<ASP:BUTTONCOLUMN text="删除" commandname="Delete">

</ASP:BUTTONCOLUMN>

</COLUMNS>

<PAGERSTYLE nextpagetext=">>" prevpagetext="<<" horizontalalign="Center" forecolor="#330099" backcolor="#FFFFCC"></PAGERSTYLE>

</ASP:DATAGRID>

</FORM>

</BODY>

</HTML>

您可能感兴趣的与本文相关的镜像

ACE-Step

音乐合成

ACE-Step

ACE-Step是由中国团队阶跃星辰（StepFun）与ACE Studio联手打造的开源音乐生成模型。它拥有3.5B参数量，支持快速高质量生成、强可控性和易于拓展的特点。最厉害的是，它可以生成多种语言的歌曲，包括但不限于中文、英文、日文等19种语言