Archive for July, 2010
Transaction Tracking Typed Datasets Using SqlTransaction

I recently had the need to implement transaction tracking between two separate databases on two separate servers.
Unfortunately, I could not be sure that DTC was implemented on either server, so using transaction tracking with the TransactionScope wasn’t an option.
I also wanted to be able to wire this in easily to the existing 3-tiered framework we are currently using so that what I ended up with could easily be implemented by other developers in a similar situation.
Paging on a Datalist
This morning, my email had the following question:
“I am having a problem with datalist. Is it possible to do paging on datalist? If yes, what is the solution? I am using VB.NET on Microsoft Visual Studio 2008. Any recommend extension or solution?”
While I’m pretty sure I’ve addressed this in a previous article, I couldn’t find it doing a quick search, so I’ll review this issue again this morning.