private void DangNhap_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
txtTenDangNhap.Text = this.tenDangNhap;
txtMatKhau.Text = this.matKhau;
}
private void TrangChu_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
PlayMusic();
hello.Text = this.ten;
layKetQua();
}
private void GiaoDienChoi_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
this.count = 0;
danhSachButton();
danhSachPictureBox();
danhSachTienThuong();
}
private void ThongTinCaNhan_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
nd = new NguoiDung();
layThongTinNguoiDung();
txtHo.Text = nd.Ho;
txtTen.Text = nd.Ten;
gioiTinh1.Text = nd.gioiTinh;
txtSoDienThoai.Text = nd.soDienThoai;
txtEmail.Text = nd.Email;
txtDiaChi.Text = nd.diaChi;
}
private void XepHang_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
String query = "SELECT TOP 10 ROW_NUMBER() OVER (ORDER By KetQua.SoCauDung DESC) N'Số Thứ Tự' ,TaiKhoanNguoiDung.TenDangNhap N'Tên Đăng Nhập' , KetQua.SoCauDung N'Số Câu Đúng' FROM TaiKhoanNguoiDung " + "INNER JOIN KetQua ON TaiKhoanNguoiDung.IDNguoiChoi = KetQua.IDNguoiChoi";
sqlcmd = new SqlCommand(query, connect.conn);
try
{
connect.conn.Open();
SqlDataAdapter sqlapdap = new SqlDataAdapter(sqlcmd);
DataTable data = new DataTable();
sqlapdap.Fill(data);
connect.conn.Close();
dataGridView1.DataSource = data;
}
catch (SqlException ex)
{
ex.ToString();
}
connect.conn.Close();
}
private void LichSuNguoiDung_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
hienThi();
}
private void DangKi_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
}
private void CapNhatThongTin_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
}
private void DoiMatKhau_Load(object sender, EventArgs e)
{
connect = new MyConnect();
connect.Connect();
}