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

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!