private void frmTransactions_Load(object sender, EventArgs e) { //Dispay all the transactions DataTable dt = tdal.DisplayAllTransactions(); dgvTransactions.DataSource = dt; DataTable dt1 = tdal.DisplayTransactions("invoice_no", "0", "999999999"); cmbInvFrom.DataSource = dt1; cmbInvFrom.ValueMember = "invoice_no"; DataTable dt2 = tdal.DisplayTransactions("invoice_no", "0", "999999999"); cmbInvTo.DataSource = dt2; cmbInvTo.ValueMember = "invoice_no"; DataSet ds1 = dcDAL.GetDealerCustomerForTransaction(); cmbCusFrom.DataSource = ds1.Tables[0]; cmbCusFrom.ValueMember = "name"; DataSet ds2 = dcDAL.GetDealerCustomerForTransaction(); cmbCusTo.DataSource = ds2.Tables[0]; cmbCusTo.ValueMember = "name"; }