Error when i fill dataset

Error when i fill dataset

Postby hrva » Thu 28 Jul 2005 09:10

I have table "kaf_artikli" in oracle databse.

When I try to fill dataset I get this error:

An unhandled exception of type 'CoreLab.Oracle.OracleException' occurred in CoreLab.Oracle.dll

Additional information: ORA-00942: table or view does not exist

But I have this table in database!

This is code from your example:

Cursor.Current = Cursors.WaitCursor;
OracleDataAdapter.Fill(dataSet,"kaf_artikli");
dataGrid.DataSource = dataSet.Tables[0];

Why this happening?
hrva
 

Postby Oleg » Wed 03 Aug 2005 09:17

Second parameter in call of OracleDataAdapter.Fill(dataSet,"kaf_artikli");
doesn't concern table name at the server.
Please specify your OracleDataAdapter.SelectCommand.CommandText.
Try to assign table name in CommandText and TableDirect in CommandType:
Code: Select all
OracleDataAdapter.SelectCommand.CommandType = CommandType.TableDirect
OracleDataAdapter.SelectCommand.CommandText = "kaf_artikli"
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for Oracle