Is there a big reason you chose to use a dataset as opposed to a custom library to communicate with the database?
Because I'm a newbie and I'm just trying to follow an online tutorial, and that's what the tutorial teaches.
What can you tell me about applicable custom libraries and their advantages (and disadvantages) compared to datasets, and what options in general are available for accessing SQL databases? I understand that it is possible to communicate "directly" with databases (rather than initialize and use canned command strings like dataAdapter.UpdateCommand.CommandText and dataAdapter.InsertCommand.CommandText), and that this approach is said to be simpler. Can you suggest the simplest way to accessing SQL databases, with perhaps a few words about more sophisticated ways to do so, under what circumstances such more sophisticated methods might be necessary, and a little of the syntax I would need for these methods, so that I can research them after I master the simplest methods? Any help you could give would be greatly appreciated.