C# (CSharp) DAO Provider.ExecuteInsertUpdateDelete_CloseConnection Exemples

Exemple #1

        public int UpdateTrangThaiBanAn_CommitTran(int MaBan, int trangthai)
        {
            // Provider provider = new Provider();
            DataTable tb  = new DataTable();
            string    sql = " waitfor delay '0:0:10' update BanAn set TrangThai=" + trangthai + " where MaBan=" + MaBan + " commit tran";

            provider.cm = provider.CreateCommandStringSql(sql);
            return(provider.ExecuteInsertUpdateDelete_CloseConnection(provider.cm));
        }