Gridview的footer模板中放置控件实现添加功能

protected void Page_Load( object sender, EventArgs e)     {           if (!IsPostBack)         {             databind();         }     }     public void databind()     {         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "Conn" ].ToString());         SqlCommand cmd = new SqlCommand( "SELECT * FROM T_Users" , con);         SqlDataAdapter da = new SqlDataAdapter(cmd);         DataSet ds = new DataSet();         da.Fill(ds);         this .GridView1.DataSource = ds.Tables[0];         this .GridView1.DataKeyNames = new string [] { "EmpID" };         this .GridView1.DataBind();     }     public void AddClick( object sender, EventArgs e)     {         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "Conn" ].ToString());         SqlCommand cmd = new SqlCommand();         cmd.Connection = con;         cmd.CommandText = "Insert into T_Users(EmpName,EmpSex,EmpAddress) values(@a,@b,@c)" ;         SqlParameter[] sp = new SqlParameter[3];         sp[0] = new SqlParameter( "@a" , SqlDbType.NVarChar, 20);         sp[1] = new SqlParameter( "@b" , SqlDbType.NVarChar, 4);         sp[2] = new SqlParameter( "@c" , SqlDbType.NVarChar, 50);         sp[0].Value = ((TextBox) this .GridView1.FooterRow.FindControl( "TextBox1" )).Text.Trim();         sp[1].Value = ((DropDownList) this .GridView1.FooterRow.FindControl( "DropDownList1" )).SelectedItem.Text;         sp[2].Value = ((TextBox) this .GridView1.FooterRow.FindControl( "TextBox2" )).Text.Trim();         cmd.Parameters.AddRange(sp);         if (con.State == ConnectionState.Closed)         {             con.Open();         }         cmd.ExecuteNonQuery();         databind();     }

<asp:GridView ID= "GridView1" runat= "server" ShowFooter= "true" AutoGenerateColumns= "false" >             <Columns>                 <asp:TemplateField HeaderText= "编号" >                     <ItemTemplate>                         <%#Eval( "EmpID" ) %>                     </ItemTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText= "姓名" >                     <ItemTemplate>                         <%#Eval( "EmpName" ) %>                     </ItemTemplate>                     <FooterTemplate>                         <asp:TextBox ID= "TextBox1" runat= "server" ></asp:TextBox>                     </FooterTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText = "性别" >                                   <ItemTemplate>                 <%#Eval( "EmpSex" ) %>                 </ItemTemplate>                 <FooterTemplate>                     <asp:DropDownList AutoPostBack= "true" ID= "DropDownList1" runat= "server" >                     <asp:ListItem Text = "请选择" Value= "0" ></asp:ListItem>                     <asp:ListItem Text = "男" Value = "1" ></asp:ListItem>                     <asp:ListItem Text = "女" Value = "2" ></asp:ListItem>                     </asp:DropDownList>                 </FooterTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText = "地址" >                 <ItemTemplate>                 <%#Eval( "EmpAddress" ) %>                 </ItemTemplate>                 <FooterTemplate>                     <asp:TextBox ID= "TextBox2" runat= "server" ></asp:TextBox>                     <asp:Button ID= "Button1" OnClick= "AddClick" runat= "server" Text= "添加" />                 </FooterTemplate>                 </asp:TemplateField>             </Columns>         </asp:GridView>