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

最新推荐文章于 2017-06-29 19:26:00 发布

转载最新推荐文章于 2017-06-29 19:26:00 发布 · 609 阅读

.NET 专栏收录该内容

166 篇文章

订阅专栏

本博客详细介绍了如何通过代码实现用户数据的绑定、查询、添加等操作，包括使用ADO.NET连接数据库、设置数据源和数据键名、创建SQL命令执行插入操作及数据绑定流程。

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>