|
| DataSet - Update- Error |
|
|
|
|
| Messages |
|
Related Types |
This message was discovered on microsoft.public.dotnet.framework.adonet.
| Kumar |
I tried to update datasource (SQLServer) from a DataSet
using " OleDbAdapter.Update(DataSet,'table1') ". I have a
proper OledbTransaction object in place.
But I am getting the following error:
"Execute requires a transaction object when the connection
is in a pending local transaction."
Does any one know how to solve this error.
Thanks
- R.Kumar
|
|
|
| |
|
| |
| |
| Hussein Abuthuraya(MSFT) |
Hi R Kumar,
I don't have your code, but I think I know what is the problem here. It is possible that you forgot to associate the UpdateCommand with the transaction object.
To accomplish this, you need the following line:
SqlDataAdapter.UpdateCommand.Transaction = myTrans
I hope this helps!
Thanks,
Hussein Abuthuraya
Microsoft Visual Studio .NET Readiness Team
This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved
|
|
|
| |
|
| |
| |
| Kumar |
Hi Hussein Abuthuraya
I have solved the problem. Thanks for the info.
- R.Kumar
[Original message clipped]
the UpdateCommand with the transaction object.
[Original message clipped]
2001 Microsoft Corporation. All rights reserved
>
|
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
BootFX
Reliable and powerful .NET application framework. |
|
|
|
|
|
|
