How to create a link to a child form when I click the ID on the parent

Question

I want to create a sales form (parent) on the sales table with the unique code to each item; which displays its corresponding list items. I want also to create another form (child) on the same sales table with blank textboxes to enter date, qty, unitprice and totalprice.

I want to create a link to the two forms so that when I click on the unique code on the main form with the detailed items displayed, the child form would display with blank form so that I can fix the sale prices and date to appear against the list items.

I will be thanksful for an assistance to complete my project successfully.

Thanks

Aman Gupta · Answer

Hi David, To achieve the functionality where clicking on a unique code in the parent form opens a child form with blank textboxes to enter data, you can follow these steps in a Windows Forms application (assuming you're working with WinForms). The general approach involves passing the selected ID from the parent form to the child form. Steps: Create the Parent Form (Sales Form): The parent form will display a list of items from the sales table. You will have an identifier (unique code) for each item. When you click the unique code (or row), it opens the child form. Create the Child Form: The child form will contain blank textboxes for the user to enter Date, Quantity, Unit Price, and Total Price. The child form will receive the unique code from the parent form. Link the Forms: When a unique code is clicked, open the child form and pass the unique code to it. Example Implementation: 1. Parent Form (Sales Form) This form displays a DataGridView with sales items. When you click an item, it opens the child form. public partial class SalesForm : Form { public SalesForm() { InitializeComponent(); LoadSalesItems(); } // This method loads items from the sales table into the DataGridView private void LoadSalesItems() { // Simulating loading data dataGridView1.DataSource = GetSalesData(); } // Simulated method to fetch sales data private List GetSalesData() { return new List { new SaleItem { UniqueCode = "001", ItemName = "Item 1" }, new SaleItem { UniqueCode = "002", ItemName = "Item 2" } }; } // Event handler for when a cell is clicked in the DataGridView private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { // Get the selected unique code from the clicked row string uniqueCode = dataGridView1.Rows[e.RowIndex].Cells["UniqueCode"].Value.ToString(); // Open the child form and pass the unique code ChildForm childForm = new ChildForm(uniqueCode); childForm.ShowDialog(); } } } public class SaleItem { public string UniqueCode { get; set; } public string ItemName { get; set; } } 2. Child Form (Blank Form for Entering Details) This form will display textboxes where the user can enter the details. The unique code will be passed to it. public partial class ChildForm : Form { private string uniqueCode; // Constructor accepts the unique code passed from the parent form public ChildForm(string uniqueCode) { InitializeComponent(); this.uniqueCode = uniqueCode; lblUniqueCode.Text = "Unique Code: " + uniqueCode; } // Add logic to save entered data to the database private void btnSave_Click(object sender, EventArgs e) { // Retrieve data from textboxes string date = txtDate.Text; int quantity = int.Parse(txtQuantity.Text); decimal unitPrice = decimal.Parse(txtUnitPrice.Text); decimal totalPrice = quantity * unitPrice; // Save data to the sales table or another table SaveData(date, quantity, unitPrice, totalPrice); // Close the form after saving this.Close(); } private void SaveData(string date, int quantity, decimal unitPrice, decimal totalPrice) { // Logic to save data into the database } } 3. DataGridView Setup in Parent Form Make sure the DataGridView on the parent form has a column for the UniqueCode and that the CellClick event is wired up. // In the designer, hook up the CellClick event to dataGridView1_CellClick this.dataGridView1.CellClick += new DataGridViewCellEventHandler(this.dataGridView1_CellClick); The parent form lists sales items, each with a unique code. When a unique code is clicked, the child form opens with blank textboxes to enter sales details (like date, quantity, price). Data entered in the child form can then be saved back into the database. This approach keeps the logic modular and allows for easy data entry and updates between the two forms. Let me know if you need any adjustments or further details!

pavina · Answer

from what i understand you want to create a sales application with two forms: a parent form that displays items with unique codes and allows users to click on a code to open a child form. The child form will have blank fields for entering sales details like date, quantity, unit price, and total price. so in the Parent Form (Sales Form): Display Unique Codes in a DataGridView. Handle Click Event: in child form: Modify the constructor to accept the unique code. Add TextBoxes for date, qty, unit price, and total price in the child form. public partial class SalesForm : Form { public SalesForm() { InitializeComponent(); // Load your data into a DataGridView } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == /* unique code column index */) { string uniqueCode = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); new ChildForm(uniqueCode).ShowDialog(); } } } Parent Page: "> Child Page: protected void Page_Load(object sender, EventArgs e) { string uniqueCode = Request.QueryString["code"]; // Use the uniqueCode as needed // Create TextBoxes for date, qty, unit price, total price } hope this is helpfull

How to create a link to a child form when I click the ID on the parent

Answers (2)