insert command with parameters error?

Question

I want to insert data from c# form into oracle database .... I use this line of code

com.CommandText = "insert into DEPTS VALUES (:code, :name)";
com.Parameters.Add(new OracleParameter(
    "code", OracleType.Int32,dept_cod_txt.Text, ParameterDirection.Input));
com.Parameters.Add(new OracleParameter(
    "name", OracleType.NVarChar, dept_name_txt.Text , ParameterDirection.Input));
com.ExecuteNonQuery();`

it gives me some errors as below : enter image description here

Don't use an image at all to show text. Copy and paste the actual text. Also, @GrantWinney, surely you can come up with something better than "enter image description here"? — TRiG
– TRiG, Commented Mar 12, 2014 at 15:26
@mohsen.d - Text is preferable for code and error messages, because it is more permanent (no worry of broken links) and unlike an image, it can be copied and pasted. — Leigh
– Leigh, Commented Mar 12, 2014 at 15:47
@Leigh , yes. I added the errors text at first place when he added a link to an external image. then when he added the image here , I removed my edit. you are right anyway. — mohsen.d
– mohsen.d, Commented Mar 12, 2014 at 15:57
@mohsen.d - Ah, I did not realize you were the one to "add" the text. Thanks, text is much better than a transient image. — Leigh
– Leigh, Commented Mar 12, 2014 at 16:03

mohsen.d · Accepted Answer · 2014-03-12 15:16:14Z

1

you are adding wrong parameters.

you should use it like this

new OracleParameter(
"parameterName", OracleType, length, "db column name");

suppose your table fields are code and name. then

var codeParameter = new OracleParameter(
"code", OracleType.Int32, 4, "code");

codeParameter.Value = Convert.ToInt32(dept_cod_txt.Text);

var nameParameter = new OracleParameter(
"name", OracleType.NVarchar, 20, "name");

nameParameter.Value = dept_name_txt.Text;

com.Parameters.Add(codeParameter);
com.Parameters.Add(nameParameter);

the one with ParameterDirection parameter has a different signature.

you can find a list of all possible signatures here

edited Mar 12, 2014 at 15:16

answered Mar 12, 2014 at 14:58

mohsen.d

8,4357 gold badges44 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hunar Over a year ago

can you give me more detail please ... what js parameterName,length and db column name?

Hunar Over a year ago

thank you mohsen.d my problem is solved ... but if you can i need to do the same thing for delete,update,select query can you help me?? share the same code for delete,update and select query

Collectives™ on Stack Overflow

insert command with parameters error?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related