Retrieving data from dataset with multiple tables

  • Thread starter Thread starter paaal
  • Start date Start date
P

paaal

Hi!
Having problems with retrieving data from MS Access through a dataset
with multiple tables.
It works fine when I'm only using two tables in the dataset, but when
I want to access data through a second table (three tables in all) it
doesn't work!
This is the error message I get: "An unhandled exception of type
'System.Data.OleDb.OleDbException' occurred in system.data.dll

Please help
 
Paal:

I'm not sure I understand your problem. You can fill two tables together
without a problem but when you try referencing the second table you get an
exception?

I'd check my table mappings, make sure that none of the constraints are
being violated - that the fills are pulling back what you are intending them
to etc. Perhaps if you post the code I can be of more assistance.

Cheers,

Bill

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
paaal said:
Hi!
Having problems with retrieving data from MS Access through a dataset
with multiple tables.
It works fine when I'm only using two tables in the dataset, but when
I want to access data through a second table (three tables in all) it
doesn't work!
This is the error message I get: "An unhandled exception of type
'System.Data.OleDb.OleDbException' occurred in system.data.dll

Please help
Click to expand...
 
Back
Top