I'll take a look at it Ben, but I don't know how much time I can devote to it. Is it C# or VB? I don't have VB loaded at all, but I can still take a look (although it might be tougher).

~~Bonnie


>>>I am trying to write some code utilizing an SQL Transaction in order to be able to RollBack in case any portion of the data manipulation being performed fails. Unfortunatly I am getting the following error:
>>>

>>>System.InvalidOperationException: ExecuteScalar requires the command to have a transaction when the connection assigned
>>>to the command is in a pending local transaction.  The Transaction property of the command has not been initialized.
>>>

>>>I have checked online and have found a few references to this error, but the so-called solutions to them, are apparently what I have in my code already. So I am really at a loss. This error specifically happens when I call the DataTable.Update() method to push data changes back up to the SQL Server.
>>
>>Didn't think there was a DataTable.Update(). Do you mean TableAdapter (or DataAdapter). You probably need to post some code anyway..
>>Best,
>>Viv
>
>I created an SQL DataWrapper class, added an Update() method to the DataTable class which calls the Update on the DataAdapter. It's hard to post the individual peices of code because it's integrated into a hude class I wrote. I can send the code via E-Mail to whoever is willing to help look at it. But I can't really post it publically...since my agency owns the code... If your interested in taking a look and trying to help, let me know.
>
>Thanks in advance for anyone interested in helping.