ahrimaneahurai
چهارشنبه 05 اسفند 1388, 19:03 عصر
سلام
دوستان من یه جا کدی دارم که 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();
دوستان من یه جا کدی دارم که 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();