Comments by sahar11 (Top 15 by date)

I want link to an old project that write by foxpro

I close it,then open and create new project. but I get the same problem.
for reset setting: toole menu -> import and export setting -> reset all setting

I close it and then restart but ot fixed the problem
even I resest all setting of visual studio, but no thing change.

shut down VS means that close it or by other way???

I use Visual Studio(winform application). I add some component to toolbox. I use this component in my projects and dont re_install it.

Hi Hard_Rockz, thanks a lot for your attention.
I see your recommended article, and try to use this solution for my work but I have still problem whit rollback.
can I request of you to see my code and let me know my mistake.
I have a class for connect to database(access layer) and a function in this class (docommand) to execute my query. I create an instance of this class named al and then this code:


using (TransactionScope tr = new TransactionScope())
{
try
{

al.docommand("insert into st values (110,'ali',12,'red')");
al.docommand("insert into st values (111,'anna',12,'red')");
al.docommand("insert into st values (111,'sara',12,'red')");

tr.Complete();
tr.Dispose();
MessageBox.Show("Successful");

}
catch (TransactionException ex)
{
MessageBox.Show(ex.ToString());
}


catch
{
MessageBox.Show("error");
}

}


tertiary insert has an error and dont execute, but no rollback happen and two first insert has been executed and add data to my table(st).


I am sorry if my English Language is very bad.

I write this code in my project, but when happened error in procedure3, other procedures (1 and 2) executed and rollback do not happen. please see my code and help me.thanks


private void button1_Click(object sender, EventArgs e)
{
using (TransactionScope tr=new TransactionScope())
{

try
{
docommand("exec proc1"); // execute procedure1
docommand("exec proc2"); // execute procedure2
docommand("exec proc3"); // execute procedure3
tr.Complete();
tr.Dispose();
MessageBox.Show("Successful");

}

catch(TransactionException ex)
{
tr.Dispose();
MessageBox.Show(ex.ToString());
}
catch (Exception ex1)
{

MessageBox.Show(ex1.Message);

}
}
}

Thanks for your attention, but this link don't work. I can not open this page.

I add lock & unlock.
and set sessionstate mode to InProc in the Web.config file.
but the result no change!
Session_End event is raised when close a browser?

I add color name in combo at run time
what code I write Instead Of the one in question???