public bool capNhatThongTinGiaoVien(string maGiaoVien, string diaChi, string dienThoai)
{
string sqlString = "UPDATE GiaoVien\n" +
"SET DiaChi = N'" + diaChi + "', SoDT = '" + dienThoai + "'\n" +
"WHERE MaGV = '" + maGiaoVien + "'";
return(database.myExecuteNonQuery(sqlString, CommandType.Text));
}
public bool themHocSinhVaoDanhSachLop(string maHS, string ten, string gioiTinh, DateTime ngaySinh, string diaChi, string lop)
{
string sqlString = "INSERT INTO HocSinh VALUES " +
"('" + maHS + "', N'" + ten + "', N'" + gioiTinh + "', '" + ngaySinh.ToString() + "', N'" + diaChi + "')\n" +
"INSERT INTO Hoc VALUES ('" + maHS + "', '" + lop + "')";
return(database.myExecuteNonQuery(sqlString, CommandType.Text));
}