<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      asp.net 2.0中一次性更新所有GRIDVIEW的記錄
                
                  發表時間：2024-05-27             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]在asp.net 2.0中，gridview控件是十分不錯的控件。有的時候，可能一個GRIDVIEW控件中的各行都是文本框，如何一次性更新所有修改過的記錄呢？有兩種方法，一種是使用sqldatasource來更新所有記錄，但這個方法比較慢，因為每更新一條記錄都要建立數據連接并執行updatecom...
        在asp.net 2.0中，gridview控件是十分不錯的控件。有的時候，可能一個GRIDVIEW控件中的各行都是文本框，如何一次性更新所有修改過的記錄呢？有兩種方法，一種是使用sqldatasource來更新所有記錄，但這個方法比較慢，因為每更新一條記錄都要建立數據連接并執行updatecommand,會影響性能，但還是先來看下實現方法：
        
      <%@ Page Language="C#" %>
      <script runat="server">
          void Button1_Click(object sender, EventArgs e)
          {
              for (int i = 0; i < GridView1.Rows.Count; i++)
              {
                  GridViewRow row = GridView1.Rows[i];
                  SqlDataSource1.UpdateParameters[0].DefaultValue = ((TextBox)row.Cells[0].FindControl("TextBox2")).Text;
                  SqlDataSource1.UpdateParameters[1].DefaultValue = ((TextBox)row.Cells[1].FindControl("TextBox3")).Text;
                  SqlDataSource1.UpdateParameters[2].DefaultValue = GridView1.DataKeys[i].Value.ToString();
                  SqlDataSource1.Update();
              }
          }    
          
      </script>
      <html xmlns="http://www.w3.org/1999/xhtml" >
      <head runat="server">
          <title>Untitled Page</title>
      </head>
      <body>
          <form id="form1" runat="server">
          <div>
              <asp:GridView ID="GridView1" Runat="server" DataSourceID="SqlDataSource1" DataKeyNames="CustomerID"
                  AutoGenerateColumns="False">
                  <Columns>
                      <asp:TemplateField SortExpression="CustomerID" HeaderText="CustomerID">
                      <ItemTemplate>
                          <asp:TextBox Runat="server" Text='<%# Bind("CustomerID") %>' ID="TextBox1"></asp:TextBox>
                      </ItemTemplate>
                      </asp:TemplateField>
                      <asp:TemplateField SortExpression="CompanyName" HeaderText="CompanyName">
                          <ItemTemplate>
                              <asp:TextBox Runat="server" Text='<%# Bind("CompanyName") %>' ID="TextBox2"></asp:TextBox>
                          </ItemTemplate>
                      </asp:TemplateField>
                      <asp:TemplateField SortExpression="ContactName" HeaderText="ContactTitle">
                          <ItemTemplate>
                              <asp:TextBox Runat="server" Text='<%# Bind("ContactTitle") %>' ID="TextBox3"></asp:TextBox>
                          </ItemTemplate>
                      </asp:TemplateField>
                  </Columns>
              </asp:GridView>
              <asp:SqlDataSource ID="SqlDataSource1" Runat="server"
                  SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle] FROM [Customers]"
                  UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactTitle] = @ContactTitle WHERE [CustomerID] = @CustomerID"
                  ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>">
                  <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>
              </asp:SqlDataSource>
              <asp:Button ID="Button1" Runat="server" Text="Button" OnClick="Button1_Click" />&nbsp;
          
          </div>
          </form>
      </body>
      </html>
        另外一個方法是用組合SQL語句來進行的，速度比較快，原理也容易明白
      <%@ Page Language="C#" %>
      <%@ Import Namespace="System.Text" %>
      <%@ Import Namespace="System.Data.SqlClient" %>
      <script runat="server">
          
          void Button1_Click(object sender, EventArgs e)
          {
              StringBuilder query = new StringBuilder();
              
              for (int i = 0; i < GridView1.Rows.Count; i++)
              {
                  GridViewRow row = GridView1.Rows[i];
                  string value1 = ((TextBox)row.Cells[0].FindControl("TextBox2")).Text.Replace("'","''");
                  string value2 = ((TextBox)row.Cells[1].FindControl("TextBox3")).Text.Replace("'","''");
                  string value3 = GridView1.DataKeys[i].Value.ToString();
       
                  query.Append("UPDATE [Customers] SET [CompanyName] = '")
                      .Append(value1).Append("' , [ContactTitle] = '")
                      .Append(value2).Append("' WHERE [CustomerID] = '")
                      .Append(value3).Append("';\n");
                  
              }
       
              SqlConnection con = new SqlConnection(ConfigurationSettings.ConnectionStrings["AppConnectionString1"].ConnectionString);
              SqlCommand command = new SqlCommand(query.ToString(), con);
              con.Open();
              command.ExecuteNonQuery();
              con.Close();
          }
       
          void Page_Load(object sender, EventArgs e)
          {
              if (!Page.IsPostBack)
              {
                  SqlConnection con = new SqlConnection(ConfigurationSettings.ConnectionStrings["AppConnectionString1"].ConnectionString);
                  SqlCommand command = new SqlCommand("SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle] FROM [Customers]", con);
       
                  con.Open();
                  GridView1.DataSource = command.ExecuteReader();
                  GridView1.DataBind();
                  con.Close();
              }
          }
      </script>
       
      <html xmlns="http://www.w3.org/1999/xhtml" >
      <head runat="server">
          <title>Untitled Page</title>
      </head>
      <body>
          <form id="form1" runat="server">
          <div>
              <asp:GridView ID="GridView1" Runat="server" DataKeyNames="CustomerID"
                  AutoGenerateColumns="False">
                  <Columns>
                      <asp:TemplateField SortExpression="CustomerID" HeaderText="CustomerID">
                      <ItemTemplate>
                          <asp:TextBox Runat="server" Text='<%# Bind("CustomerID") %>' ID="TextBox1"></asp:TextBox>
                      </ItemTemplate>
                      </asp:TemplateField>
                      <asp:TemplateField SortExpression="CompanyName" HeaderText="CompanyName">
                          <ItemTemplate>
                              <asp:TextBox Runat="server" Text='<%# Bind("CompanyName") %>' ID="TextBox2"></asp:TextBox>
                          </ItemTemplate>
                      </asp:TemplateField>
                      <asp:TemplateField SortExpression="ContactName" HeaderText="ContactTitle">
                          <ItemTemplate>
                              <asp:TextBox Runat="server" Text='<%# Bind("ContactTitle") %>' ID="TextBox3"></asp:TextBox>
                          </ItemTemplate>
                      </asp:TemplateField>
                  </Columns>
              </asp:GridView>
              <asp:Button ID="Button1" Runat="server" Text="Button" OnClick="Button1_Click" />&nbsp;
          </div>
          </form>
      </body>
      </html>



              
              
                 
              
                                            
                              		       
                          
                           		  
        
                            
      
日韩精品一区二区三区高清