C#

Dewald wrote:

If you put your SqlTransaction in a using block, when is it committed?

Dewald wrote:

What happens if an exception occurs?

Dewald wrote:

Will it automatically roll back?

I are Troll

using (SqlConnection cn = new SqlConnection()) 
using (SqlTransaction tr = cn.BeginTransaction())      
{ 
      //some code 
      tr.Commit(); 
} 

  using (SqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction())
{
    // First SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }   // Second SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }
    mySqlTransaction.Commit();
}

SqlTransaction mySqlTransaction = new;
try
{
   mySqlTransaction = mySqlConnection.BeginTransaction();
   // First SQL command that is part of an atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   // Second SQL command that is part of an atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   mySqlTransaction.Commit();

   // Now we do stuff during which we don't want to have the DB locked

   mySqlTransaction = mySqlConnection.BeginTransaction();
   // First SQL command that is part of another atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   // Second SQL command that is part of another atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }
}
catch
{
   mySqlTransaction.Rollback();
}

Dewald wrote:

can I start the transaction again or do I have to close the using block and open a new using block to start a new transaction?

Dewald wrote:

but not a SqlTransaction

Dewald wrote:

nothing else inside

Dewald wrote:

what is this "using" keyword called?

Rags1512 wrote:

we know everything in .Net is derived from System.Object, even value and reference types.

Rags1512 wrote:

Question is where does the employeeCount will get stored(Stack or Heap) and Where does the cmpny gets stored?

Rags1512 wrote:

So, how does CLR differentiate between the two and stores the value type on Stack and reference types on Heap?

Rags1512 wrote:

we know everything in .Net is derived from System.Object, even value and reference types.

Rags1512 wrote:

will get stored(Stack or Heap)

Rags1512 wrote:

how does CLR differentiate between the two

Rags1512 wrote:

stores the value type on Stack and reference types on Heap

Rags1512 wrote:

Question is where does the employeeCount will get stored(Stack or Heap) and Where does the cmpny gets stored?

con = new SqlConnection("server=xxx;database=xxx;uid=xxx;pwd=xxx");
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = StartDate.Text;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = EndDate.Text;
cmd = new SqlCommand("insert_with_sproc", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();

private void FillTreeNodes()
   {
       SysClass sysclass = new SysClass();
       DataSet ds= sysclass.GetAllSysClasss();

       TreeNode node;

       foreach (DataRow row in ds.Tables[0].Rows)
       {
           node = new TreeNode();
           node.Text = row["Class"].ToString();
           node.Value = row["ClassId"].ToString();
           node.NavigateUrl = "UpdateClass.aspx?classId="+node.Value;
           GenerateSemesters(node,int.Parse(row["ClassId"].ToString()));
           tree1.Nodes.Add(node);
       }
   }

   private void GenerateSemesters(TreeNode node,int classid)
   {
    Semester semester=new Semester();
    DataSet ds = semester.GetAllSemesters(classid);
       TreeNode childenode;
       foreach (DataRow row in ds.Tables[0].Rows)
       {
           childenode = new TreeNode();
           childenode.Text = row["SemesterName"].ToString();
           childenode.Value = row["SemesterId"].ToString();
           childenode.NavigateUrl = "Updatesemester.aspx?semesterId=" + childenode.Value;


           node.ChildNodes.Add(childenode);
       }
   }