Asp.net 中的 DataGrid 和 GridView 批量更新

1.DataGrid 批量更新

在html的form中设置如下的DataGrid

 

< asp:DataGrid  id ="DataGrid1"  style ="Z-INDEX: 101; LEFT: 16px; POSITION: absolute; TOP: 32px"  runat ="server"
                Width ="912px"  Height ="136px"  AutoGenerateColumns ="False" >
                 < Columns >
                     < asp:TemplateColumn  HeaderText ="ID" >
                         < ItemTemplate >
                             < asp:Label  id =Label1  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.id") % > '>
                             </ asp:Label >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="用户名" >
                         < ItemTemplate >
                             < asp:TextBox  id =TextBox1  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.uname") % > '>
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="性别" >
                         < ItemTemplate >
                             < asp:TextBox  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.sex") % > ' ID="Textbox2">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="年龄" >
                         < ItemTemplate >
                             < asp:TextBox  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.age") % > ' ID="Textbox3">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="电话" >
                         < ItemTemplate >
                             < asp:TextBox  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.tel") % > ' ID="Textbox4">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="地址" >
                         < ItemTemplate >
                             < asp:TextBox  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.addr") % > ' ID="Textbox5">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                 </ Columns >
             </ asp:DataGrid >
             < asp:Button  id ="Button1"  style ="Z-INDEX: 102; LEFT: 80px; POSITION: absolute; TOP: 232px"  runat ="server"
                Text ="批量更新" ></ asp:Button >

在cs文件中写如下代码

 

private   void  Page_Load( object  sender, System.EventArgs e)
         ... {
            // 在此处放置用户代码以初始化页面
            if(!this.IsPostBack)
            ...{
                this.Bind();
            }
        }

         public   void  Bind()
         ... {
            try
            ...{
                SqlDataAdapter da=new SqlDataAdapter("select * from userinfo",conn);
                DataSet ds=new DataSet();
                da.Fill(ds,"gg");
                this.DataGrid1.DataSource=ds;
                this.DataGrid1.DataBind();
            
            }
            catch(Exception Err)
            ...{
                throw Err;
            }
            finally
            ...{

            }

        }
         Web 窗体设计器生成的代码 #region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        ...{
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        ...{    
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

         private   void  Button1_Click( object  sender, System.EventArgs e)
         ... {
            int k=0;
            for(int i=0;i<this.DataGrid1.Items.Count;i++)
            ...{
                int id=int.Parse(((Label)DataGrid1.Items[i].FindControl("Label1")).Text);
                string username=((TextBox)DataGrid1.Items[i].FindControl("TextBox1")).Text;
                string sex=((TextBox)DataGrid1.Items[i].FindControl("TextBox2")).Text;
                int age=int.Parse(((TextBox)DataGrid1.Items[i].FindControl("TextBox3")).Text);
                string tel=((TextBox)DataGrid1.Items[i].FindControl("TextBox4")).Text;
                string addr=((TextBox)DataGrid1.Items[i].FindControl("TextBox5")).Text;
                

                string sql="update userinfo set uname='"+username+"',sex='"+sex+"',age="+age+",tel='"+tel+"',addr='"+addr+"' where id="+id+"";
                SqlCommand cmd=new SqlCommand(sql,conn);
                if(conn.State==ConnectionState.Closed)
                ...{
                    conn.Open();
                }
                k=cmd.ExecuteNonQuery();
            
            }
            if(k>0)
            ...{
                Page.RegisterStartupScript("","<script>alert('更新成功!');</script>");
            }

    
        }

 

2.GridView 批量更新

在html的form中设置如下的GridView

 

  < asp:GridView  ID ="GridView1"  runat ="server"  AutoGenerateColumns ="False"  Width ="873px" >
             < Columns >
                 < asp:TemplateField  HeaderText ="ID" >
                   
                     < ItemTemplate >
                         < asp:Label  ID ="Label1"  runat ="server"  Text ='<%#  Bind("id") % > '> </ asp:Label >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                 < asp:TemplateField  HeaderText ="用户名" >
                    
                     < ItemTemplate >
                         < asp:TextBox  ID ="TextBox2"  runat ="server"  Text ='<%#  Bind("uname") % > '> </ asp:TextBox >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                 < asp:TemplateField  HeaderText ="性别" >
                    
                     < ItemTemplate >
                         < asp:TextBox  ID ="TextBox3"  runat ="server"  Text ='<%#  Bind("sex") % > '> </ asp:TextBox >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                 < asp:TemplateField  HeaderText ="年龄" >
                    
                     < ItemTemplate >
                         < asp:TextBox  ID ="TextBox4"  runat ="server"  Text ='<%#  Bind("age") % > '> </ asp:TextBox >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                 < asp:TemplateField  HeaderText ="电话" >
                   
                     < ItemTemplate >
                          < asp:TextBox  ID ="TextBox5"  runat ="server"  Text ='<%#  Bind("tel") % > '> </ asp:TextBox >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                 < asp:TemplateField  HeaderText ="地址" >
                   
                     < ItemTemplate >
                        < asp:TextBox  ID ="TextBox6"  runat ="server"  Text ='<%#  Bind("addr") % > '> </ asp:TextBox >
                     </ ItemTemplate >
                 </ asp:TemplateField >
             </ Columns >
         </ asp:GridView >
    
     </ div >
         < asp:Button  ID ="Button1"  runat ="server"  Text ="批量更新"  OnClick ="Button1_Click"   />

在cs文件中写如下代码

 

 SqlConnection conn  =   new  SqlConnection(ConfigurationManager.AppSettings[ " conn " ]);
     protected   void  Page_Load( object  sender, EventArgs e)
     ... {
        if (!this.IsPostBack)
        ...{
            this.Bind();
        }
    }
     private   void  Bind()
     ... {
        try
        ...{
            SqlDataAdapter da = new SqlDataAdapter("select * from userinfo",conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "ff");
            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();
        }
        catch (Exception Err)
        ...{
            throw Err;
        }
        finally
        ...{

        }
    }
     protected   void  Button1_Click( object  sender, EventArgs e)
     ... {
        int k = 0;
        foreach (GridViewRow gv in GridView1.Rows)
        ...{
            int id = int.Parse(((Label)gv.FindControl("Label1")).Text);
            string username = ((TextBox)gv.FindControl("TextBox2")).Text;
            string sex = ((TextBox)gv.FindControl("TextBox3")).Text;
            int age = int.Parse(((TextBox)gv.FindControl("TextBox4")).Text);
            string tel = ((TextBox)gv.FindControl("TextBox5")).Text;
            string addr = ((TextBox)gv.FindControl("TextBox6")).Text;
            string sql = "update userinfo set uname='" + username + "',sex='" + sex + "',age=" + age + ",tel='" + tel + "',addr='" + addr + "' where id=" + id + "";
            SqlCommand cmd = new SqlCommand(sql, conn);
            if (conn.State == ConnectionState.Closed)
            ...{
                conn.Open();
            }
            k = cmd.ExecuteNonQuery();
        }
        if (k > 0)
        ...{
            Page.RegisterStartupScript("", "<script>alert('更新成功!');</script>");
        }

    }