在asp.net中,如何一次性更新datagrid中的所有记录呢?可以用如下的方法,首先,
要对DATAGRID中要更新的列建立模版列,比如:
asp:datagrid id="dgPopularFAQs" runat="server"
AutoGenerateColumns="False"
...>
之后,对DATAGRID进行一次遍历,
Dim myConnection as New SqlConnection(connection string)
Dim myCommand as New SqlCommand(strSQL, myConnection)
Dim dgi as DataGridItem
For Each dgi in dg***ularFAQs.Items
'Read in the Primary Key Field
Dim id as Integer = Co***rt.ToInt32(dg***ularFAQs.DataKeys(dg***temIndex))
Dim question as String = CType(dg***indControl("txtDescription"), TextBox).Text
Dim submittedBy as String = CType(dg***indControl("txtSubmittedBy"), TextBox).Text
'Issue an UPDATE statement...
Dim updateSQL as String = "UPDATE TableName SET Question = @Question, " & _
"SubmittedByName = @SubmittedByName WHERE FAQID = @ID"
my***mand.Parameters.Clear()
my***mand.Parameters.Add("@Question", question)
my***mand.Parameters.Add("@SubmittedByName", submittedBy)
my***mand.ExecuteNonQuery()
Next
上一篇: 将Asp.Net页面输出为HTML