看了下国外某巨牛的BLOG,大概是讲a .net 2.0中用GRIDVIEW插入新记录的,方法比较特别,但效果一般,故将程序转之,较为简单,不做解释等。
<%@ Page Language="C#" Cla ame="Default_a x" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//E quot; "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" gt;
< cript runat=" erver" gt;
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.I ertParameters["CustomerID"].DefaultValue = customerID.Text;
SqlDataSource1.I ertParameters["CompanyName"].DefaultValue = companyName.Text;
SqlDataSource1.I ertParameters["ContactTitle"].DefaultValue = ContactTitle.SelectedValue;
SqlDataSource1.I ert();
}
</script>
<html xml ="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat=" erver" gt;
<title>Untitled Page</title>
</head>
< ody>
<form id="form1" runat=" erver" gt;
<div>
<a :Button ID="AddButton1" runat=" erver" Text="Add new Item" OnClick="AddButton1_Click" />
<a :GridView ID="GridView1" Runat=" erver" DataSourceID=" qlDataSource1" DataKeyNames="CustomerID"
AutoGenerateColum ="False" ShowFooter="True" gt;
<Colum gt;
<a :TemplateField>
<ItemTemplate>
<a :Label ID="CustomerIDLabel" Runat=" erver" gt lt;%# Eval("CustomerID") %> lt;/a :Label>
</ItemTemplate>
<FooterTemplate>
<a :TextBox ID="CustomerIDTextBox" Runat=" erver" gt lt;/a :TextBox>
</FooterTemplate>
</a :TemplateField>
<a :TemplateField>
<ItemTemplate>
<a :Label ID="CompanyNameLabel" Runat=" erver" gt lt;%# Eval("CompanyName") %> lt;/a :Label>
</ItemTemplate>
<FooterTemplate>
<a :TextBox ID="CompanyNameTextBox" Runat=" erver" gt lt;/a :TextBox>
</FooterTemplate>
</a :TemplateField>
<a :TemplateField>
<FooterTemplate>
<a :DropDownList ID="ContactTitleDropDownList" Runat=" erver" DataSourceID=" qlDataSource2" DataTextField="ContactTitle" DataValueField="ContactTitle" gt;
</a :DropDownList>
<a :SqlDataSource ID=" qlDataSource2" Runat=" erver" SelectCommand=" ELECT DISTINCT [ContactTitle] FROM [Customers]"
Co ectio tring=" erver=localhost;uid=sa a word=xxx;database=northwind" gt;
</a :SqlDataSource>
<a :Button ID=" utton1" Runat=" erver" Text="Add" OnClick=" utton1_Click" />
<a :Button ID="CancelButton1" Runat=" erver" Text="Cancel" OnClick="CancelButton1_Click" />
</FooterTemplate>
<ItemTemplate>
<a :DropDownList ID="ContactTitleDropDow quot; SelectedValue='<%# Bind("ContactTitle") %>' Runat=" erver" DataSourceID=" qlDataSource3" DataTextField="ContactTitle" DataValueField="ContactTitle" > lt;/a :DropDownList>
<a :SqlDataSource ID=" qlDataSource3" Runat=" erver" SelectCommand=" ELECT DISTINCT [ContactTitle] FROM [Customers]"
Co ectio tring=" erver=localhost;uid=sa a word=xxx;database=northwind" EnableCaching="True" gt;
</a :SqlDataSource>
</ItemTemplate>
</a :TemplateField>
</Colum gt;
</a :GridView>
<a :SqlDataSource ID=" qlDataSource1" Runat=" erver"
I ertCommand="I ERT INTO [Customers] ([CustomerID], [CompanyName], [ContactTitle]) VALUES (@CustomerID, @CompanyName, @ContactTitle)"
SelectCommand=" ELECT [CustomerID], [CompanyName], [ContactTitle] FROM [Customers]"
Co ectio tring=" erver=localhost;uid=sa a word=xxxxx;database=northwind" gt;
<DeleteParameter gt;
<a :Parameter Type=" tring" Name="CustomerID" gt lt;/a :Parameter>
</DeleteParameter gt;
<UpdateParameter gt;
<a :Parameter Type=" tring" Name="CompanyName" gt lt;/a :Parameter>
<a :Parameter Type=" tring" Name="ContactTitle" gt lt;/a :Parameter>
<a :Parameter Type=" tring" Name="CustomerID" gt lt;/a :Parameter>
</UpdateParameter gt;
<I ertParameter gt;
<a :Parameter Type=" tring" Name="CustomerID" gt lt;/a :Parameter>
<a :Parameter Type=" tring" Name="CompanyName" gt lt;/a :Parameter>
<a :Parameter Type=" tring" Name="ContactTitle" gt lt;/a :Parameter>
</I ertParameter gt;
</a :SqlDataSource>
</div>
</form>
</body>
</html>

