Updating database using dataset without dataadapter?

  • Thread starter Thread starter Venkat Chellam
  • Start date Start date
V

Venkat Chellam

Hi,

Is there a way to update the changed dataset without calling
datadapter.update function? I mean if i have access only to dataset
object and dataadapter is hidden, how do i update the changed rows
back to database?



venkat
 
Hi Venkat,

As far as I know you cant do it.

I am not sure what you mean by hidden. You can try by creating a new adapter
with same command and then use the new adapter's update method. Or you can
try writing your own function to call a Stored Proc which does updations for
you. Loop through the dataset and call the Stored Proc for rows which were
changed. This is like simulating what a dataadapter does.

-SP
 
Hi Venkat,

In addition to Sasidhar, nobody is preventing you to do the job manually -
update row by row using custom commands.
 
Back
Top