O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

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

Q&A

Q1:How will I know when to use CommandBuilder or not?
A1: The data access requirements must correspond to the single-table limitation, the unique column or primary key requirement along with no related table functionality that could cause data update discrepancies (like foreign key constraints, and so on). If you have met this criteria, save yourself a bunch of coding and use CommandBuilder!
Q2:Do I do the same type of coding for the SqlDataAdapter that I would do for the OleDbDataAdapter?
A2: Yes! There is basically no difference in the coding approach for either DataAdapter. Both can use the CommandBuilder capability.
Q3:What if I don't refresh the SELECT statement's metadata when the statement is changed?
A3: Unpredictable results will occur. ...

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