Writing data back to a database

[Andrew Chalk]

I have some data in a DataSet and want to write it back to the underlying
SQL Server database. Is there any simple "one-liner" way to write a dataset
back to its database or do I have to go through the steps of creating a
command object, adding parameters and calling ExecuteNonQuery ().

Many thanks.

[Brock Allen]

Look into the SqlDataAdapter and its Update method.

-Brock
DevelopMentor
http://staff.develop.com/ballen

I have some data in a DataSet and want to write it back to the
underlying SQL Server database. Is there any simple "one-liner" way to
write a dataset back to its database or do I have to go through the
steps of creating a command object, adding parameters and calling
ExecuteNonQuery ().

Many thanks.

[Andrew Chalk]

Thanks. I read that and am now attempting to automatically generate the
update command. I can see that the command is created by examining:
SqlCommand com = cb.GetUpdateCom mand();
However changes are still not appearing in the database when I call the
Update() method on the data adaptor instance. Examining the DataAdapter
members I notice that cmdUpdate is 'undefined value'. I have no idea why.
Are their any reasons for this that you can think of?

Many thanks.

"Brock Allen" <ba****@NOSPAMd evelop.com> wrote in message
news:b8******** *************** ***@msnews.micr osoft.com...

Look into the SqlDataAdapter and its Update method.

-Brock
DevelopMentor
http://staff.develop.com/ballen

I have some data in a DataSet and want to write it back to the
underlying SQL Server database. Is there any simple "one-liner" way to
write a dataset back to its database or do I have to go through the
steps of creating a command object, adding parameters and calling
ExecuteNonQuery ().

Many thanks.

[Cindy Winegarden]

Hi Andrew,

See if this helps: "How to update a database from a DataSet object by using
Visual Basic .NET" (http://support.microsoft.com/kb/q301248/) . Basically
the procedure is to make the changes you want to the data in the DataSet,
and then pass the Dataset object to the Update method of the DataAdapter
object. You will need to specify the InsertCommand, UpdateCommand, and
DeleteCommand properties of the DataAdapter or you can let VS generate these
for you.

--
Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
ci************* *@msn.com www.cindywinegarden.com
"Andrew Chalk" <ac****@magnaca rtasoftware.com > wrote in message
news:uc******** ******@TK2MSFTN GP09.phx.gbl...

I have some data in a DataSet and want to write it back to the underlying
SQL Server database. Is there any simple "one-liner" way to write a dataset
back to its database or do I have to go through the steps of creating a
command object, adding parameters and calling ExecuteNonQuery ().

[Andrew Chalk]

Thanks. I read about that and am now attempting to automatically generate
the
update command. I can see that the command is created by examining:
SqlCommand com = cb.GetUpdateCom mand();
However changes are still not appearing in the database when I call the
Update() method on the data adaptor instance. Examining the DataAdapter
members I notice that cmdUpdate is 'undefined value'. I have no idea why.
Are their any reasons for this that you can think of?

Many thanks.

"Cindy Winegarden" <ci************ **@msn.com> wrote in message
news:uQ******** ******@TK2MSFTN GP12.phx.gbl...

Hi Andrew,

See if this helps: "How to update a database from a DataSet object by
using Visual Basic .NET" (http://support.microsoft.com/kb/q301248/) .
Basically the procedure is to make the changes you want to the data in the
DataSet, and then pass the Dataset object to the Update method of the
DataAdapter object. You will need to specify the InsertCommand,
UpdateCommand, and DeleteCommand properties of the DataAdapter or you can
let VS generate these for you.

--
Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
ci************* *@msn.com www.cindywinegarden.com
"Andrew Chalk" <ac****@magnaca rtasoftware.com > wrote in message
news:uc******** ******@TK2MSFTN GP09.phx.gbl...

I have some data in a DataSet and want to write it back to the underlying
SQL Server database. Is there any simple "one-liner" way to write a
dataset back to its database or do I have to go through the steps of
creating a command object, adding parameters and calling
ExecuteNonQue ry().