c# - 如何将文本框值添加到 Access 数据库？

Question

我想将文本框值添加到 Access 数据库中的相关列，连接已经建立，但是当我单击提交按钮时，值没有被添加。这是我试过的代码，感谢任何帮助

protected void Button1_Click(object sender, EventArgs e)
{
    string EmailAddress = TextBox1.Text;
    string UserName = TextBox2.Text;
    string Password = TextBox3.Text;

    try
    {
        OleDbConnection con = new OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:\Users\Bheki Ndhlovu\source\WebSites\WebSite8\App_Data\UserDatabase.accdb; Persist Security Info = False;");

        OleDbCommand cmd = new OleDbCommand();
        cmd = new OleDbCommand("INSERT INTO User(EmailAddress, UserName, Password) VALUES(@EmailAddress, @UserName, @Password)");
        con.Open();


         if (con.State == ConnectionState.Open)
         {
             TextBox1.Text = "sssss";

             cmd.Parameters.Add("@EmailAddress", OleDbType.VarChar).Value = TextBox1.Text;
             cmd.Parameters.Add("@UserName", OleDbType.VarChar).Value = TextBox2.Text;
             cmd.Parameters.Add("@Password", OleDbType.VarChar).Value = TextBox3.Text;

            cmd.ExecuteNonQuery();
            con.Close();

         }


    }
    catch (Exception error)
    {
        //Show error message as    error.Message
    }

}

Answer 1

尝试使用 OleDbCommand 添加连接字符串。

cmd = new OleDbCommand("INSERT INTO User(EmailAddress, UserName, Password) VALUES(@EmailAddress, @UserName, @Password)",con);