Errors encountered generating datasets.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I am working with VB.Net and Oracle 10g database on a Windows 20043 server.

I added a OleDBConnection to a form, configured the connection strings. And,
I added a OleDBDataAdapter and configured that o point to a single table with
the statement, "Select * from Customer". I Then created a dataset and
accepted the suggested dataset name dataset2.

I then dropped a Wingrid on the form and when I looked at the code, the
following two lines have been identified as wrong:

Me.DataSet21 = New test.DataSet2
and
Protected WithEvents DataSet21 As test.DataSet2

I do see an xsd file, DataSet2.xsd in my project.

What am I doing wrong?

Thanks for your help.

Venki
 
Venki,

If you rightclick on the icon of the dataadapter than you see "generate
dataset".

That creates a class (a vbnet file) for you. (you see them when you unhide
in top the files using the icon in top of the solution explorer)

Did you know that Oracle has its own provider those give you more
performance

I hope this helps,

Cor
 
Cor:

That's exactly what I did; right-click on the data adapter to create the
dataset.

Since I was stumped, I created a new solution and it did not happen in that!

Venkat
 
Venki,

And do you see that dataset.vb file now in solution explorere?

You can open it, it is just a class. (I assume that you are using Net 1.x by
the way in Net 2.0 it is a little bit different).

Cor
 
Cor:

Yes; I don't know what went wrong with the other solution. But I am all set
now. Thanks for your help.

Venki
 
Back
Top