做了一个示例,用户更新的数据保存在Session中,点击“更新数据源”按钮后将Session中的数据更新到数据库中,可以在 http://www.webdiyer.com/demo/editdatagrid.aspx 看到演示效果:
文件代码:
test.aspx
===========================>
<%@ Page Language="C#" Debug="True"%>
<%@Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient" %>
![](/Images/OutliningIndicators/None.gif)
<script language="C#" runat="server">
const string DataTableName="Employees";
SqlConnection conn;
SqlDataAdapter adapter;
void Page_Load(Object src, EventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
conn=new SqlConnection("server=(local);database=pubs;uid=sa;pwd=");
adapter=new SqlDataAdapter("select * from employees",conn);
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(!Page.IsPostBack)
{
BindData();
}
}
![](/Images/OutliningIndicators/None.gif)
//绑定数据
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void BindData()
{
//先从Session中获取DataTable
DataTable table=(DataTable)Session[DataTableName];
//若Session中的DataTable不存在,则从数据库获取数据
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(table==null)
{
table=new DataTable();
adapter.Fill(table);
//将DataTable保存到Session中
SaveTableToSession(table);
table.Columns["id"].AutoIncrement=true;
}
grid.DataSource=table;
grid.DataBind();
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void ChangePage(object src,DataGridPageChangedEventArgs e)
{
grid.CurrentPageIndex=e.NewPageIndex;
BindData();
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void UpdateDataTable(object src,EventArgs e)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
try
{
DataTable table=GetTableFromSession();
string name;
byte age;
string address;
CheckBox ckdel;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
for(int i=0;i<grid.Items.Count;i++)
{
DataGridItem dgitem=grid.Items[i];
int empId=(int)grid.DataKeys[dgitem.ItemIndex];
ckdel=dgitem.FindControl("delckb") as CheckBox;
name=((TextBox)dgitem.Cells[0].Controls[1]).Text;
age=byte.Parse(((TextBox)dgitem.Cells[1].Controls[1]).Text);
address=((TextBox)dgitem.Cells[2].Controls[1]).Text;
UpdateEmployee(table,empId,name,age,address,ckdel.Checked);
}
SaveTableToSession(table);
cancelbtn.Enabled=true;
int rowcount=0;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
foreach(DataRow row in table.Rows)
{
if(row.RowState!=DataRowState.Deleted)
rowcount++;
}
if(Math.Ceiling(rowcount/5.0)==grid.CurrentPageIndex&&grid.CurrentPageIndex>0)
grid.CurrentPageIndex-=1;
BindData();
msglbl.Text="更新数据表成功!";
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
catch(Exception ex)
{
msglbl.Text="更新数据表失败,出现意外错误:"+ex.Message;
}
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void UpdateEmployee(DataTable table,int id,string name,byte age,string address,bool isDelete)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
for(int i=0;i<table.Rows.Count;i++)
{
DataRow row=table.Rows[i];
//如果选中了删除复选框,就直接就该行数据删除,不用再更新,否则更新该行数据
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(row!=null&&row.RowState!=DataRowState.Deleted)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if((int)row["id"]==id)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(!isDelete)
{
row["name"]=name;
row["age"]=age;
row["address"]=address;
}
else
row.Delete();
}
}
}
msglbl.Text="更新数据表成功!";
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void UpdateDataBase(object src,EventArgs e)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
try
{
DataTable table=GetTableFromSession();
SqlCommandBuilder cmdbd=new SqlCommandBuilder(adapter);
adapter.Update(table);
msglbl.Text="更新数据源成功!";
cancelbtn.Enabled=false;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
catch(Exception ex)
{
msglbl.Text="更新数据源失败,出现意外错误:"+ex.Message;
}
BindData();
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void CancelUpdate(object src,EventArgs e)
{
DataTable table=GetTableFromSession();
table.RejectChanges();
grid.CurrentPageIndex=0;
BindData();
cancelbtn.Enabled=false;
}
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void AddNewEmployee(object src,DataGridCommandEventArgs e)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(e.CommandName=="Add")
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
try
{
DataTable table=GetTableFromSession();
string name=((TextBox)e.Item.FindControl("newname")).Text;
byte age=byte.Parse(((TextBox)e.Item.FindControl("newage")).Text);
string address=((TextBox)e.Item.FindControl("newaddress")).Text;
DataRow row=table.NewRow();
row["name"]=name;
row["age"]=age;
row["address"]=address;
table.Rows.Add(row);
SaveTableToSession(table);
//重新绑定数据
BindData();
msglbl.Text="添加新记录成功!";
cancelbtn.Enabled=true;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
catch(Exception ex)
{
msglbl.Text="未能添加新记录,出现意外错误:"+ex.Message;
}
}
}
![](/Images/OutliningIndicators/None.gif)
//将DataTable保存到session中
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
void SaveTableToSession(DataTable table)
{
Session[DataTableName]=table;
}
![](/Images/OutliningIndicators/None.gif)
//从Session中获取DataTable
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
DataTable GetTableFromSession()
{
DataTable table=(DataTable)Session[DataTableName];
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(table!=null)
{
return table;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
else
{
msglbl.Text="未能从Session中获取数据,可能Session已超时,请刷新或重新打开当前页面!";
return null;
}
}
</script>
<html>
<head>
<title> Webdiyer制造:)</title>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="Webdiyer(http://www.webdiyer.com)">
</head>
<body>
![](/Images/OutliningIndicators/None.gif)
<form runat="server">
<asp:DataGrid runat="server" id="grid" AutogenerateColumns=false DataKeyField="id" ShowFooter=true AllowPaging=true PageSize=5 OnPageIndexChanged="ChangePage" PagerStyle-Mode="numericpages" OnItemCommand="AddNewEmployee">
<Columns>
<asp:TemplateColumn HeaderText="姓名">
<ItemTemplate>
<asp:TextBox runat="server" id="name" Text='<%#DataBinder.Eval(Container.DataItem,"name")%>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox runat="server" id="newname"/>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="年龄">
<ItemTemplate>
<asp:TextBox runat="server" id="age" Text='<%#DataBinder.Eval(Container.DataItem,"age")%>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox runat="server" id="newage"/>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="住址">
<ItemTemplate>
<asp:TextBox runat="server" id="address" Text='<%#DataBinder.Eval(Container.DataItem,"address")%>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox runat="server" id="newaddress"/>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="删除">
<ItemTemplate>
<asp:CheckBox runat="server" id="delckb"/>
</ItemTemplate>
<FooterTemplate>
<asp:Button runat="server" Text="添加" CommandName="Add"/>
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
<asp:Label runat="server" EnableViewState="false" id="msglbl" ForeColor="red"/>
<div>
<asp:Button runat="server" id="updatebtn" Text="更新数据表" OnClick="UpdateDataTable"/>
<asp:Button runat="server" id="cancelbtn" Text="取消对数据表的更新" Enabled=false OnClick="CancelUpdate"/>
<asp:Button runat="server" id="updatedbtbn" Text="更新数据源" OnClick="UpdateDataBase"/>
</div>
<div>
说明:DataGrid中的数据类型都没有进行验证,如果输入错误的数据类型或空值可能会出错,实际应用中应该对用户输入的数据进行验证!
</div>
</form>
![](/Images/OutliningIndicators/None.gif)
</body>
</html>
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
数据库中employees表结构:
![](/Images/OutliningIndicators/None.gif)
CREATE TABLE employees (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[age] [tinyint] NOT NULL ,
[address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
ALTER TABLE employees ADD
CONSTRAINT [PK_employees] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)