Member Avatar for chenpaii

I've got this error: Additional information: Data type mismatch in criteria expression.

I don't know why.. I want to use split text in a textbox and insert the splitted texts to ms access.
Here is my code:

string[] splittedText1 = textBox2.Text.Split(' ');
            string[] splittedText2 = textBox1.Text.Split(' ');
            string[] splittedText3 = textBox3.Text.Split(' ');

            string vsql = "Insert into [sales] ([productname], productquantity, productprice) VALUES (?,?,?)";
            OleDbCommand CmdSql = new OleDbCommand(vsql, vcon);
            CmdSql.Connection = vcon;

            CmdSql.Parameters.AddWithValue("@productname", OleDbType.VarWChar);
            CmdSql.Parameters.AddWithValue("@productquantity", OleDbType.UnsignedTinyInt);
            CmdSql.Parameters.AddWithValue("@productprice", OleDbType.UnsignedTinyInt);

            for (int i = 0; i < splittedText1.Length; i++)
            {
                CmdSql.Parameters["@productname"].Value = splittedText1[i];
                CmdSql.Parameters["@productquantity"].Value = splittedText2[i];
                CmdSql.Parameters["@productprice"].Value = splittedText3[i];
                CmdSql.ExecuteNonQuery();
            }

please help.

  • 2 Contributors
  • 1 Reply
  • 321 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by cgeier
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.