private void frmPurchaseNew_Load(object sender, EventArgs e) { //loading ComboBox DAL.Ledger ld = new DAL.Ledger(); DAL.Employee em = new DAL.Employee(); DAL.Product p = new DAL.Product(); DAL.Purchase pr = new DAL.Purchase(); cmbLedger.DataSource = ld.select().Tables[0]; cmbLedger.DisplayMember = "name"; cmbLedger.ValueMember = "id"; cmbLedger.SelectedValue = -1; cmbEmployee.DataSource = em.select().Tables[0]; cmbEmployee.DisplayMember = "name"; cmbEmployee.ValueMember = "id"; cmbEmployee.SelectedValue = -1; //product colProduct.DataSource = p.select().Tables[0]; colProduct.DisplayMember = "name"; colProduct.ValueMember = "id"; this.MaximumSize = this.Size; this.MinimumSize = this.Size; }
private void btnSearch_Click(object sender, EventArgs e) { DAL.Ledger ld = new DAL.Ledger(); ld.Search = txtSearch.Text; ld.Contact = Convert.ToString(txtContact.Text); ld.Email = Convert.ToString(txtEmail.Text); //dateSearch ld.isDateSearch = ucDateSearch1.isEnabled; ld.DateFrom = ucDateSearch1.DateFrom; ld.DateTo = ucDateSearch1.DateTo; dgvLedger.DataSource = ld.select().Tables[0]; }