Need to know whether I am going correct or not

Mayur Gujrathi

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Hi Mayur,

Yes!.. You are going right way!.. Follow Nitin Sontakke what he suggest!..
0
Nitin Sontakke9y ago
If possible, use the transaction in stored procedure itself and not in your C# code.
0
Ibrahim Siddique9y ago
Hi Brother you doing perfect keep going on write nice code thinking twice and writing once.
0
Rathrola Prem Kumar9y ago
Your are in rght path, Go head :)
0
Narasimha Reddy Chennupalli11y ago
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.
0