Hi,
I am new to .NET and I created a data adapter which generated the
SelectCommnad, UpdateCommand, DeleteCommand and InsertCommand through the
wizard. But what do I do with them? How do I use them, what are the methods
to trigger an Insert, a Select, an Update or a Delete? Can someone explain
to me?
Also is DataReader the only way of retrieving the result of a Select query?
Is ExecuteNonQuery the only way to make an update, delete or insert?
Thanks,
Doru

Call the .Update method of your dataadapter passing in the datatable you've
been editing ie

MyDataAdapter.Update(MydataTable);
How do I use them, what are the methods
When you edit a dataTable and call Update on an adapter, it looks at the
Rowstate of each row. If the Rowstate is deleted, it uses the values
configured and calls your delete command. If its inserted, the same but with
an Insert command.  this should explain the process a little more in depth
http://www.knowdotnet.com/articles/datasetmerge.html

No.  A dataAdapter opens a connection (unless you do it manually), gets the
data and loads it into your dataset/datatable and then closes the
connection.  The dataReader requires you to do all the work.  there are a
few other nuances but that's close enough to get the idea.
--No, but it's probably the most logical and straightforward.
Show quoteHide quote

Thanks, W.G. Now it makes sense for me.

Great.  I know it's a little hard to understand at first but once you get
your arms around it, it's actually pretty straightforward and you can work
your way through most problems pretty easily. If you have any more issues,
please don't hesitate to ask ;-)
Show quoteHide quote

Query inside of Access Database
parent-child and comboboxcolumn
Populating a datagrid
Basic Binding and Filtering Problem
"No value specified for some required parameters"