将文本框中的数据保存到 MS Access 数据库

debugcn 发表于 Dev

卡登巴克卢

这是我第一次尝试使用数据库，我被困在这里，不太确定该怎么做。这是我的代码：

        private OleDbConnection connection = new OleDbConnection();
    public AddProfile()
    {
        InitializeComponent();
        connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Caden\source\repos\PJBot\PJBot\bin\Debug\Profiles.mdb";
        connection.Open();

        //updateQuery.ExecuteNonQuery();



    }

    private void button1_Click(object sender, EventArgs e)
    {
        OleDbCommand updateQuery = new OleDbCommand("INSERT INTO Profiles (FullName,ProfileName,Email,Password,CardNumber,EXPMonth,EXPYear,CVV) VALUES(@name1,@name2,@email,@pass,@card,@expm,@expy,@cvv)", connection);
        updateQuery.Parameters.Add("@name2", OleDbType.VarChar).Value = textBox1.Text; //Profile Name
        updateQuery.Parameters.Add("@email", OleDbType.Numeric).Value = textBox2.Text; //Email
        updateQuery.Parameters.Add("@pass", OleDbType.Numeric).Value = textBox3.Text; //Pass
        updateQuery.Parameters.Add("@name1", OleDbType.VarChar).Value = textBox4.Text; //FullName
        updateQuery.Parameters.Add("@card", OleDbType.VarChar).Value = textBox5.Text; //CardNumber
        updateQuery.Parameters.Add("@expm", OleDbType.Numeric).Value = comboBox1.Text; //EXPMonth
        updateQuery.Parameters.Add("@expy", OleDbType.Numeric).Value = comboBox2.Text; //EXPYear
        updateQuery.Parameters.Add("@cvv", OleDbType.VarChar).Value = textBox7.Text; //CVV
        updateQuery.ExecuteNonQuery();
        connection.Close();
        MessageBox.Show("Profile Saved");
    }

我试图让用户根据用户在文本框中输入的内容将他的信息保存到数据库中。

李麦克

参数的顺序应与INSERT语句中指定的列的顺序相匹配，因此：

private void button1_Click(object sender, EventArgs e)
{
    OleDbCommand updateQuery = new OleDbCommand("INSERT INTO Profiles (FullName,ProfileName,Email,Password,CardNumber,EXPMonth,EXPYear,CVV) VALUES(@name1,@name2,@email,@pass,@card,@expm,@expy,@cvv)", connection);
    updateQuery.Parameters.Add("@name1", OleDbType.VarChar).Value = textBox4.Text; //FullName
    updateQuery.Parameters.Add("@name2", OleDbType.VarChar).Value = textBox1.Text; //Profile Name
    updateQuery.Parameters.Add("@email", OleDbType.Numeric).Value = textBox2.Text; //Email
    updateQuery.Parameters.Add("@pass", OleDbType.Numeric).Value = textBox3.Text;  //Pass
    updateQuery.Parameters.Add("@card", OleDbType.VarChar).Value = textBox5.Text;  //CardNumber
    updateQuery.Parameters.Add("@expm", OleDbType.Numeric).Value = comboBox1.Text; //EXPMonth
    updateQuery.Parameters.Add("@expy", OleDbType.Numeric).Value = comboBox2.Text; //EXPYear
    updateQuery.Parameters.Add("@cvv", OleDbType.VarChar).Value = textBox7.Text;   //CVV
    updateQuery.ExecuteNonQuery();
    connection.Close();
    MessageBox.Show("Profile Saved");
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。