Batching updates with SqlDataSource

[McGeeky]

Hi. Is it possible to issue multiple update calls to a SqlDataSource within
one transaction?

E.g.

MyDataSource.BeginTrans()
MyDataSource.Insert (params...)
MyDataSource.CommitTrans()

I can't find any conclusive info on this.

Thanks!

 

[Alexey Smirnov]

Hi. Is it possible to issue multiple update calls to a SqlDataSource within
one transaction?

E.g.

MyDataSource.BeginTrans()
MyDataSource.Insert (params...)
MyDataSource.CommitTrans()

I can't find any conclusive info on this.

Here's some code:
http://www.codeproject.com/useritems/SqlDataSource_Transaction.asp

Hope it helps

 

[McGeeky]

Thanks for that link.