webdev.webserver.exe 错误

Question

            string con = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
            OleDbConnection oledbcon = new OleDbConnection(con);
            string Sql1 = " insert into ptsc_users(user_id,user_name,group_id) values(9999,:user1,100) ";
            OleDbCommand command = new OleDbCommand(Sql1, oledbcon);
            OleDbParameter param1 = new OleDbParameter("user1", OleDbType.VarChar, 40);
            param1.Value = "mytest22";  
            oledbcon.Open();
            command.ExecuteNonQuery();
            oledbcon.Close();
我在執行這段語句的時候會出現彈出一個框提示webdev.webserver.exe 错误   內容是提示什么內存不能為read
但我把參數去掉，就單單執行一個插入語句是可以的
是不是我的語句寫的有問題 求助

Answer 1

在oledbcon.Open(); 前加上command.Parameters.Add(param1) 看看呢？

Answer 2

我試過很多方法都是這樣
        try
        {
            string con = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
            Label1.Text = con;
            OleDbConnection oledbcon = new OleDbConnection(con);
            //oledbcon.ConnectionString = con;
            //oledbcon.Open();
           // string Sql1 = " insert into ptsc_users(user_id,user_name,group_id) values(9999,:user1,100) ";
            OleDbCommand command = new OleDbCommand(" insert into ptsc_users(user_id,user_name,group_id) values(9999,:user_name,100) ", oledbcon);
            command.CommandType = CommandType.Text; 
            OleDbParameter param1 = new OleDbParameter("user_name", OleDbType.VarChar, 20);
           // param1.Direction = ParameterDirection.Input;
            //string a = "mytest22";
            param1.Value = "0000";
           // command.Parameters.Clear();
           // command.Parameters.Add("user1", OleDbType.VarChar, 40,"user_name").Value=a;
            command.Parameters.Add(param1);
            oledbcon.Open();
            command.ExecuteNonQuery();
            // OleDbDataAdapter oledbda = new OleDbDataAdapter(Sql1, oledbcon);
            // DataSet ds = new DataSet();
            //oledbda.Fill(ds);
            oledbcon.Close();
        }
        catch (Exception ey)
        {
            MessageBox.Show(ey.Message);
        }
       // GridView1.DataSource = ds.Tables[0].DefaultView;
        //GridView1.DataBind();
    }

Answer 3

string Sql1 = " insert into ptsc_users(user_id,user_name,group_id) values(9999,@user1,100) "; 
这样？