private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { var dialog = new MasterFile.Products(); string code = dataGridView1.Rows[e.RowIndex].Cells[colCode.Name].Value.ToString(); var dRow = DataSupport.RunDataSet("Select * from base_product join base_price on base_price.product_code = base_product.product_code where base_price.product_code ='" + code + "'").Tables[0]; if (dRow.Rows.Count > 0) { foreach (DataRow row in dRow.Rows) { dialog.txtproductCode.Text = row["product_code"].ToString(); dialog.txtCustCode.Text = row["customer_code"].ToString(); dialog.txtDescription.Text = row["description"].ToString(); dialog.dataGridView1.DataSource = DataSupport.RunDataSet("Select [uom],quantity,priceType,price from base_price where product_code ='" + code + "'").Tables[0]; } } else { var dt = DataSupport.RunDataSet("Select * from base_product where product_code ='" + code + "'").Tables[0]; foreach (DataRow row in dt.Rows) { dialog.txtproductCode.Text = row["product_code"].ToString(); dialog.txtCustCode.Text = row["customer_code"].ToString(); dialog.txtDescription.Text = row["description"].ToString(); } } Products.mode = "update"; dialog.txtproductCode.ReadOnly = true; dialog.txtCustCode.ReadOnly = true; dialog.ShowDialog(); display(); }
private void btnAdd_Click(object sender, EventArgs e) { var dialog = new MasterFile.Products(); Products.mode = ""; dialog.ShowDialog(); display(); }