来自多个表单的数据库的Winforms数据

public partial class Form1 : Form
{
    private string connectionString = "your_connection_string_here";

    public Form1()
    {
        InitializeComponent();
    }

    private void btnSave_Click(object sender, EventArgs e)
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            string query = "INSERT INTO Users (Name, Email) VALUES (@Name, @Email)";
            SqlCommand cmd = new SqlCommand(query, conn);
            cmd.Parameters.AddWithValue("@Name", txtName.Text);
            cmd.Parameters.AddWithValue("@Email", txtEmail.Text);

            conn.Open();
            cmd.ExecuteNonQuery();
            MessageBox.Show("User saved successfully!");
        }
    }
}

public partial class Form2 : Form
{
    private string connectionString = "your_connection_string_here";

    public Form2()
    {
        InitializeComponent();
    }

    private void btnSave_Click(object sender, EventArgs e)
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            string query = "INSERT INTO Orders (UserID, ProductName, Quantity) VALUES (@UserID, @ProductName, @Quantity)";
            SqlCommand cmd = new SqlCommand(query, conn);
            cmd.Parameters.AddWithValue("@UserID", int.Parse(txtUserID.Text));
            cmd.Parameters.AddWithValue("@ProductName", txtProductName.Text);
            cmd.Parameters.AddWithValue("@Quantity", int.Parse(txtQuantity.Text));

            conn.Open();
            cmd.ExecuteNonQuery();
            MessageBox.Show("Order saved successfully!");
        }
    }
}