Share
ReportHello ,
when i use pure sql statement in RDP class i found this error
Cannot create a record in Temp Table
Connection is busy with results for another command
and if use regular select Statement it's run and i can get data
this problem is caused by stored procedure
My Code
connection = new Connection();
statement = connection.createStatement();
currentDataArea = curext();
query=@"exec sp";
new SqlStatementExecutePermission(query).assert();
R =statement.executeQuery(query);
CodeAccessPermission::revertAssert();
while ( R.next() )
{
temptable.clear()
....
...
temptable.insert()
}
when i debug this code the error is shown at temptable.insert()
any help
*This post is locked for comments
All responses (
Answers (
291,269
