private void BtnThem_Click(object sender, EventArgs e) { string sql = "insert into tblChatlieu values(N'" + txtMachatlieu.Text + "',N'" + txtTenchatlieu.Text + "')"; query.Run(sql); fill(); }
private void BtnThem_Click(object sender, EventArgs e) { string sql = "insert into tblKhach values(N'" + txtMakhach.Text + "',N'" + txtTenkhach.Text + "',N'" + txtDiachi.Text + "',N'" + mskDienthoai.Text + "')"; query.Run(sql); fill(); }
private void BtnXoa_Click(object sender, EventArgs e) { string sql = "delete from tblHang where Mahang=N'" + txtMahang.Text + "'"; query.Run(sql); BtnBoqua_Click(null, null); sql = "delete from tblChatlieu where MaChatlieu=N'" + cboMachatlieu.Text + "'"; query.Run(sql); }
private void BtnThem_Click(object sender, EventArgs e) { string sql = "insert into tblNhanvien values(N'" + txtManhanvien.Text + "',N'" + txtTennhanvien.Text + "',"; if (chkGioitinh.Checked) { sql += "'nam',"; } else { sql += "'nu',"; } sql += "N'" + txtDiachi.Text + "',N'" + mskDienthoai.Text + "','" + mskNgaysinh.Text + "'"; query.Run(sql); fill(); }