how to fill system.data.dataset from oracle.dataacess.client.oracledataadapter?

Question

0.00/5 (No votes)

See more:

Greetings,

I have installed Oracle 10g Express Edition database on a server and install the client on my PC.

Now, I`m developing a vb.net application using visual studio 2005 and I need to use the oracle 10g express edition database. SO I initialize the connection using the following connection string:

VB

_connectionString = "User Id=Graphya;Password=Graphya;Data Source=gis64:1522/XE;"

Then I define new OracleDataAdapter, and I use the following code to fill a dataset:

VB

Dim insertCommand As OracleCommand = New OracleCommand()
Dim commandTextTemplate As String = "INSERT INTO {0}(" & g_pfldUsername & ", " & g_pfldSubject & ") VALUES (?, ?)"
insertCommand.CommandText = String.Format(commandTextTemplate,TABLE_NAME)
insertCommand.Connection = Me.Connection
insertCommand.Parameters.Add(New Oracle.DataAccess.Client.OracleParameter(g_pfldUsername, Oracle.DataAccess.Client.OracleDbType.Varchar2, 50, g_pfldUsername))
insertCommand.Parameters.Add(New Oracle.DataAccess.Client.OracleParameter(g_pfldSubject, Oracle.DataAccess.Client.OracleDbType.Varchar2, 50, g_pfldSubject))

_OracleDataAdapter.InsertCommand = insertCommand

_OracleDataAdapter.Fill(_dataSet, TABLE_NAME)

So after debugging this code I got the following error:

Unable to cast object of type 'Oracle.DataAccess.Client.OracleCommand' to type 'System.Data.Common.DbCommand'.

So I`m stuck here and I need a little help , please advise....

Thanks in advance..

Posted 3-Apr-12 3:53am

dgthecodeproject

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kschuler · Accepted Answer · 2012-04-03T05:17:00

Well, the error you are getting is that you have two different types of commands and you can't just set one to the other.

I really haven't used an OracleCommand before, but after reading the MSDN[^] on it....it doesn't look like it can do a FILL. It looks like it only has capabilities of reading one line at a time with a reader, or doing scalar or non query operations.

Also, I know you say you are using VS 2005, but the .NET Framework 4 says this API is now obsolete. So it's not something that you will ever be able to upgrade to in the next versions of Visual Studio....if you ever take this project and upgrade it.

So...My suggestion is to connection to the Oracle Database with a different provider. Here[^] is a tutorial on how to link to oracle using an ole db provider. The ole db provider has the ability to perform a fill operation.

And here[^] is a list of other ways you can connect.