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?
Error when i fill dataset
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:
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"