How to convert/cast sqldbtype.int

[Amil]

Hi all,
When I call a stored procedure, one of the output parameter returns a
sqldbtype.integ er but when assigned to a C# int field/property I get this
error:

int myfield;
// say, parms[0] is the sql integer data
myfield = parms[0]; // creates the error.
Error 1 Cannot implicitly convert type 'System.Data.Sq lClient.SqlPara meter'
to 'int'

also, parms[0] is a nullable column in the database.

[John B]

Amil wrote:

Hi all,
When I call a stored procedure, one of the output parameter returns a
sqldbtype.integ er but when assigned to a C# int field/property I get this
error:

int myfield;
// say, parms[0] is the sql integer data
myfield = parms[0]; // creates the error.
Error 1 Cannot implicitly convert type 'System.Data.Sq lClient.SqlPara meter'
to 'int'

also, parms[0] is a nullable column in the database.

Im not sure if you have to use the .Value property of the parameter but
I think you do, so:

if(parms[0].Value != dbnull) //Whatever dbnull is called
{
myfield = (int)parms[0].Value;
}

JB

[Amil]

cool. i think adding the .Value made it work; thank for the null checking too.

"John B" wrote:

Amil wrote:

Hi all,
When I call a stored procedure, one of the output parameter returns a
sqldbtype.integ er but when assigned to a C# int field/property I get this
error:

int myfield;
// say, parms[0] is the sql integer data
myfield = parms[0]; // creates the error.
Error 1 Cannot implicitly convert type 'System.Data.Sq lClient.SqlPara meter'
to 'int'

also, parms[0] is a nullable column in the database.

Im not sure if you have to use the .Value property of the parameter but
I think you do, so:

if(parms[0].Value != dbnull) //Whatever dbnull is called
{
myfield = (int)parms[0].Value;
}

JB

[Ignacio Machin \( .NET/ C# MVP \)]

hi,

parms[0] is an instance of SqlParameter , of course you cannot cast it to
an int.
do this:
int i = Convert.ToInt32 ( parms[0].Value );
or
int i = (int) parms[0].Value ;
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Amil" <Am**@discussio ns.microsoft.co m> wrote in message
news:22******** *************** ***********@mic rosoft.com...

Hi all,
When I call a stored procedure, one of the output parameter returns a
sqldbtype.integ er but when assigned to a C# int field/property I get this
error:

int myfield;
// say, parms[0] is the sql integer data
myfield = parms[0]; // creates the error.
Error 1 Cannot implicitly convert type
'System.Data.Sq lClient.SqlPara meter'
to 'int'

also, parms[0] is a nullable column in the database.