Cannot implicitly convert type

[Christoph Boget]

I am getting an error (a few among many) for the
following lines of code:

retval[curRowNum].BrokerName = (( curRow["BrokerName "] ==
System.DBNull.V alue ) ? SqlString.Null : (string)curRow["BrokerName "] );

retval[curRowNum].BrokerGroupId = (( curRow["BrokerGrou pId"] ==
System.DBNull.V alue ) ? SqlInt32.Null : (int)curRow["BrokerGrou pId"] );

The errors are (in turn):

"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlStrin g' to
'string'"
"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlInt32 ' to 'int'"

So I'm curious, where is it getting the idea that I am
*implicitly* tyring to convert the type? When it is very
apparent that I am *explicitly* trying to convert it. I've
done some searches on Google but couldn't come up
with an appropriate answer. I'm hoping you'll be able
to tell me what's going on.

thnx,
Christoph

[Telmo Sampaio]

Christopher,

What are the defined data types of BrokerName and BrokerId?

Telmo Sampaio

"Christoph Boget" <jc*****@yahoo. com> wrote in message
news:eb******** ******@TK2MSFTN GP09.phx.gbl...

I am getting an error (a few among many) for the
following lines of code:

retval[curRowNum].BrokerName = (( curRow["BrokerName "] ==
System.DBNull.V alue ) ? SqlString.Null : (string)curRow["BrokerName "] );

retval[curRowNum].BrokerGroupId = (( curRow["BrokerGrou pId"] ==
System.DBNull.V alue ) ? SqlInt32.Null : (int)curRow["BrokerGrou pId"] );

The errors are (in turn):

"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlStrin g' to
'string'"
"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlInt32 ' to 'int'"

So I'm curious, where is it getting the idea that I am
*implicitly* tyring to convert the type? When it is very
apparent that I am *explicitly* trying to convert it. I've
done some searches on Google but couldn't come up
with an appropriate answer. I'm hoping you'll be able
to tell me what's going on.

thnx,
Christoph

[Jon Skeet [C# MVP]]

Christoph Boget <jc*****@yahoo. com> wrote:

I am getting an error (a few among many) for the
following lines of code:

retval[curRowNum].BrokerName = (( curRow["BrokerName "] ==
System.DBNull.V alue ) ? SqlString.Null : (string)curRow["BrokerName "] );

retval[curRowNum].BrokerGroupId = (( curRow["BrokerGrou pId"] ==
System.DBNull.V alue ) ? SqlInt32.Null : (int)curRow["BrokerGrou pId"] );

The errors are (in turn):

"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlStrin g' to
'string'"
"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlInt32 ' to 'int'"

So I'm curious, where is it getting the idea that I am
*implicitly* tyring to convert the type? When it is very
apparent that I am *explicitly* trying to convert it. I've
done some searches on Google but couldn't come up
with an appropriate answer. I'm hoping you'll be able
to tell me what's going on.

I suspect that BrokerName is a string property - in which case, if the
condition is true, it's as if you're saying:

retval[curRowNum].BrokerName = SqlString.Null;

The only things you're *explicitly* converting are from object (as far
as the compiler knows) to string/int.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Christoph Boget]

> What are the defined data types of BrokerName and BrokerId?

'string' and 'int', respecitvely.

Christoph

[Christoph Boget]

> I suspect that BrokerName is a string property

It is.

- in which case, if the condition is true, it's as if you're saying:
retval[curRowNum].BrokerName = SqlString.Null;
I didn't think there would be an issue with setting a string property
to null. Or any data type to null. Is that not the case?
The only things you're *explicitly* converting are from object (as far
as the compiler knows) to string/int.

And 'String.Null' is an object? Not a data type?

thnx,
Christoph

[Jon Skeet [C# MVP]]

Christoph Boget <jc*****@yahoo. com> wrote:

I suspect that BrokerName is a string property

It is.

- in which case, if the condition is true, it's as if you're saying:
retval[curRowNum].BrokerName = SqlString.Null;

I didn't think there would be an issue with setting a string property
to null. Or any data type to null. Is that not the case?

SqlString.Null is of type SqlString, not string, and it's not the same
as a null reference.

The only things you're *explicitly* converting are from object (as far
as the compiler knows) to string/int.

And 'String.Null' is an object? Not a data type?

SqlString.Null is a reference to a particular instance of SqlString.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Christoph Boget]

> The only things you're *explicitly* converting are from object (as far

as the compiler knows) to string/int.

I've tried changing the code to this:

_brokerGroupId = toReturn.Rows[0]["BrokerGrou pId"] == System.DBNull.V alue ?
null : (int)toReturn.R ows[0]["BrokerGrou pId"];

so it's not converting from an object (presumably SqlInt32.Null?) but now
I'm getting the error:

"Type of conditional expression can't be determined because there is no
implicit
conversion between '<null>' and 'int'"

I just am not understanding this. Why is there an issue setting a data type
to
null? There shouldn't be one...

thnx,
Christoph

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

Hi,
In addition to Jon comments you also have the problem that the terniary
operator return a different type in the true and false statement, this is
not valid and you have to solve it. Maybe that is the "implicitin ess"

It's an error any way :)

cheers,

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

"Jon Skeet [C# MVP]" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@msnews.micros oft.com...

Christoph Boget <jc*****@yahoo. com> wrote:

I am getting an error (a few among many) for the
following lines of code:

retval[curRowNum].BrokerName = (( curRow["BrokerName "] ==
System.DBNull.V alue ) ? SqlString.Null : (string)curRow["BrokerName "] );

retval[curRowNum].BrokerGroupId = (( curRow["BrokerGrou pId"] ==
System.DBNull.V alue ) ? SqlInt32.Null : (int)curRow["BrokerGrou pId"] );

The errors are (in turn):

"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlStrin g' to
'string'"
"Cannot implicitly convert type 'System.Data.Sq lTypes.SqlInt32 ' to 'int'"
So I'm curious, where is it getting the idea that I am
*implicitly* tyring to convert the type? When it is very
apparent that I am *explicitly* trying to convert it. I've
done some searches on Google but couldn't come up
with an appropriate answer. I'm hoping you'll be able
to tell me what's going on.

I suspect that BrokerName is a string property - in which case, if the
condition is true, it's as if you're saying:

retval[curRowNum].BrokerName = SqlString.Null;

The only things you're *explicitly* converting are from object (as far
as the compiler knows) to string/int.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Telmo Sampaio]

so... that answer your question...

"Christoph Boget" <jc*****@yahoo. com> wrote in message
news:u7******** ******@TK2MSFTN GP11.phx.gbl...

What are the defined data types of BrokerName and BrokerId?

'string' and 'int', respecitvely.

Christoph

[Kyril Magnos]

Try this...

_brokerGroupId = (!toReturn.Rows[0].IsNull("Broker GroupId") ?
(int)toReturn.R ows[0]["BrokerGrou pId"] : -1);

There is no implicit conversion between null and int.

HTH,

Kyril

"Christoph Boget" <jc*****@yahoo. com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

The only things you're *explicitly* converting are from object (as far
as the compiler knows) to string/int.

I've tried changing the code to this:

_brokerGroupId = toReturn.Rows[0]["BrokerGrou pId"] == System.DBNull.V alue
?
null : (int)toReturn.R ows[0]["BrokerGrou pId"];

so it's not converting from an object (presumably SqlInt32.Null?) but now
I'm getting the error:

"Type of conditional expression can't be determined because there is no
implicit
conversion between '<null>' and 'int'"

I just am not understanding this. Why is there an issue setting a data
type
to
null? There shouldn't be one...

thnx,
Christoph