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; }