C# .NET OleDbConnection INSERT

[Sabine25]

Hello,
It's the first time that I program in C# with Visual Studio and I've got a problem,
I would like to know where is my error!

This is my code:

OleDbConnection conn = null;
        private void button1_Click(object sender, EventArgs e)
        {
 
 
            try
            {
                conn = new OleDbConnection("Provider=OraOLEDB.Oracle;"
              + "Data Source=***********;"
              + "User ID=**************;"
              + "Password=***************;");
                conn.Open();
 
                OleDbCommand cmd = new OleDbCommand("INSERT INTO user_mpl (Value1,Value2,Value3) VALUES (?,?,?);", conn);
                //OleDbParameter param1 = new OleDbParameter();
                //OleDbParameter param2 = new OleDbParameter();
                //param1.ParameterName = "@user";
                //param2.ParameterName = "@password";
                //param1.Value = textBox1.Text;
                //param2.Value = textBox2.Text;
                cmd.Parameters.Add("@Value1", OleDbType.Integer).Value =textBox3.Text;
                cmd.Parameters.Add("@Value2", OleDbType.VarChar, 10).Value = textBox2.Text;
                cmd.Parameters.Add("@Value3", OleDbType.VarChar, 10).Value =textBox1.Text;
 
 
                cmd.ExecuteNonQuery();
 
 
            }
            finally
            {
 
                conn.Close();
            }
 
 }
 

My message error is:
"Invalid Chararcter" for cmd.ExecuteNonQ uery();


Thanks for your Help

Sabine

[kenobewan]

Welcome to the site. First check the input from your textboxes. Then see if that input matches the data type of your field design.