خطا در transaction

[ahrimaneahurai]

سلام
دوستان من یه جا کدی دارم که insert هست
قبلا درست کار می کرد اما می خوام یه جا دیگه هم insert شه که از transaction استفاده کردم اما خطا میده
ممنون میشم کمک کنید



connection.Open();
tran = connection.BeginTransaction();
try
{
new SqlCommand("INSERT INTO RWP_Tbl_StoreMaster(RWP_Fld_StoreCode, RWP_Fld_StoreName, RWP_Fld_StoreLordName, RWP_Fld_StoreLordFamily, RWP_Fld_StoreTell, RWP_Fld_StoreAddress, RWP_Fld_Branch, RWP_Fld_Year, RWP_Fld_AccountCode) VALUES (" + StoreCode + "," + StoreName + "," + StoreLordName + "," + StoreLordFamily + "," + StoreTell + "," + StoreAddress + "," + Data.clsItems.CodeShobe + "," + Data.clsItems.Year + "," + Convert.ToInt32(max) + ")", connection, tran).ExecuteNonQuery();
new SqlCommand("INSERT INTO RWP_tbl_Accounts(RWP_Fld_ACoCode, RWP_Fld_ACoTitle, RWP_Fld_Branch, RWP_Fld_Year) VALUES (" + Convert.ToInt32(max) + "," + StoreLordName + StoreLordFamily + "," + Data.clsItems.CodeShobe + "," + Data.clsItems.Year + " )", connection, tran).ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();

}
connection.Close();

[tefos666]

دوست عزير نحوه صحيح كدي كه با ترنزكشن باشه اينجوريه ، اميدوارم مشكلت حل بشه:خجالت:



private void InsertDates()
{

//Transaction تعریف متغیرها جهت انجام
SqlConnection objConn = new SqlConnection(mydb.ConStr);
SqlCommand insertDataCommand = new SqlCommand();
SqlTransaction insertData_tran;
insertData_tran = null;
try
{
if (objConn.State != ConnectionState.Open)
{
objConn.Open();
}

insertData_tran = objConn.BeginTransaction();
string strSQL = string.Format("insert into tbl_dates (id_person,StartDate,EndDate,EndType) values (" + txtDocumentsID.Text + ",'" + txtstrdate.Text + "','" + txtenddate.Text + "','" + cmbendType.Text + "')");
insertDataCommand = new SqlCommand(strSQL, objConn, insertData_tran);
insertDataCommand.ExecuteNonQuery();
insertData_tran.Commit(); ;
}
catch (Exception ex)
{
insertData_tran.Rollback();
FrmMessage.Show(ex.Message, " شکست در اجرای تراکنش",MSGImageType.imgError);
}
finally
{
objConn.Close();
}
}