一次更新Datagrid 中多列数据
在datagrid中一般我们只需一列列的更新数据，但有时需一次更新所有列中数据，提高数据编辑效率。
为了方便演示用xml文件做为数据源
xml文件：（UserInfo.xml）
<?xml version="1.0" standalone="yes"?>
<UserInfos>
<UserInfo>
<Email>some@you.net</Email>
<Name>me</Name>
<TEL>0123456</TEL>
</UserInfo>
<UserInfo>
<Email>youraddress@you.com</Email>
<Name>he</Name>
<TEL>7894563</TEL>
</UserInfo>
<UserInfo>
<Email>youraddress@you.com</Email>
<Name>222</Name>
<TEL>123342</TEL>
</UserInfo>
<UserInfo>
<Email>youraddress@you.com</Email>
<Name>haha</Name>
<TEL>3545445</TEL>
</UserInfo>
<UserInfo>
<Email>youraddress@you.com</Email>
<Name>sam</Name>
<TEL>879563</TEL>
</UserInfo>
</UserInfos>
页面代码：
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DGrid" runat="server" ShowFooter="True" GridLines="None" CellPadding="2" AutoGenerateColumns="False">
<HeaderStyle Font-Bold="True"></HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="名字">
<ItemTemplate>
<asp:TextBox id=Name runat="server" Width="109px" Text='<%# DataBinder.Eval(Container, "DataItem.Name") %>'>
</asp:TextBox>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="NewName" runat="server" Width="109px"></asp:TextBox>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="电话">
<ItemTemplate>
<asp:TextBox id=TEL runat="server" Width="109px" Text='<%# DataBinder.Eval(Container, "DataItem.TEL") %>'>
</asp:TextBox>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="NewTEL" runat="server" Width="109px"></asp:TextBox>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Email">
<ItemTemplate>
<asp:TextBox id=Email runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Email") %>'>
</asp:TextBox>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox id="NewEmail" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="删除">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:CheckBox Runat="server" ID="chkDelete"></asp:CheckBox>
</ItemTemplate>
<FooterStyle HorizontalAlign="Center"></FooterStyle>
<FooterTemplate>
<asp:LinkButton Runat="server" Text="增加" CommandName="Add" ID="Linkbutton1"></asp:LinkButton>
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
<asp:Button id="btnUpdate" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 208px" runat="server"
Text="更新"></asp:Button>
</form>
后台代码：
private DataSet dsUser;//定义dsUser
private void Page_Load(object sender, System.EventArgs e)
{
// 读取XML 文件.到dataset中
dsUser = new DataSet();
dsUser.ReadXml(Server.MapPath("UserInfo.xml"));
if (!Page.IsPostBack )
{
BindData();
}
}
private void BindData()
{
// datagrid绑定dataset
DataView dv = new DataView(dsUser.Tables["UserInfo"]);
DGrid.DataSource = dv;
DGrid.DataBind();
}
//把dataset保存到xml文件
private void Save()
{
dsUser.WriteXml(Server.MapPath("UserInfo.xml"));
}
private void DGrid_ItemCommand(object source , System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
//增加一行到dataset中。使用了arrary结构
if (e.CommandName == "Add")
{
string[] sUser = {"", "", ""};
sUser[0] = ((TextBox)e.Item.FindControl("NewEmail")).Text;
sUser[1] = ((TextBox)e.Item.FindControl("NewName")).Text;
sUser[2] = ((TextBox)e.Item.FindControl("NewTEL")).Text;
dsUser.Tables["UserInfo"].Rows.Add(sUser);
Save();
}
BindData();
}
private void btnUpdate_Click(object sender, System.EventArgs e)
{
// 遍历datagrid中所有列.
foreach (DataGridItem di in DGrid.Items)
{
//不遍历datagrid中的 header or footer.
if (di.ItemType == ListItemType.Item || di.ItemType == ListItemType.AlternatingItem)
{
DataRow dr = dsUser.Tables["UserInfo"].Rows.Find(DGrid.DataKeys[di.ItemIndex]);
// 如果删除被选中.
if (((CheckBox)di.FindControl("chkDelete")).Checked)
{
dsUser.Tables["UserInfo"].Rows.Remove(dr);
}
else
{
// 更新
dr["Email"] = ((TextBox)di.FindControl("Email")).Text;
dr["Name"] = ((TextBox)di.FindControl("Name")).Text;
dr["TEL"] = ((TextBox)di.FindControl("TEL")).Text;
}
}
}
// 如果有改动
if (dsUser.HasChanges())
{
Save();
}
BindData();
}