Pass parameter value to SqlCommand

Question

I need to convert some code which passes the parameters value to SqlCommand. I can't explain this in words. so, let me take an example.

Eg:

Currently i am doing this,

Dim value1 As String = "Reference Value 1"
sql_command = New SqlCommand(query, Cn)
sql_command.Parameters.AddWithValue("@Reference1", value1)

and i want to convert the last line and the resultant code will be as below

Dim value1 As String = "Reference Value 1"
sql_command = New SqlCommand(query, Cn)
command.Parameters.Add("@Reference1", SqlDbType.VarChar);
command.Parameters["@Reference1"].Value = value1 ;

I need to change similar kind of stuff in more than 400 files so is there any other way or shortcut or something like this so that i can save my time.

Also one more thing, if we implement like this then it will increase the performance?

I think there is none. How will you know the equivalent sql data type from your c# data type? I guess you need to manually update it. ..just an idea though.. — John Woo
– John Woo, Commented Aug 8, 2014 at 4:29
I know i need to do this manually but i just need to know is there any shortcut or something like this. and one more thing. every field is varchar in database. — Sagar Rawal
– Sagar Rawal, Commented Aug 8, 2014 at 4:34
Why do you think this would increase performance. And only shortcut I would be able to think of is ctrl+h to replace, but thisis only going to work if all code looks the same — 3dd
– 3dd, Commented Aug 8, 2014 at 4:34
by default it search for the NVarchar and if you convert that then it will search into the specific type only. and for another, there are different argument so i need to do this manually. thanks to Mark. — Sagar Rawal
– Sagar Rawal, Commented Aug 8, 2014 at 5:44

Mark · Accepted Answer · 2014-08-08 04:35:08Z

1

SqlCommand.Parameters.Add returns the parameter, so you can combine the two lines:

command.Parameters.Add("@Reference1", SqlDbType.VarChar).Value = value1;

answered Aug 8, 2014 at 4:35

Mark

8,1701 gold badge16 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Pass parameter value to SqlCommand

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related