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.