SqlParameter Class

[Guest]

When I use below code I get "Parameter count does not match Parameter Value
count".

Anyone know why I get this?

SqlParameter[] sqlParameters = new SqlParameter[2];

sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar);
sqlParameters[0].Value = ntUserName;

sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit);
sqlParameters[1].Value = 0;

DataSet dsEmployee = null;
dsEmployee =
SqlHelper.ExecuteDataset(Configuration.GetAppConfigSetting("SQLConnect"),
"GetEmployee", sqlParameters);

 

[Miha Markic [MVP C#]]

Perhaps SqlHelper.ExecuteDataset expects more parameters. Or less.

 

[MSDN]

forgot if sqlParameter[x] is zero based or not

Perhaps SqlHelper.ExecuteDataset expects more parameters. Or less.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

When I use below code I get "Parameter count does not match Parameter
Value
count".

Anyone know why I get this?

SqlParameter[] sqlParameters = new SqlParameter[2];

sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar);
sqlParameters[0].Value = ntUserName;

sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit);
sqlParameters[1].Value = 0;

DataSet dsEmployee = null;
dsEmployee =
SqlHelper.ExecuteDataset(Configuration.GetAppConfigSetting("SQLConnect"),
"GetEmployee", sqlParameters);

 

[MSDN]

Forgot if SqlParameter[] sqlParameters = new SqlParameter[x]; is zero
based or not??

where x = 1 or 2 ??

SqlParameter[] sqlParameters = new SqlParameter[1];

Also it should tell you if the number of Parameters are correct for the
Stored procedure "GetEmployee". you are not getting that error.


SA

Perhaps SqlHelper.ExecuteDataset expects more parameters. Or less.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

When I use below code I get "Parameter count does not match Parameter
Value
count".

Anyone know why I get this?

SqlParameter[] sqlParameters = new SqlParameter[2];

sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar);
sqlParameters[0].Value = ntUserName;

sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit);
sqlParameters[1].Value = 0;

DataSet dsEmployee = null;
dsEmployee =
SqlHelper.ExecuteDataset(Configuration.GetAppConfigSetting("SQLConnect"),
"GetEmployee", sqlParameters);

 

[Miha Markic [MVP C#]]

It is zero based.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

forgot if sqlParameter[x] is zero based or not

Perhaps SqlHelper.ExecuteDataset expects more parameters. Or less.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

When I use below code I get "Parameter count does not match Parameter
Value
count".

Anyone know why I get this?

SqlParameter[] sqlParameters = new SqlParameter[2];

sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar);
sqlParameters[0].Value = ntUserName;

sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit);
sqlParameters[1].Value = 0;

DataSet dsEmployee = null;
dsEmployee =
SqlHelper.ExecuteDataset(Configuration.GetAppConfigSetting("SQLConnect"),
"GetEmployee", sqlParameters);

 

[Cowboy \(Gregory A. Beamer\)]

WHere are you hooking the parameters up to the command object?

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Miha Markic [MVP C#]]

I was assuming in SqlHelper.ExecuteDataset method call in the last line.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

WHere are you hooking the parameters up to the command object?

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

When I use below code I get "Parameter count does not match Parameter
Value
count".

Anyone know why I get this?

SqlParameter[] sqlParameters = new SqlParameter[2];

sqlParameters[0] = new SqlParameter("@NTUserName", SqlDbType.VarChar);
sqlParameters[0].Value = ntUserName;

sqlParameters[1] = new SqlParameter("@FlgActive", SqlDbType.Bit);
sqlParameters[1].Value = 0;

DataSet dsEmployee = null;
dsEmployee =
SqlHelper.ExecuteDataset(Configuration.GetAppConfigSetting("SQLConnect"),
"GetEmployee", sqlParameters);