string sql="INSERT INTO mytable (name,value) VALUES (:n,:v)";
OleDbCommand cmd=new OleDbCommand(sql,conn);
cmd.Parameters.Add("n","hello");
cmd.Parameters.Add("v","world");
cmd.ExecuteNonQuery();不过总提示 Command parameter[2] 'v' is invalid ..请问如何写才正确???
OleDbCommand cmd=new OleDbCommand(sql,conn);
cmd.Parameters.Add("n","hello");
cmd.Parameters.Add("v","world");
cmd.ExecuteNonQuery();不过总提示 Command parameter[2] 'v' is invalid ..请问如何写才正确???
OleDbCommand cmd=new OleDbCommand(sql,conn);
cmd.Parameters.Add("@n", OracleDbType.varchar, 5, "hello"); //
cmd.Parameters.Add("@v", OracleDbType.varchar, 5,"world");
cmd.ExecuteNonQuery();