How can I use InsertCommand, UpdateCommand?

  • Thread starter Thread starter Doru Roman
  • Start date Start date
D

Doru Roman

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
 
Doru Roman said:
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?
Click to expand...
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
to trigger an Insert, a Select, an Update or a Delete? Can someone explain
to me?
Click to expand...
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
Also is DataReader the only way of retrieving the result of a Select
query?
Click to expand...
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.
Is ExecuteNonQuery the only way to make an update, delete or insert?
Click to expand...
--No, but it's probably the most logical and straightforward.
 
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 ;-)
 
Back
Top