private void dgvTransactions_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { DataTable transactionDT = new DataTable(); 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"); DataSet tr; int id = int.Parse(dgvTransactions.Rows[e.RowIndex].Cells[0].Value.ToString()); tr = tdal.DisplayTransactionByID(id); frmPurchaseAndSales fsales = new frmPurchaseAndSales(); fsales.Show(); fsales.transactionID = id; fsales.btnCancel.Visible = true; fsales.btnReturn.Visible = true; fsales.lblTop.Text = dgvTransactions.Rows[e.RowIndex].Cells[2].Value.ToString(); fsales.cmbCustomer.Text = tr.Tables[0].Rows[0]["name"].ToString(); fsales.dtpBillDate.Value = DateTime.Parse(tr.Tables[0].Rows[0]["transaction_date"].ToString()); fsales.txtInvoiceNo.Text = tr.Tables[0].Rows[0]["invoice_no"].ToString(); foreach (DataRow dr in tr.Tables[0].Rows) { //fsales.addItemToGrid(dr[32].ToString()); fsales.transactionDT.Rows.Add(dr[32], dr["description"], dr["rate"], dr["qty"], dr["discount1"], dr["total"]); ////Add product to the dAta Grid View //transactionDT.Rows.Add(dr[32], dr["description"], dr["rate"], dr["qty"], dr["discount1"], dr["total"]); ////Show in DAta Grid View fsales.dgvAddedProducts.DataSource = fsales.transactionDT; } fsales.CalcTot(); if (double.Parse(tr.Tables[0].Rows[0]["card"].ToString()) > 0) { fsales.txtCard.Text = fsales.txtGrandTotal.Text; fsales.txtCash.Text = "0"; } if (double.Parse(tr.Tables[0].Rows[0]["cheque"].ToString()) > 0) { fsales.txtCheque.Text = fsales.txtGrandTotal.Text; fsales.txtChequeNo.Text = tr.Tables[0].Rows[0]["cheque_no"].ToString(); fsales.txtCash.Text = "0"; } //CalcTot(); //txtSearchProduct.Text = ""; //TxtQty.Text = "0.00"; }