Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Sql Table Using VB
Message
From
26/12/2002 09:05:10
 
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00735673
Message ID:
00735815
Views:
7
Try this:

strUpdateCommand = "UPDATE Order SET " & _
"Shipped = 1, DateShipped = '" & now & "' " & _
"WHERE ..."

Open Connection

Dim myDataRow As DataRow
For Each myDataRow In OrdersToBeProcessedDataset.Tables("Orders").Rows
' initialize fields with values
myDataRow("Processed") = 1
myDataRow("DateProcessed") = NOW
UpdateCMD.ExecuteNonQuery()
next

Close Connection
Randy Belcher
AFG Industries, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform