利用GridView进行编辑操作

来源：互联网发布：2016总决赛詹姆斯数据编辑：程序博客网时间：2024/05/20 09:11

在Visual Studio 2005中，GridView的使用频率是比较的大，我们可以里用它提供的编辑、删除功能，进行编辑、删除操作，在进行编辑操作时，我们希望我们相对应的表的主键值保持不变，我们可以将某一列，转化为模板列，对木板列进行编辑操作。
HTML代码如下：

<%@ Page Language="C#" AutoEventWireup="true" StylesheetTheme="Default" Theme="Default"

CodeFile="OfficeType.aspx.cs" Inherits="Admin_OfficeType" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>办公用品类型</title>

</head>

<body>

<ul>

</ul>

</div>

</fieldset>

<div>

<legend>办公用品类型列表：</legend>

<asp:GridView ID="gvOfficeType" runat="server" SkinID="Default_GridView" OnRowCancelingEdit="gvOfficeType_RowCancelingEdit"

OnRowEditing="gvOfficeType_RowEditing" OnRowUpdating="gvOfficeType_RowUpdating"

OnRowDataBound="gvOfficeType_RowDataBound">

<asp:BoundField DataField="TypeName" HeaderText="类型名称" />

<asp:TemplateField HeaderText="类型编号">

<asp:TextBox ID="TextBox1" runat="server" Enabled="False" Text='<%# Bind("TypeCode") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("TypeCode") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="是否启用">

<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("IfUsing") %>' Text="启用" />

</EditItemTemplate>

<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("IfUsing") %>' Enabled="false"

Text="启用" />

</ItemTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" CausesValidation="False" />

</Columns>

</asp:GridView>

</fieldset>

<legend>创建办公用品类型</legend>

<tr>

类型名称：

</td>

<asp:TextBox ID="txtTypeName" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtTypeName"

ErrorMessage="类型名称不能为空">*</asp:RequiredFieldValidator></td>

</tr>

<tr>

类型编号：</td>

<asp:TextBox ID="txtTypeCode" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtTypeCode"

ErrorMessage="类型编号不能为空">*</asp:RequiredFieldValidator></td>

</tr>

<tr>

是否启用：</td>

<asp:CheckBox ID="chkUsing" runat="server" Checked="True" Text="启用" /></td>

</tr>

<tr>

<asp:Button ID="btnSave" runat="server" Text="保存" OnClick="btnSave_Click" />

<asp:Button ID="btnCancel" CausesValidation="false" runat="server" Text="取消" OnClick="btnCancel_Click" /><br />

<asp:Label ID="lblInfo" runat="server"></asp:Label></td>

</tr>

</table>

</fieldset>

<ul>

<li>带<span style="color: red">*</span>项不能为空</li></ul>

</fieldset>

</div>

<asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True"

ShowSummary="False" />

</form>

</body>

</html>

以下是后台代码：

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class Admin_OfficeType : System.Web.UI.Page

{

//define class

WebUtility.DataDictionary data;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

this.gvBind();

}

protected void btnCancel_Click(object sender, EventArgs e)

{

this.txtTypeCode.Text = "";

this.txtTypeName.Text = "";

this.lblInfo.Text = "";

}

protected void btnSave_Click(object sender, EventArgs e)

{

data = new WebUtility.DataDictionary();

WebUtility.DataDictionary.OfficeType typeOffice;

typeOffice.TypeName = this.txtTypeName.Text;

typeOffice.TypeCode = this.txtTypeCode.Text;

if (this.chkUsing.Checked)

{ typeOffice.IfUsing = "1"; }

else

{ typeOffice.IfUsing = "0"; }

if (data.IsOfficeType(typeOffice))

{

this.lblInfo.ForeColor = System.Drawing.Color.Red;

this.lblInfo.Text = this.txtTypeName.Text + " 类型已经存在，请重新填写";

return;

}

int i=data.AddOfficeType(typeOffice);

if (i > 0)

{

this.lblInfo.ForeColor = System.Drawing.Color.Green;

this.lblInfo.Text = "办公用品类型添加成功";

this.txtTypeCode.Text = "";

this.txtTypeName.Text = "";

this.gvBind();

}

else

{

this.lblInfo.ForeColor = System.Drawing.Color.Red;

this.lblInfo.Text = "办公用品类型添加失败！";

}

private void gvBind()

{

data = new WebUtility.DataDictionary();

this.gvOfficeType.DataSource = data.DataSetOfficeType(true);

this.gvOfficeType.DataBind();

}

protected void gvOfficeType_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

this.gvOfficeType.EditIndex = -1;

this.gvBind();

}

protected void gvOfficeType_RowEditing(object sender, GridViewEditEventArgs e)

{

this.gvOfficeType.EditIndex = e.NewEditIndex;

this.gvOfficeType.Rows[e.NewEditIndex].Cells[1].Enabled = false;

this.gvBind();

}

protected void gvOfficeType_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

TextBox txtName = (TextBox)this.gvOfficeType.Rows[e.RowIndex].Cells[0].Controls[0];

CheckBox chkIfUsing = (CheckBox)this.gvOfficeType.Rows[e.RowIndex].Cells[2].FindControl("CheckBox1");

TextBox txtCode=(TextBox)this.gvOfficeType.Rows[e.RowIndex].Cells[1].FindControl("TextBox1");

data = new WebUtility.DataDictionary();

WebUtility.DataDictionary.OfficeType typeOffice;

typeOffice.TypeName = txtName.Text;

typeOffice.TypeCode = txtCode.Text;

if (chkIfUsing.Checked)

typeOffice.IfUsing = "1";

else

typeOffice.IfUsing = "0";

int i=data.UpdateOfficeType(typeOffice);

if (i > 0)

{

this.lblInfo.ForeColor = System.Drawing.Color.Green;

this.lblInfo.Text = "办公用品类型更新成功";

}

else

{

this.lblInfo.ForeColor = System.Drawing.Color.Red;

this.lblInfo.Text = "办公用品类型更新失败！";

}

this.gvOfficeType.EditIndex = -1;

this.gvBind();

}

protected void gvOfficeType_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='linen'");

e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");

}