confused about parameters passed to cmd.Parameters.Add()

Question

I am going to delete a single record from report returned by gridView, I have added edit and delete buttons in a Gridview itself, I have kept Empno=@1 in a where clause of delete query please explain what is '12' in below line.

command.Parameters.Add("@1", SqlDbType.Int,12);

Its not my code I have copied it by surfing on google – Ajay Aug 13 '15 at 13:04 — Ajay, Aug 13 '15 at 13:04

score 2 · Answer 1 · answered Aug 13 '15 at 13:07

2

command.Parameters.Add("@1", SqlDbType.Int,12);

-@1 is parameter name which given in query/store procedure
-SqlDbType.Int is type of parameter 
-12 is values given to parameter

answered Aug 13 '15 at 13:07

Ghanshyam Baravaliya

147
2
11

score 0 · Answer 2 · edited May 23 '17 at 11:51

I am not sure about your framework version.Framework version 3.5 and above command .parameters.Add method is deprecated and replaced by AddWithValue.check the link.For the reason behind check this

Syntax is

public SqlParameter AddWithValue(
    string parameterName,
    Object value
)

Usage is

    string commandText = "select * from Sales.Store WHERE CustomerID = @ID;";
    command.Parameters.AddWithValue("@ID", ID);

confused about parameters passed to cmd.Parameters.Add()

2 Answers2