欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net 2.0中用GRIDVIEW插入新记录】，下面是详细的分享！
asp.net 2.0中用GRIDVIEW插入新记录
<%@ Page Language="C#" ClassName="Default_aspx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
void CancelButton1_Click(object sender, EventArgs e)
{
GridView1.ShowFooter=false;
}
void AddButton1_Click(object sender, EventArgs e)
{
GridView1.ShowFooter=true;
}
void Button1_Click(object sender, EventArgs e)
{
TextBox customerID=GridView1.FooterRow.FindControl("CustomerIDTextBox") as TextBox;
TextBox companyName=GridView1.FooterRow.FindControl("CompanyNameTextBox") as TextBox;
DropDownList ContactTitle=GridView1.FooterRow.FindControl("ContactTitleDropDownList") as DropDownList;
SqlDataSource1.InsertParameters["CustomerID"].DefaultValue=customerID.Text;
SqlDataSource1.InsertParameters["CompanyName"].DefaultValue=companyName.Text;
SqlDataSource1.InsertParameters["ContactTitle"].DefaultValue=ContactTitle.SelectedValue;
SqlDataSource1.Insert();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="AddButton1" runat="Server" Text="Add new Item" OnClick="AddButton1_Click" />
<asp:GridView ID="GridView1" Runat="server" DataSourceID="SqlDataSource1" DataKeyNames="CustomerID"
AutoGenerateColumns="False" ShowFooter="True">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="CustomerIDLabel" Runat="Server"><%# Eval("CustomerID") %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="CustomerIDTextBox" Runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="CompanyNameLabel" Runat="Server"><%# Eval("CompanyName") %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="CompanyNameTextBox" Runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<FooterTemplate>
<asp:DropDownList ID="ContactTitleDropDownList" Runat="server" DataSourceID="SqlDataSource2" DataTextField="ContactTitle" DataValueField="ContactTitle">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" Runat="server" SelectCommand="SELECT DISTINCT [ContactTitle] FROM [Customers]"
ConnectionString="server=localhost;uid=sa;password=xxx;database=northwind">
</asp:SqlDataSource>
<asp:Button ID="Button1" Runat="server" Text="Add" OnClick="Button1_Click" />
<asp:Button ID="CancelButton1" Runat="server" Text="Cancel" OnClick="CancelButton1_Click" />
</FooterTemplate>
<ItemTemplate>
<asp:DropDownList ID="ContactTitleDropDown" SelectedValue='<%# Bind("ContactTitle") %>' Runat="Server" DataSourceID="SqlDataSource3" DataTextField="ContactTitle" DataValueField="ContactTitle" ></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" Runat="server" SelectCommand="SELECT DISTINCT [ContactTitle] FROM [Customers]"
ConnectionString="server=localhost;uid=sa;password=xxx;database=northwind" EnableCaching="True">
</asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactTitle]) VALUES (@CustomerID, @CompanyName, @ContactTitle)"
SelectCommand="SELECT [CustomerID], [CompanyName], [ContactTitle] FROM [Customers]"
ConnectionString="server=localhost;uid=sa;password=xxxxx;database=northwind">
<DeleteParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="CompanyName"></asp:Parameter>
<asp:Parameter Type="String" Name="ContactTitle"></asp:Parameter>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
<asp:Parameter Type="String" Name="CompanyName"></asp:Parameter>
<asp:Parameter Type="String" Name="ContactTitle"></asp:Parameter>
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
以上所分享的是关于asp.net 2.0中用GRIDVIEW插入新记录，下面是编辑为你推荐的有价值的用户互动：
相关问题：ASP.NET里面用GridView显示数据后点击按钮将所对应...
答：你可以将其写成一个带参数的sqlcommand啊，然后用sqlcommand添加参数，并赋值，最后运行就行了，要不就用拼凑的 string sql = "insert into [User](UserName,PassWord,RoleID,RealName,IDCardNumber,Telephone,[E-mail]) select UserName,PassWo... >>详细
相关问题：[asp.net c#] 在gridview的页脚添加一条新记录，加...
答：SQL语句有问题，朋友。字符串串类型的要加单引号。。。 String sqlStr = "insert into 产品(n_id,名称) values (" + Convert.ToInt32(compID) + ", '"+s+"' )"; >>详细
相关问题：ASP.NET 2.0中GridView中添加了一个列，列中有单选...
答：第一，你radiobutton的组别设置了嘛？一点要设置groupname=“你要的名字”这是一个属性，如果3个radiobotton不是一个组别的话他们是独立的，会出现3个都选中的情况。 第二 把 ((GridView1.Rows[i].FindControl("RadioButton1")) as RadioButton).C... >>详细
- 评论列表（网友评论仅供网友表达个人看法，并不表明本站同意其观点或证实其描述）
-