O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Update Command

The Update statement is the most interesting of the statements generated by the wizard. It contains the parameters required to support optimistic concurrency. To see the statement, go to the Property window and find the UpdateCommand property. Just as with the SelectCommand, the UpdateCommand is an SqlCommand object. Click the plus box to expand it and then find the CommandText property. When you click the ellipsis button, a query designer opens just as with the Select statement.

					UPDATE    Customers 
SET CustomerID = @CustomerID, CompanyName = @CompanyName, ContactName = @ContactName, ContactTitle = @ContactTitle, Address = @Address, City = @City, Region = @Region, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required