A
Andrew
I've :
<asp:sqldatasource runat="server"
id="sql"
providername="System.Data.OracleClient"
datasourcemode="DataReader"
connectionstring="..."
selectcommand="..."
deletecommand="delete from tbl where id=:id"/>
<asp:gridview runat="server"
datasourceid="sql"
datakeynames="id"
autogeneratedeletebutton="true"/>
click on delete button throws oracle exception :
ORA-01036 illegal variable name/number
Cause: Unable to find bind context on user side.
Action: Make sure that the variable being bound is in the SQL statement.
What it means?I've declared parameter as ":id" in sql and described
datakeynames as "id"...
How I can turn on tracing for ADO/parameter binding for GridView,if it
available?
Thanks.
<asp:sqldatasource runat="server"
id="sql"
providername="System.Data.OracleClient"
datasourcemode="DataReader"
connectionstring="..."
selectcommand="..."
deletecommand="delete from tbl where id=:id"/>
<asp:gridview runat="server"
datasourceid="sql"
datakeynames="id"
autogeneratedeletebutton="true"/>
click on delete button throws oracle exception :
ORA-01036 illegal variable name/number
Cause: Unable to find bind context on user side.
Action: Make sure that the variable being bound is in the SQL statement.
What it means?I've declared parameter as ":id" in sql and described
datakeynames as "id"...
How I can turn on tracing for ADO/parameter binding for GridView,if it
available?
Thanks.