Errors encountered generating datasets.

[vvenk]

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 OleDBDataAdapte r 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

[Cor Ligthert [MVP]]

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

"vvenk" <vv***@discussi ons.microsoft.c om> schreef in bericht
news:25******** *************** ***********@mic rosoft.com...

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 OleDBDataAdapte r 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

[vvenk]

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

"Cor Ligthert [MVP]" wrote:

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

"vvenk" <vv***@discussi ons.microsoft.c om> schreef in bericht
news:25******** *************** ***********@mic rosoft.com...

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 OleDBDataAdapte r 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

[Cor Ligthert [MVP]]

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

[vvenk]

Cor:

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

Venki

"Cor Ligthert [MVP]" wrote:

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