Can i use this method for recieve table schema of select stored procedure?
I try do this thing, but i catch exception:
----------------
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
occurred in system.data.dll
Additional information: Dynamic SQL Error
SQL error code = -204
Table unknown
TEST_SELECT
At line 1, column 15
-----------------
My code sample:
using (FbConnection connection = new FbConnection(ConnectionString))
{
connection.Open();
FbTransaction transaction = connection.BeginTransaction();
FbCommand selectCommand = new FbCommand("TEST_SELECT", connection,
transaction);
selectCommand.CommandType = CommandType.StoredProcedure;
FbDataAdapter adapter = new FbDataAdapter(selectCommand);
DataTable table = new DataTable();
adapter.FillSchema(table, SchemaType.Source);
transaction.Commit();
}
|
