Skip to Content
Visual Basic® .NET Power Coding
book

Visual Basic® .NET Power Coding

by Paul Kimmel
July 2003
Intermediate to advanced
736 pages
16h 35m
English
Addison-Wesley Professional
Content preview from Visual Basic® .NET Power Coding

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

ADO.NET Programming in Visual Basic™ .NET

ADO.NET Programming in Visual Basic™ .NET

Steve Holzner, Bob Howell
Programming ASP .NET

Programming ASP .NET

Jesse Liberty, Dan Hurwitz

Publisher Resources

ISBN: 0672324075Purchase book