Transaction object

[RP]

I have a code like this:

==========================================
private void cmdProceed_Click(object sender, EventArgs e)
{
GenerateAll();
}
==========================================

I want to initialize transaction object just before GenerateAll(). The
GenerateAll procedure contains all the SQL statements, but I want to
set the transaction object before GenerateAll.

[Nicholas Paldino [.NET/C# MVP]]

RP,

So what's stopping you from doing this:

private void cmdProceed_Click(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
GenerateAll();

// Commit the transaction.
scope.Complete();
}
}
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"RP" <rp*********@gmail.comwrote in message
news:11**********************@o80g2000hse.googlegr oups.com...

>I have a code like this:

==========================================
private void cmdProceed_Click(object sender, EventArgs e)
{
GenerateAll();
}
==========================================

I want to initialize transaction object just before GenerateAll(). The
GenerateAll procedure contains all the SQL statements, but I want to
set the transaction object before GenerateAll.

[RP]

But it is giving error:

Error 23 The type or namespace name 'TransactionScope' could not be
found (are you missing a using directive or an assembly reference?)

What reference or initialization need to be done?

On Oct 11, 7:35 pm, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail]:

RP,

So what's stopping you from doing this:

private void cmdProceed_Click(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
GenerateAll();

// Commit the transaction.
scope.Complete();
}

}
- Nicholas Paldino [.NET/C# MVP]