SqlDataAdapter

[Analizer1]

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

 

[Alberto Poblacion]

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.

 

[MikeJ]

thank you much
analizer1

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.