Unable to generate a Datset using OledbDataAdapter in VB.net

G

Guest

I am Using (Windows XP) Visual Studio.net 2003 professional edition working
on VB.net language.
I am bulding a very very simple project in VB.net where i connect to Access
Database by dragging OledbDataAdapter tool from the Data tab of the Toolbox.
When OledbDataAdapter has been added to the Component tray i am able to
generate a connection to Access database and generate Connection object and
also the Test Connection has Succeeded.
Now when i right click the DataAdapter in the Component tray and click
Generate Dataset and choose New Radio button option and click ok i get the
Following Error Message.

********Error:There were Problems generating Startup.08.Dataset1.To resolve
this Problem ,build

the Project ,fix any Errors,and themn generate the dataset again.***********

However the OledbDataAdapter added a file named "Dataset1.xsd" in the
Solution Explorer and also
i am able to view the contents of that Dataset1.xsd but unable to generate
the Dataset.

I have tried to build the project again where i dont have to........and also
checked for any possible errors.I haven't found any errors under my notice.
Please help me out with this specific

Problem.
So ,please help to generate the Dataset in design mode using
OledbDataAdapter tool from the Data
tab of ther tool box.
 
J

Jeff Dillon

Use the Configure DataAdapter wizard, and put in a very simple SQL statement
with no Where clause. Then Generate Dataset, does that work?

Jeff
 

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

Top