GetDataTableOfRecord
public static DataTable GetDataTableOfRecord(OracleConnection conn, OracleTransaction trans, CommandType cmdType, string cmdText, params OracleParameter[] cmdParms)
{
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = new OracleCommand();
DataTable dataTable = null;
try
{
PrepareCommand(adapter.SelectCommand, conn, trans, cmdType, cmdText, cmdParms);
dataTable = new DataTable();
adapter.Fill(dataTable);
adapter.SelectCommand.Parameters.Clear();
}
catch (Exception exception)
{
dataTable = null;
throw exception;
}
return dataTable;
}
[解决办法]
获得数据库的数据并存放在dataTable中，这样就可以在程序中操作dataTable
