Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }