Updating problem

[G. Dean Blake]

I have created a table by running a script from my code. I have also
created a matching dataset
loaded with data for this new table. I now have to get the data in the
dataset into the table.

I figured I would create a SqlDataAdapter and a SqlCommandBuilder and then
use ado.net to do my

update as follows....
sql = "SELECT SubID, Code, State, Market, CrewCount, DayRate, NightRate,
HolidayRate " & _
"FROM(SubServices)"
Dim da As New SqlDataAdapter(sql, cn)
Dim cb As New SqlCommandBuilder(da)
da.Update(newSSDS)

but this gets the following exception...


system.invalidOperationException

Unable to find tableMapping['Table'] or datatable 'Table'

Why am I getting this? Is there an easier way to do this?
TIA
G.

 

[Guest]

Where in your code do you actually populate dataset with data? You need to use .Fill method of dataAdapter to do that.

something like this:
da.Fill(Mydataset, "TableName")

 

[G. Dean Blake]

I did that of course. I didn't want to post my entire program. I built the
dataset in other code.
G

Where in your code do you actually populate dataset with data? You need to

use .Fill method of dataAdapter to do that.

something like this:
da.Fill(Mydataset, "TableName")

I have created a table by running a script from my code. I have also
created a matching dataset
loaded with data for this new table. I now have to get the data in the
dataset into the table.

I figured I would create a SqlDataAdapter and a SqlCommandBuilder and then
use ado.net to do my

update as follows....
sql = "SELECT SubID, Code, State, Market, CrewCount, DayRate, NightRate,
HolidayRate " & _
"FROM(SubServices)"
Dim da As New SqlDataAdapter(sql, cn)
Dim cb As New SqlCommandBuilder(da)
da.Update(newSSDS)

but this gets the following exception...


system.invalidOperationException

Unable to find tableMapping['Table'] or datatable 'Table'

Why am I getting this? Is there an easier way to do this?
TIA
G.