SqlHelper.Execu teScalar

[Neven Klofutar]

Hi,

I have a problem with SqlHelper.Execu teScalar ...

When I try to execute SqlHelper.Execu teScalar I get this message:
"System.Invalid CastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
"GetFullUserNam e");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
"GetFullUserNam e", arrSqlParam);

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

SET @strUserNameFul l = (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.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
"GetFullUserNam e", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.Execu teScalar ...

When I try to execute SqlHelper.Execu teScalar I get this message:
"System.Invalid CastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
"GetFullUserNam e");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
"GetFullUserNam e", arrSqlParam);

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

SET @strUserNameFul l = (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.ToStrin g(Utility.SqlHe lper.ExecuteSca lar(Utility.DB. getConnectiongS t
ring(), "GetFullUserNam e", arrSqlParam));
"Tampa .NET Koder" <Ta***********@ discussions.mic rosoft.com> wrote in
message news:C3******** *************** ***********@mic rosoft.com...

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

strFullUserName = (string)
Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
"GetFullUserNam e", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.Execu teScalar ...

When I try to execute SqlHelper.Execu teScalar I get this message:
"System.Invalid CastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
"GetFullUserNam e");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(), "GetFullUserNam e", arrSqlParam);

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

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

[Neven Klofutar]

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

Neven

strFullUserName =
Convert.ToStrin g(Utility.SqlHe lper.ExecuteSca lar(Utility.DB. getConnectiongS t ring(), "GetFullUserNam e", arrSqlParam));
"Tampa .NET Koder" <Ta***********@ discussions.mic rosoft.com> wrote in
message news:C3******** *************** ***********@mic rosoft.com...

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

string

like so:

strFullUserName = (string)
Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
"GetFullUserNam e", arrSqlParam);

"Neven Klofutar" wrote:

Hi,

I have a problem with SqlHelper.Execu teScalar ...

When I try to execute SqlHelper.Execu teScalar I get this message:
"System.Invalid CastException: Object must implement IConvertible.".

Help ...

Thanx, Neven

----------------------
SqlParameter[] arrSqlParam = null;
arrSqlParam =
SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
"GetFullUserNam e");
arrSqlParam[0].Value = strUserName;

strFullUserName = Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(), "GetFullUserNam e", arrSqlParam);

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

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

[David Browne]

"Neven Klofutar" <neven.klofutar *r.e..mo*****@v ip.hr> wrote in message
news:en******** ******@TK2MSFTN GP15.phx.gbl...

Hi,

I have a problem with SqlHelper.Execu teScalar ...

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*****@v ip.hr> wrote in message
news:en******** ******@TK2MSFTN GP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.Execu teScalar ...
|
| When I try to execute SqlHelper.Execu teScalar I get this message:
| "System.Invalid CastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
| "GetFullUserNam e");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
| "GetFullUserNam e", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFul l nvarchar(100) OUT
| AS
|
| SET @strUserNameFul l = (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******** ******@TK2MSFTN GP11.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*****@v ip.hr> wrote in message
news:en******** ******@TK2MSFTN GP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.Execu teScalar ...
|
| When I try to execute SqlHelper.Execu teScalar I get this message:
| "System.Invalid CastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
| "GetFullUserNam e");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
| "GetFullUserNam e", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFul l nvarchar(100) OUT
| AS
|
| SET @strUserNameFul l = (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******** ******@TK2MSFTN GP11.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*****@v ip.hr> wrote in message
news:en******** ******@TK2MSFTN GP15.phx.gbl...
| Hi,
|
| I have a problem with SqlHelper.Execu teScalar ...
|
| When I try to execute SqlHelper.Execu teScalar I get this message:
| "System.Invalid CastException: Object must implement IConvertible.".
|
| Help ...
|
| Thanx, Neven
|
| ----------------------
| SqlParameter[] arrSqlParam = null;
| arrSqlParam =
| SqlHelperParame terCache.GetSpP arameterSet(DB. getConnectiongS tring(),
| "GetFullUserNam e");
| arrSqlParam[0].Value = strUserName;
|
| strFullUserName =
Utility.SqlHelp er.ExecuteScala r(DB.getConnect iongString(),
| "GetFullUserNam e", arrSqlParam);
|
| ------------------------
| CREATE PROCEDURE GetFullUserName
| @strUserName nvarchar(50),
| @strUserNameFul l nvarchar(100) OUT
| AS
|
| SET @strUserNameFul l = (SELECT ime + ' ' + prezime FROM tblUsers WHERE
| [tblUsers].[user_name] = @strUserName)
| GO
|
|
|