Need to know whether I am going correct or not

Question

Dear experts I am following way for C#.NET Programs..Keeping in mind that many user will use program at a time STEP 1 : Generate Unique Id from any table STEP 2 : Generate transaction in following way SqlConnection Con = new SqlConnection; Con.BeginTransaction STEP 3: My sql statements(Insert/Update/Delete) STEP 4: Commit or Rollback just need whether I should do any changes or not.Is the above way is good if there are more users using software at a time. Regards Mayur

Ramesh Palanivel · Answer

Hi Mayur Yes!.. You are going right way!.. Follow Nitin Sontakke what he suggest!..

Nitin Sontakke · Answer

If possible use the transaction in stored procedure itself and not in your C# code.

Ibrahim Siddique · Answer

Hi Brother you doing perfect keep going on write nice code thinking twice and writing once.

Rathrola Prem Kumar · Answer

Your are in rght path Go head :)

Narasimha Reddy Chennupalli · Answer

Yes exactly the above steps are correct. For your reference take the below example. SqlConnection conn = new SqlConnection(constring); //Step 1: Open the Sql connection conn.Open(); SqlCommand cmd = new SqlCommand(insert into moneytrans values( + cmbuserid.SelectedItem.ToString() +  + txtamount.Text + ) conn); //Step 2: Begin the transaction SqlTransaction trans = conn.BeginTransaction(); cmd.Transaction = trans; try { cmd.ExecuteNonQuery(); //Step 3: Commit the transaction trans.Commit(); MessageBox.Show(Transaction Complted. ); } catch (Exception) { //Step 4: If anything happens Roll back the transaction trans.Rollback(); MessageBox.Show(Transaction Failed..); } } conn.Close(); I hope this will help you.