Hi I'm currently trying to display All the Tables in the Oracle database.But this exception error keep blocking me...
"System.InvalidOperationException: Operation is not valid due to the current state of the object."
try
{
localSQL = "SELECT table_name FROM user_tables";
OracleCommand cmdOracle = new OracleCommand(localSQL, localConnection);
cmdOracle.CommandType = CommandType.Text;
OracleDataReader drOracle = cmdOracle.ExecuteReader();
while (drOracle.Read())
{
tablelistBox.Items.Add(drOracle.GetOracleValue(0).ToString());
}
}
I've tried SELECT table_name FROM user_tables in the Oracle and it does generate the list of tables...but somehow this code does'nt work.
Any help or advice is appreciated.