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"; }
private void frmPurchaseAndSales_Load(object sender, EventArgs e) { this.KeyUp += new System.Windows.Forms.KeyEventHandler(KeyEvent); //Get the transactionType value from frmUserDashboard string type = frmUserDashboard.transactionType; //Set the value on lblTop lblTop.Text = type; //Specify Columns for our TransactionDataTable transactionDT.Columns.Add("Code"); transactionDT.Columns.Add("Product Name"); transactionDT.Columns.Add("Rate"); transactionDT.Columns.Add("Quantity"); transactionDT.Columns.Add("Discount"); transactionDT.Columns.Add("Total"); //Get the keyword fro the text box //string keyword = txtSearch.Text; //if (keyword == "") //{ // //Clear all the textboxes // txtName.Text = ""; // txtEmail.Text = ""; // txtContact.Text = ""; // txtAddress.Text = ""; // return; //} //Write the code to get the details and set the value on text boxes //DeaCustBLL dc = dcDAL.GetDealerCustomerForTransaction(); txtInvoiceNo.Text = tDAL.GetNextInvoiceNo(type).ToString(); DataSet ds = dcDAL.GetDealerCustomerForTransaction(); //Now transfer or set the value from DeCustBLL to textboxes cmbCustomer.DataSource = ds.Tables[0]; cmbCustomer.ValueMember = "name"; cmbCustomer.DisplayMember = "name"; this.ActiveControl = txtSearchProduct; //Get Item list DataTable items = pDAL.Search(""); cmbItemName.DataSource = items; cmbItemName.ValueMember = "name"; cmbItemName.DisplayMember = "description"; //foreach (DataGridViewRow row in dgvAddedProducts.Rows) //{ // transactionDT.Rows.Add(row.Cells[0].Value, row.Cells[1].Value, row.Cells[2].Value, row.Cells[3].Value, row.Cells[4].Value, row.Cells[5].Value); // //foreach (DataGridViewCell cell in row.Cells) // //{ // // transactionDT.Rows[transactionDT.Rows.Count - 1][cell.ColumnIndex] = cell.Value.ToString(); // //} //} }