>>
>>This method just ends up calling SQLCommand.ExecuteScalar(). What does your command look like that you are passing in?
>>Tim
>
>Tim,
>
>Thank you for the replies!
>
>I have not tried this as a stored procedure since I thought I could just use a simple SQL UPDATE command. The command is basically:
>
>sUpdate = "UPDATE tablename SET field = ' " + sValue + " ' WHERE some conditions";
>this.ExecScalar(sUpdate);
>
>I have stepped through the code and copied the value of sUpdate into SQL Server Management Studio to ensure the correct SQL syntax. The command executes fine so I thought it was a problem with ExecScalar.
>
>Kind Regards,
>
>Mat

Try stepping all the way through to verify it makes it to the ExecuteScalar() method of SQLCommand object. You have to have the Mere Mortals debug symbols added in order to step into that code or have the framework project added to your solution.
Tim