</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)

上一页  [1] [2] [3] 下一页

在google里搜索更多asp.net 2.0中一次性更新所有GRIDVIEW的记录

	Web www.51ec.org

上一篇信息学院： ASP.NET with C#使用md5，sha1加密初探…

下一篇信息学院： 如何在域控制器上安装asp.net?