public void update(TaiKhoanObject b) { string sql = "update taikhoan set MatKhau = '" + b.MatKhau.Trim() + "',LoaiTaiKhoan = N'" + b.LoaiTaiKhoan.Trim() + "' where TenTaiKhoan = '" + b.TenTaiKhoan.Trim() + "'"; data.ExecuteSQL(sql); }
public void Delete(TaiKhoanObject b) { string sql = "Delete from taikhoan where TenTaiKhoan = '" + b.TenTaiKhoan.Trim() + "'"; data.ExecuteSQL(sql); }
public void insert(TaiKhoanObject b) { string sql = "insert into taikhoan values('" + b.TenTaiKhoan.Trim() + "','" + b.MatKhau.Trim() + "','" + b.LoaiTaiKhoan.Trim() + "')"; data.ExecuteSQL(sql); }