IDC资讯中心 看了下国外某巨牛的BLOG，大概是讲asp.net 2.0中用GRIDVIEW插入新记录的，方法比较特别，但效果一般，故将程序转之，较为简单，不做解释等。 <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.1//EN” “http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd“> <script runat=”server”> GridView1.ShowFooter = false; } GridView1.ShowFooter = true; } void Button1_Click(object sender, EventArgs e) { 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> 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” /> </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>
<%@ Page Language=”C#” ClassName=”Default_aspx” %>
void CancelButton1_Click(object sender, EventArgs e)
{
void AddButton1_Click(object sender, EventArgs e)
{
TextBox customerID = GridView1.FooterRow.FindControl(“CustomerIDTextBox”) as TextBox;
<asp:Button ID=”AddButton1″ runat=”Server” Text=”Add new Item” OnClick=”AddButton1_Click” />
<asp:GridView ID=”GridView1″ Runat=”server” DataSourceID=”SqlDataSource1″ DataKeyNames=”CustomerID”
<asp:Button ID=”CancelButton1″ Runat=”server” Text=”Cancel” OnClick=”CancelButton1_Click” />
asp.net 2.0中用gridview插入新记录 _asp.net技巧
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com 特别注意：本站所有转载文章言论不代表本站观点！ 本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。未经允许不得转载：IDC资讯中心 » asp.net 2.0中用gridview插入新记录 _asp.net技巧
相关推荐
- 暂无文章
