How save DataSet back to database?

[Ronald S. Cook]

In my client Windows application, I am receiving a DataSet containing one
DataTable. This comes to my client via the business tier on a different
physical machine (we're using WCF if that matters).

After I make changes to the data in the underlying DataTable, I send the
DataSet back to the business tier. In the business tier, what should my
code look like to persist the data up to the database?

I'm assuming I need to do something like this:

Dim Connection As New SqlConnection()
Connection.Conn ectionString = My.Settings.COW FeedyardConnect ionString
Dim Command As New SqlCommand()
Command.Connect ion = Connection
Dim DataAdapter As New SqlDataAdapter( )
DataAdapter.Upd ateCommand = Command
DataAdapter.Upd ate(PenDataSet)

... but I get the errror: "Update unable to find TableMapping['Table'] or
DataTable 'Table'."

Thanks for any help,
Ron

[Ronald S. Cook]

And actually, I just changed the update line to instead read:

DataAdapter.Upd ate(PenDataSet, "Results")
The code now does not break on error, it seems to execute the line but no
changes were actually ssaved to the database.

Thanks,
Ron
"Ronald S. Cook" <rc***@westinis .comwrote in message
news:ed******** ******@TK2MSFTN GP05.phx.gbl...

In my client Windows application, I am receiving a DataSet containing one
DataTable. This comes to my client via the business tier on a different
physical machine (we're using WCF if that matters).

After I make changes to the data in the underlying DataTable, I send the
DataSet back to the business tier. In the business tier, what should my
code look like to persist the data up to the database?

I'm assuming I need to do something like this:

Dim Connection As New SqlConnection()
Connection.Conn ectionString = My.Settings.COW FeedyardConnect ionString
Dim Command As New SqlCommand()
Command.Connect ion = Connection
Dim DataAdapter As New SqlDataAdapter( )
DataAdapter.Upd ateCommand = Command
DataAdapter.Upd ate(PenDataSet)

.. but I get the errror: "Update unable to find TableMapping['Table'] or
DataTable 'Table'."

Thanks for any help,
Ron

[Scott M.]

You have created an instance of a command object, but you haven't configured
the command object's .commandText property to anything. It needs to be set
to a valid update statement, so that when you call dataadapter.upd ate, it
knows what to do.
"Ronald S. Cook" <rc***@westinis .comwrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

And actually, I just changed the update line to instead read:

DataAdapter.Upd ate(PenDataSet, "Results")
The code now does not break on error, it seems to execute the line but no
changes were actually ssaved to the database.

Thanks,
Ron
"Ronald S. Cook" <rc***@westinis .comwrote in message
news:ed******** ******@TK2MSFTN GP05.phx.gbl...

>In my client Windows application, I am receiving a DataSet containing one
DataTable. This comes to my client via the business tier on a different
physical machine (we're using WCF if that matters).

After I make changes to the data in the underlying DataTable, I send the
DataSet back to the business tier. In the business tier, what should my
code look like to persist the data up to the database?

I'm assuming I need to do something like this:

Dim Connection As New SqlConnection()
Connection.Con nectionString = My.Settings.COW FeedyardConnect ionString
Dim Command As New SqlCommand()
Command.Connec tion = Connection
Dim DataAdapter As New SqlDataAdapter( )
DataAdapter.Up dateCommand = Command
DataAdapter.Up date(PenDataSet )

.. but I get the errror: "Update unable to find TableMapping['Table'] or
DataTable 'Table'."

Thanks for any help,
Ron