Updating a DataSet

You are welcome to write SQL from scratch (or use stored procedures), or you can use a command builder, introduced in the preceding section, to write SQL for you. We will use generated SQL to perform an update.

NOTE

All providers are not created equal. I have experienced some difficulty getting the command builder to generate SQL for IBM's UDB database, and there are articles on the Web about other data providers. In one particular case the problem is probably related to the data itself. The database is a legacy database that isn't keyed properly, and the absence of primary keys seems to be the culprit. You always have the option of writing SQL from scratch or using stored procedures.

In the disconnected ADO.NET model, the ...

Get Visual Basic® .NET Power Coding now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial