public string UpdateStockDataSet(DataTable dt)
{
SqlTransaction tran = null;
string retval ="0";
try
{
var cn = new SqlConnection(_constr);
cn.Open();
//int autosed = int.Parse(Utils.Company)*1000000;
//var str = " DBCC CHECKIDENT (STOCKMASTER , RESEED, + autosed +) ";
//var cmd = new SqlCommand(str, cn);
//cmd.ExecuteNonQuery();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter();
ta.AssignConnection(cn, tran);
if (ta.Update((DsInventory.STOCKMASTERDataTable) dt) > 0)
retval = "1";
tran.Commit();
}
catch (Exception ex)
{
if (tran != null) tran.Rollback();
retval = ex.ToString();
}
return retval;
}
