SqlDataAdapter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Analizer1 - 26 Oct 2007 18:17 GMT

hello

if i have a Existing SqlDataAdapter
how do you Clear it and re-use
or do i just set it to null and create a new
SqlDataAdapter

TIA
analizer1

Reply to this Message

Alberto Poblacion - 26 Oct 2007 19:55 GMT

> if i have a Existing SqlDataAdapter
> how do you Clear it and re-use
> or do i just set it to null and create a new
> SqlDataAdapter

Basically, the contents of the SqlDataAdapter are four SqlCommands named
SelectCommand, InsertCommand, UpdateCommand and DeleteCommand. If you assign
new SqlCommands to these properties of the SqlDataAdapter, you have
reconfigured it and it can be reused for whatever it is that the new
SqlCommands are configured.

Reply to this Message

MikeJ - 27 Oct 2007 07:03 GMT

thank you much
analizer1

>> if i have a Existing SqlDataAdapter
>> how do you Clear it and re-use
[quoted text clipped - 6 lines]
> reconfigured it and it can be reused for whatever it is that the new
> SqlCommands are configured.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...