cannot implicitly convert type 'int' to 'system.data.dataset'

Question

4.00/5 (1 vote)

See more:

Hi all, pls i need your help, i am trying to execute a query and put all the retrieved data in a data set, but i get this error " cannot implicitly convert type 'int' to 'system.data.dataset'".
Here's the code

C#

String Astra_conn = ConfigurationManager.ConnectionStrings["AstraSeverConnection"].ConnectionString;

System.Text.StringBuilder sql = new System.Text.StringBuilder();

this is a small piece of the sql

C#

sql.Append(" SELECT ROWNUM AS ID, institution, LPAD (a.zone_name, 3, '0') AS campus, ");
sql.Append(" term_name AS term, student_instance_id AS student_id, subject, course, ");
sql.Append(" section_name AS section_num, offering AS title, ");

Its OracleConnection because it is an Oracle server otherwise, it would be SqlConnection.

C#

DataSet rs = new DataSet();
   OracleConnection Astra_db_Conn = new OracleConnection(Astra_conn);
   string myquery = sql.ToString();
   OracleCommand cmd = new OracleCommand(myquery);

   Astra_db_Conn.Open();
   try
   {
       SqlDataAdapter adpt = new SqlDataAdapter();
       rs = cmd.ExecuteNonQuery(); // this is where is get the error.
       adpt.Fill(rs);

   }
   catch(Exception e)
   {
  log.Error("*** ERROR *** IRISExportQueries.loadStudentInfoLearningSites():" + e);

   }

I have also tried
Astra_db_Conn.Open();

C#

 try
 {
     SqlDataReader reader = new SqlDataAdapter();
     reader = cmd.ExecuteNonQuery(); // this is where is get the error.
 

 }
 catch(Exception e)
 {
log.Error(&quot;*** ERROR *** IRISExportQueries.loadStudentInfoLearningSites():&quot; + e);</pre>

 }

But then i get the error: "cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlDataReader'".

Thanks your help will be very much appreciated.

Posted 14-Aug-13 15:10pm

rudolph098

Updated 14-Aug-13 20:39pm

Thanks7872

v2

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)

Ron Beyer · Accepted Answer · 2013-08-14T15:19:00

Solution 1

ExecuteNonQuery returns an integer of the number of rows/records affected by the operation. Instead of using ExecuteNonQuery you need to use ExecuteReader.

ExecuteNonQuery -> Used for Updates, Inserts and Deletes mostly.
ExecuteReader -> Returns a data reader that can load records, for Select statements.
ExecuteScalar -> Returns the first column of the first record returned by the query. Useful for counting, averaging, etc.

Posted 14-Aug-13 15:19pm

Ron Beyer

Comments

rudolph098 14-Aug-13 21:58pm

Thanks that solved on problem, but there is a new one.

Since its an oracleDb, i decided to change all the classes since there was the Oracle version for all the Sql.

To clarify: Dataset data1 = new Dataset(), so the oracle version of this is OracleDataset data1 = new Dataset(). So for all the other like SqlDataReader, SqlDataAdapter etc. all i did was to add Oracle in front of it for the purpose of uniformity and so the V.S stops complaining about conversion between the classes.

but the real question is that i am getting a new error message, after i made this change

OracleConnection Astra_db_Conn = new OracleConnection(Astra_conn);
string myquery = sql.ToString();
OracleCommand cmd = new OracleCommand(myquery);

Astra_db_Conn.Open();
try
{
OracleDataAdapter adpt = new OracleDataAdapter();
rs=cmd.ExecuteReader(); // this is where i get the error
adpt.Fill(rs);

} catch(Exception e)
{
log.Error("*** ERROR *** IRISExportQueries.loadStudentInfoLearningSites():" + e);

}

// but then i get the error: "cannot implicitly convert type 'Data.Oracle.OracleDataReader' to 'Data.Oracle.OracleDataSet'"

// thanks for the help

Ron Beyer 14-Aug-13 22:02pm

Please see StackOverflow answer for an example on how to fill an Oracle dataset.

rudolph098 14-Aug-13 23:07pm

thank you.

Ron Beyer 15-Aug-13 0:02am

Please mark this as Answer if this solved your problems so people in the future can find it.