private void simpleButton1_Click(object sender, EventArgs e)
{
string sql = "select sohd, mavt ,barcodexuat, slxuat, dvt, ngayxuat, manv, dvgiaonhan, ghichu from XuatKho where XuatKho.ngayxuat >='" + Convert.ToDateTime(txtdatebd.Text).ToString("MM/dd/yyyy HH:mm:ss") + "' and XuatKho.ngayxuat<='" + Convert.ToDateTime(txtdatekt.Text).ToString("MM/dd/yyyy HH:mm:ss") + "'";
gridControl1.DataSource = ConnectDB.getTable(sql);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
string sql = "select sohd, mavt ,barcodenhap, slnhap, dvt, ngaynhap, manv, dvgiaonhan, ghichu from NhapKho where NhapKho.barcodenhap ='" + txtbarcode.Text + "' ";
gridControl1.DataSource = ConnectDB.getTable(sql);
}