SqlHelper.ExecuteScalar

[Neven Klofutar]

Hi,

I have a problem with SqlHelper.ExecuteScalar ...

When I try to execute SqlHelper.ExecuteScalar I get this message:
"System.InvalidCastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
"GetFullUserName");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
"GetFullUserName", arrSqlParam);

------------------------
CREATE PROCEDURE GetFullUserName
@strUserName nvarchar(50),
@strUserNameFull nvarchar(100) OUT
AS

SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
[tblUsers].[user_name] = @strUserName)
GO

[Tampa .NET Koder]

ExecuteScalar returns a Object type..you should cast this object to a string
like so:

strFullUserName = (string)
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
"GetFullUserName", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.ExecuteScalar ...

When I try to execute SqlHelper.ExecuteScalar I get this message:
"System.InvalidCastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
"GetFullUserName");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
"GetFullUserName", arrSqlParam);

------------------------
CREATE PROCEDURE GetFullUserName
@strUserName nvarchar(50),
@strUserNameFull nvarchar(100) OUT
AS

SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
[tblUsers].[user_name] = @strUserName)
GO

[Neven Klofutar]

It's not that, I still get an error, I also tried this:

strFullUserName =
Convert.ToString(Utility.SqlHelper.ExecuteScalar(U tility.DB.getConnectiongSt
ring(), "GetFullUserName", arrSqlParam));
"Tampa .NET Koder" <Ta***********@discussions.microsoft.com> wrote in
message news:C3**********************************@microsof t.com...

ExecuteScalar returns a Object type..you should cast this object to a string like so:

strFullUserName = (string)
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
"GetFullUserName", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.ExecuteScalar ...

When I try to execute SqlHelper.ExecuteScalar I get this message:
"System.InvalidCastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
"GetFullUserName");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(), "GetFullUserName", arrSqlParam);

------------------------
CREATE PROCEDURE GetFullUserName
@strUserName nvarchar(50),
@strUserNameFull nvarchar(100) OUT
AS

SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
[tblUsers].[user_name] = @strUserName)
GO

[Neven Klofutar]

Utility.SqlHelper ... is not an error, I put it in my library ...

Neven

strFullUserName =
Convert.ToString(Utility.SqlHelper.ExecuteScalar(U tility.DB.getConnectiongSt ring(), "GetFullUserName", arrSqlParam));
"Tampa .NET Koder" <Ta***********@discussions.microsoft.com> wrote in
message news:C3**********************************@microsof t.com...

ExecuteScalar returns a Object type..you should cast this object to a

string

like so:

strFullUserName = (string)
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
"GetFullUserName", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.ExecuteScalar ...

When I try to execute SqlHelper.ExecuteScalar I get this message:
"System.InvalidCastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
"GetFullUserName");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(), "GetFullUserName", arrSqlParam);

------------------------
CREATE PROCEDURE GetFullUserName
@strUserName nvarchar(50),
@strUserNameFull nvarchar(100) OUT
AS

SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
[tblUsers].[user_name] = @strUserName)
GO

[David Browne]

"Neven Klofutar" <neven.klofutar*r.e..mo*****@vip.hr> wrote in message
news:en**************@TK2MSFTNGP15.phx.gbl...

Hi,

I have a problem with SqlHelper.ExecuteScalar ...

Confusingly, ExecuteScalar is for commands which return result sets.
You want ExecuteNonQuery, and then examine the parameter.
David

[bruce barker]

you sp has no result set, so execute scaler is returning an error. execute
scalre returns the first column of the first result set. if there is no
result set, then its stuck.

change you proc to return the name in a result set, or use ExecuteNoQuery,
and get the value from the sp parameter (which must be declared an out in
your code to work).

-- bruce (sqlwork.com)
"Neven Klofutar" <neven.klofutar*r.e..mo*****@vip.hr> wrote in message
news:en**************@TK2MSFTNGP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.ExecuteScalar ...
|
| When I try to execute SqlHelper.ExecuteScalar I get this message:
| "System.InvalidCastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
| "GetFullUserName");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
| "GetFullUserName", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFull nvarchar(100) OUT
| AS
|
| SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
| [tblUsers].[user_name] = @strUserName)
| GO
|
|
|

[Neven Klofutar]

Uf ... Thanx I'll try this, I thought that Execute.Scalar returns a single
value, and that Execute.NoQuery is used when executing INSERT, DELETE or
UPDATE.

Neven
"bruce barker" <no***********@safeco.com> wrote in message
news:uS**************@TK2MSFTNGP11.phx.gbl...

you sp has no result set, so execute scaler is returning an error. execute
scalre returns the first column of the first result set. if there is no
result set, then its stuck.

change you proc to return the name in a result set, or use ExecuteNoQuery,
and get the value from the sp parameter (which must be declared an out in
your code to work).

-- bruce (sqlwork.com)
"Neven Klofutar" <neven.klofutar*r.e..mo*****@vip.hr> wrote in message
news:en**************@TK2MSFTNGP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.ExecuteScalar ...
|
| When I try to execute SqlHelper.ExecuteScalar I get this message:
| "System.InvalidCastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
| "GetFullUserName");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
| "GetFullUserName", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFull nvarchar(100) OUT
| AS
|
| SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
| [tblUsers].[user_name] = @strUserName)
| GO
|
|
|

[Neven Klofutar]

I just remembered and checked ... ExecuteNonQuery returns int ?

Neven
"bruce barker" <no***********@safeco.com> wrote in message
news:uS**************@TK2MSFTNGP11.phx.gbl...

you sp has no result set, so execute scaler is returning an error. execute
scalre returns the first column of the first result set. if there is no
result set, then its stuck.

change you proc to return the name in a result set, or use ExecuteNoQuery,
and get the value from the sp parameter (which must be declared an out in
your code to work).

-- bruce (sqlwork.com)
"Neven Klofutar" <neven.klofutar*r.e..mo*****@vip.hr> wrote in message
news:en**************@TK2MSFTNGP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.ExecuteScalar ...
|
| When I try to execute SqlHelper.ExecuteScalar I get this message:
| "System.InvalidCastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParameterCache.GetSpParameterSet(DB.getCo nnectiongString(),
| "GetFullUserName");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelper.ExecuteScalar(DB.getConnectiongS tring(),
| "GetFullUserName", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFull nvarchar(100) OUT
| AS
|
| SET @strUserNameFull = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
| [tblUsers].[user_name] = @strUserName)
| GO
|
|
|