private void DocDL() { SQLSocket sk = new SQLSocket(); DataTable tb = sk.SelectAll(); dgvDanhSach.DataSource = tb; dgvDanhSach.Refresh(); }
private void btXoa_Click(object sender, EventArgs e) { // Cap nhat du lieu vao CSDL SQLSocket sk = new SQLSocket(); int dem = sk.Delete(int.Parse(dgvDanhSach.SelectedRows[0].Cells["ID"].Value.ToString())); if (dem == 1) { DocDL(); btLuu.Enabled = false; btXoa.Enabled = false; LamMoi(); } }
private void btThem_Click(object sender, EventArgs e) { // Kiem tra du lieu nguoi dung nhap tu giao dien // Cap nhat du lieu vao csdl tu xa SQLSocket sk = new SQLSocket(); int dem = sk.Insert(tbTen.Text, tbEmail.Text, float.Parse(tbDiemTB.Text), dpNgaySinh.Value); if (dem == 1) { DocDL(); btLuu.Enabled = false; btXoa.Enabled = false; LamMoi(); } }
private void btLuu_Click(object sender, EventArgs e) { // Kiem tra du lieu dau vao // Cap nhat du lieu vao CSDL SQLSocket sk = new SQLSocket(); int dem = sk.Update(int.Parse(dgvDanhSach.SelectedRows[0].Cells["ID"].Value.ToString()), tbTen.Text, tbEmail.Text, float.Parse(tbDiemTB.Text), dpNgaySinh.Value); if (dem == 1) { DocDL(); btLuu.Enabled = false; btXoa.Enabled = false; LamMoi(); } }