Hi,
I'm having a problem using the SqlDataSource control. When the SqlDataSource control needs to execute a DELETE command, I keep getting en error saying "'orginal_id' parameter is missing at the statement". Here is a bit of my code:
"
OldValuesParameterFormatString="original_{0}" ProviderName=""
SelectCommand="SELECT * FROM dapexportfields WHERE (typeid = ?) ORDER BY srt DESC" UpdateCommand="UPDATE dapexportfields SET name = ?, fielddescription = ?, valuedescription = ?, defaultvalue = ?, dbfieldname = ?,format = ?,srt = ? WHERE (id = ?)" DeleteCommand="DELETE FROM dapexportfields WHERE (id = ?)">
The SELECT and UPDATE statements both work fine. The "OldValuesParameterFormatString" property of the control is set to "original_{0}"(which is the default value). The error is probably being caused by the SqlDataSource not being able to access the ORGINAL values from the dataset. Does anyone have a solution for this problem ?
Thanks in advance,
Jordan.