Updating database using dataset without dataadapter?

[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

 

[Sasidhar]

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

 

[Miha Markic [MVP C#]]

Hi Venkat,

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