private void LoadcmbHH()
{
HangHoaCtr hhctr = new HangHoaCtr();
cmbHH.DataSource = hhctr.GetData();
cmbHH.DisplayMember = "TenHang";
cmbHH.ValueMember = "MaHang";
}
private void LoadNCC()
{
HangHoaCtr khctr = new HangHoaCtr();
comboBox1.DataSource = khctr.NhaSanXuat();
comboBox1.DisplayMember = "TenNSX";
comboBox1.ValueMember = "MaNSX";
comboBox1.SelectedIndex = 0;
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
HangHoaCtr hh = new HangHoaCtr();
dt = hh.GetData2("Where MaNSX = '" + comboBox1.SelectedValue.ToString() + "'");
if (dt.Rows.Count > 0)
{
dgvDanhSach.DataSource = dt;
}
else
{
MessageBox.Show("Không tìm thấy.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
dgvDanhSach.DataSource = dt;
dgvDanhSach.ClearSelection();
}
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
HangHoaCtr hh = new HangHoaCtr();
dt = hh.GetData2("Where TenMH like N'" + timkiem.Text + "%'");
if (dt.Rows.Count > 0)
{
dgvDanhSach.DataSource = dt;
}
else
{
MessageBox.Show("Không tìm thấy.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
dgvDanhSach.DataSource = dt;
dgvDanhSach.ClearSelection();
}
}
