DataAdapter error




I've created a relational group of tables using the designer for the Data
Adapter. It decided to cross join all the tables, so I manually did it using
Inner joins, nothing special just PK to FK.

When I click preview data, then try to fill a dataset created by the
Generate Dataset button of the DataAdapter, I get the following error:

"The data adapter could not return the data from the data source."

"Syntax error converting the varchar value 'myStringValue' to a column of
data type int".

When I look at the schema of the Dataset, all the columns are varchar.
Why is it doing this?

Any suggestions/past experiences very welcome & thanks in advance.





OOPS, it wasn't the DataAdapter. I tried to join an int Key to a varchar
column which I mistook for a key...

where can I hide...

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error on DataAdapter Update 3
DataAdapter 3
dataadapter 1
DataAdapter?? 8
error when update dataadapter 0
Configuration of DataAdapter 3
DataAdapter Commands 2
Wildcars with DataAdapter 8