asp.net 2.0中用GRIDVIEW插入新记录_.Net教程

编辑Tag赚U币
教程Tag:暂无Tag,欢迎添加,赚取U币!

推荐:在ASP.NET程序中创建唯一序号
如果在程序中需要创建全局唯一的序号,那么必须对创建序号的过程进行同步处理,防止多个并发访问时出现相同序号的情况。下面列出几种方法供大家参考。 利用数据库的方法 后面的例子都基于MS

看了下国外某巨牛的BLOG,大概是讲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>

分享:一个功能齐全的DataGrid分页例子
以下为引用的内容: C#版本 DataGridPaging.aspx <%@ Page language="c#" EnableViewState

来源:模板无忧//所属分类:.Net教程/更新时间:2008-08-22
相关.Net教程