0

I want to use array of SQl Parameters.When i searched over net I got very usefule data at below link.sqlParameters Array in VB.Net.VS2005 shows syntax error near NEW.

Code is as below

Dim parameters() As SqlParameter = New SqlParameter() _
    {
      New SqlParameter("@first_name", SqlDbType.VarChar, 50) With { .Value = "john"},
      New SqlParameter("@last_name", SqlDbType.VarChar, 50) With { .Value = "doe"},
      New SqlParameter("@age", SqlDbType.Int) With { .Value = 18},
      New SqlParameter("@id", SqlDbType.Int) With { .Value = 123}
    }
Community
  • 1
  • 1
Sachin
  • 57
  • 1
  • 1
  • 11
  • Can you show us the actual error, and which `new` does it complain about? – Binary Worrier Sep 18 '13 at 10:00
  • Expression expected error at first '{'.Then each NEW word has Syntax Error.When I used same in VS2010,it works fine – Sachin Sep 18 '13 at 10:08
  • I edited code to as ' Dim parameters() As SqlParameter = New SqlParameter() _ {New SqlParameter("@first_name", SqlDbType.VarChar, 50) With {.Value = "john"}}' still I am getting error as **} expected.** – Sachin Sep 18 '13 at 10:12

1 Answers1

1

Your code uses object initializers which where introduced in VB.Net 9.0 (Visual Studio 2008); hence you can't use them in VB.Net 8.0 (Visual Studio 2005).

You have to do it the verbose way, e.g.:

Dim parameters(3) As SqlParameter

Dim p As SqlParameter
p = New SqlParameter("@first_name", SqlDbType.VarChar, 50)
p.Value = "john"
parmaters(0) = p

p = New SqlParameter("@last_name", SqlDbType.VarChar, 50)
p.Value = "doe"
parmaters(1) = p

...
sloth
  • 99,095
  • 21
  • 171
  • 219