SqlParameter[]

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

I copied the following code from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp

SqlParameter[] paramsToStore = new SqlParameter[2];
paramsToStore[0] = New SqlParameter("@cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

I've put it in my Global.asax.cs file to call a stored procedure from there.

I've added the necessary namespaces:

using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

on the following 2 lines from above:

paramsToStore[0] = New SqlParameter("@cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

my vs.net is giving me a red wavy line under SqlParameter saying ";
expected"

I copied the code from msdn and it seems to be the same elsewhere on the
web, I don't see what the problem is.
 
alex said:
I copied the following code from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbd
a/html/daab-rm.asp

SqlParameter[] paramsToStore = new SqlParameter[2];
paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

I've put it in my Global.asax.cs file to call a stored procedure from
there.

I've added the necessary namespaces:

using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

on the following 2 lines from above:

paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

my vs.net is giving me a red wavy line under SqlParameter saying ";
expected"

I copied the code from msdn and it seems to be the same elsewhere on the
web, I don't see what the problem is.
Click to expand...

C# is case-sensitive - you need "new", not "New". The example lines you
copied were from Visual Basic.
 
I copied the following code from
http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnbda/ht
ml/daab-rm.asp

SqlParameter[] paramsToStore = new SqlParameter[2];
paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

I've put it in my Global.asax.cs file to call a stored procedure from
there.

I've added the necessary namespaces:

using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

on the following 2 lines from above:

paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

my vs.net is giving me a red wavy line under SqlParameter saying ";
expected"

I copied the code from msdn and it seems to be the same elsewhere on the
web, I don't see what the problem is.
Click to expand...

use 'new' instead of 'New'

Frans
 
Thanks guys! I can't believe I was stumped by that. That code is in the c#
code section on that msdn page, it's a typo.

Frans Bouma said:
I copied the following code from
http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnbda/ht
ml/daab-rm.asp

SqlParameter[] paramsToStore = new SqlParameter[2];
paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

I've put it in my Global.asax.cs file to call a stored procedure from
there.

I've added the necessary namespaces:

using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

on the following 2 lines from above:

paramsToStore[0] = New SqlParameter("@Cat", SqlDbType.Int);
paramsToStore[1] = New SqlParameter("@Sup", SqlDbType.Int);

my vs.net is giving me a red wavy line under SqlParameter saying ";
expected"

I copied the code from msdn and it seems to be the same elsewhere on the
web, I don't see what the problem is.
Click to expand...

use 'new' instead of 'New'

Frans
Click to expand...
 
Back
Top