一次更新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(); 

  }