Microsoft Access：点击窗体按钮传递外键打开关联窗体的技术需求

Got it, let's break this down—this is such a common scenario when you're working with parent-child form relationships, especially when your main form just doesn't have enough real estate for all the child data. Here's a practical, step-by-step solution to make this work smoothly:

First, we need to give Form-2 a way to receive the foreign key value from Form-1. You can do this either with a public property or an overloaded constructor (I prefer the constructor for cleaner initialization):

// Inside Form2.cs
public int ParentForeignKey { get; private set; }

// Overloaded constructor to pass the foreign key directly
public Form2(int foreignKey)
{
    InitializeComponent();
    ParentForeignKey = foreignKey;
}

// Keep the default constructor for designer support
public Form2()
{
    InitializeComponent();
}

In Form-1's button click event, grab the relevant foreign key value (from a selected grid row, text box, etc.) and pass it to Form-2 when you instantiate it:

// Inside Form1.cs - Button Click Event Handler
private void btnOpenChildForm_Click(object sender, EventArgs e)
{
    // First, get your foreign key from Form-1's UI (adjust this to match your setup)
    int selectedForeignKey = GetCurrentForeignKey();

    // Validate we have a valid key before opening the form
    if (selectedForeignKey <= 0)
    {
        MessageBox.Show("Please select a parent record first!");
        return;
    }

    // Open Form-2 with the foreign key
    using (Form2 childForm = new Form2(selectedForeignKey))
    {
        childForm.ShowDialog(); // Use Show() instead if you want a non-modal window
    }
}

// Helper method to fetch the foreign key from your Form-1 UI
private int GetCurrentForeignKey()
{
    // Example: If using a DataGridView with a selected row
    if (dataGridViewParent.SelectedRows.Count > 0)
    {
        return (int)dataGridViewParent.SelectedRows[0].Cells["ParentIDColumn"].Value;
    }

    // Example: If using a text box to display the key
    // return int.TryParse(txtParentID.Text, out int key) ? key : -1;

    // Fallback if no valid selection
    return -1;
}

Now in Form-2, use the passed foreign key to load existing child data and attach it when saving new entries. Here's how to handle both loading and adding:

// Inside Form2.cs - Form Load Event
private void Form2_Load(object sender, EventArgs e)
{
    // Load existing child records tied to the foreign key
    LoadChildData(ParentForeignKey);

    // Wire up your "Add New" button to use the foreign key
    btnAddNewRecord.Click += btnAddNewRecord_Click;
}

private void LoadChildData(int parentKey)
{
    // Replace this with your actual data access logic (SQL, EF Core, etc.)
    // Example with ADO.NET:
    DataTable childData = new DataTable();
    string connectionString = "YourDatabaseConnectionString";
    string query = $"SELECT * FROM ChildTable WHERE ParentID = @ParentID";

    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
        adapter.SelectCommand.Parameters.AddWithValue("@ParentID", parentKey);
        adapter.Fill(childData);
        dataGridViewChild.DataSource = childData;
    }

    // If using EF Core, it would look like this:
    // using (var context = new YourDbContext())
    // {
    //     var childRecords = context.ChildRecords.Where(c => c.ParentID == parentKey).ToList();
    //     dataGridViewChild.DataSource = childRecords;
    // }
}

private void btnAddNewRecord_Click(object sender, EventArgs e)
{
    // Get values from Form-2's input controls
    string childName = txtChildName.Text.Trim();
    // Add other fields as needed

    // Validate input
    if (string.IsNullOrEmpty(childName))
    {
        MessageBox.Show("Please enter a name for the new record!");
        return;
    }

    // Save the new record with the foreign key
    string connectionString = "YourDatabaseConnectionString";
    string insertQuery = @"INSERT INTO ChildTable (ParentID, Name) 
                           VALUES (@ParentID, @Name)";

    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        SqlCommand cmd = new SqlCommand(insertQuery, conn);
        cmd.Parameters.AddWithValue("@ParentID", ParentForeignKey);
        cmd.Parameters.AddWithValue("@Name", childName);
        
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }

    // Refresh the grid to show the new record
    LoadChildData(ParentForeignKey);
    // Clear input fields
    txtChildName.Clear();
}

Quick Notes to Keep in Mind #

• Non-Modal Windows: If you want Form-1 and Form-2 to stay open simultaneously, use childForm.Show(this); instead of ShowDialog()—the this makes Form-1 the owner, so Form-2 will stay on top and minimize with Form-1.
• Error Handling: Add try/catch blocks around data access code to handle database errors gracefully.
• EF Core Users: If you're using Entity Framework, the save logic becomes even simpler—just create a new child entity, set its ParentID to the passed foreign key, add it to the context, and call SaveChanges().

内容的提问来源于stack exchange，提问作者Dmurphy