ASP.NET in one-time update DataGrid all records

In ASP.NET, how do you update all records in DataGrid in a time? You can use the following method, first,

To establish analog columns, such as columns to update in DataGrid, such as:

ASP: DATAGRID ID = "DGPopularfaqs" runat = "server"

AutogenerateColumn = "false"

...>

ItemStyle-Horizontalalign = "center" Headeertext = "FAQ ID" />

Text = '<% # Container.DataItem ("Description")%>' />

Text = '<% # Container.DataItem ("SubmittedByname")%>' />

After that, the DataGrid is traversed once.

DIM MyConnection As New SqlConnection

Connection String)

DIM MyCommand as new Sqlcommand (strsql, myconnection)

DIM DGI As DataGridItem

For Each DGI in DGPopularfaqs.Items

'Read in The Primary Key Field

DIM ID as INTEGER = Convert.Toint32 (DGPopularfaqs.DataKeys (DGI.ItemIndex))

DIM Question as string = ctype (DGI.FindControl ("txtdescription"), TextBox) .Text

DIM Submittedby As String = CType (DGI.FindControl ("TXTSUBMITTEDBY"), TextBox) .Text

'Issue An Update Statement ...

DIM UpdateSQL As String = "UpdateTablename Set Question = @Question," & _

"SubmittedByName = @SubmittedByname where faqid = @ID"

Mycommand.parameters.clear ()

Mycommand.parameters.add ("@ questions", questions

Mycommand.Parameters.add ("@ submittedbyname", submittedby)

Mycommand.executenonQuery ()

NEXT