Re: SqlDataAdapter Questions
- From: "Marina Levit [MVP]" <someone@xxxxxxxxxx>
- Date: Mon, 31 Jul 2006 16:09:31 -0400
No 'default' commands are generated by the adapter. The developer is
supposed to set UpdateCommand, InsertCommand, DeleteCommand so that during
Update, the adapter can use these commands to send the corresponding row
changes to the database.
If you don't use the Update method, then yes, there is no point in defining
these.
If you do use the Update method of the adapter, then unless you set these,
you will get an exception when the adapter tries to use them.
If you use the SqlCommandBuilder, then you do not need to set these
properties, as the SqlCommandBuilder provides the commands on demand to the
adapter.
"Aaron" <hartley_aaron@xxxxxxxxxxx> wrote in message
news:1154375655.450193.271690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
The SqlDataAdapter has 4 properties of type SqlCommand, SelectCommand,
UpdateCommand, DeleteCommand, and InsertCommand. Setting the
SelectCommand allows the SqlDataAdapter to retrieve data from the
database using the fill method. Aside from that, I don't see much of a
difference. The SelectCommand can be used to insert, update, and
delete all by using the ExecuteNonQuery method. So UpdateCommand,
DeleteCommand, and InsertCommand seem to be somewhat redundant.
The SqlDataAdapter Update method is supposed to, relative to the data
obtained from the Fill method, writeback any changes to the database.
The documentation for UpdateCommand, etc is vague but seems to indicate
that the developer can use UpdateCommand, etc to override or supplement
the auto generated commands when Update is executed (????).
What is the function of these commands?
Thanks,
Aaron
.
- References:
- SqlDataAdapter Questions
- From: Aaron
- SqlDataAdapter Questions
- Prev by Date: Re: Select node
- Next by Date: Re: 2 pieces of the same code doing different things
- Previous by thread: SqlDataAdapter Questions
- Next by thread: Re: SqlDataAdapter Questions
- Index(es):
Relevant Pages
|
