Devart Forums

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?

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: