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.