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();
}
