OracleDataAdapter and MissingSchemaAction
Posted: Tue 21 May 2013 13:59
Hi,
I have Oracle Database, and one table with 2 columns (col1, col2);
In my solution I have a DataTable to represente the table, but it have just the first colomn (col1).
I changed the MissingSchemaAction to MissingSchemaAction .Ignore to ignore the second colomn, but the adapter add it, have you a solution to my problem?
thank you in advance.
I have Oracle Database, and one table with 2 columns (col1, col2);
In my solution I have a DataTable to represente the table, but it have just the first colomn (col1).
Code: Select all
var cmd = new OracleCommande();
cmd.CommandText = "SELECT * FROM MyTable";
cmd.Connection = new OracleConnection(MyConnectionString);
var dta = new OracleDataAdapter();
dta.SelectCommand = cmd;
dta.MissingSchemaAction = MissingSchemaAction.Ignore;
dta.Fill(dataTable);
thank you in advance.