插入到ms Access数据库

debugcn 发表于 Dev

用户名

我正在用Windows窗体C＃实现一个litel程序，该程序将数据保存在ms ACCESS数据库中。我写这段代码

OleDbConnection connect = new OleDbConnection();
    private void button1_Click(object sender, EventArgs e)
    {
        connect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Zied\Documents\Visual Studio 2010\Projects\testerMSAcceess\testerMSAcceess\bin\Debug\zimed.mdb";
        string fname = textBox1.Text;
        string lname = textBox2.Text;

        connect.Open();
        OleDbCommand cmd = new OleDbCommand(" INSERT INTO user ([nom],[prenom]) VALUES (@fname,@lname)",connect);



        if (connect.State == ConnectionState.Open)
        {
            cmd.Parameters.AddWithValue("@fname", fname);
            cmd.Parameters.AddWithValue("@lname", lname);

            cmd.ExecuteNonQuery();
            MessageBox.Show("ajout ok ");
            connect.Close();
            try
            {
                cmd.ExecuteNonQuery();
                MessageBox.Show("ajout ok ");
                connect.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("erreur" + ex.Source);
                connect.Close();
            }

        }
        else
        {
            MessageBox.Show("probleme connection");
        }

    }

并且我执行它“插入方法中的错误”时收到此错误，我不知道插入请求中的错误。你有个主意吗

W0lfw00ds

试试这个。我在查询字符串中添加了using-statements和-brackets [ ]。

string fname = textBox1.Text;
string lname = textBox2.Text;

using(OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Zied\Documents\Visual Studio 2010\Projects\testerMSAcceess\testerMSAcceess\bin\Debug\zimed.mdb"))
using(OleDbCommand cmd = new OleDbCommand("INSERT INTO [user] ([nom],[prenom]) VALUES (@fname,@lname)", conn))
{
   try
   {
      conn.Open();

      cmd.Parameters.AddWithValue("@fname", fname);
      cmd.Parameters.AddWithValue("@lname", lname);

      cmd.ExecuteNonQuery();

      MessageBox.Show("ajout ok ");
   }

   catch (Exception ex) { MessageBox.Show("Erreur" + ex.Source); }

   finally { if (conn.State == ConnectionState.Open) { conn.Close(); } }
}

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

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