«

Hello,

I have an ASP.NET page where I am grabbing an SqlDataReader and using it
to populate some controls on the form. Amongst the fields pulled out of
the table are two integer fields, which I am trying to cast as strings
so they can be displayed in a Literal control.

I am using the following code (heavily edited for clarity) ...

if (dtrDilemmas.Read()) {
litDilCurrentYesNo.Text = (String)dtrDilemmas["CurrentYes"] + "
votes yes and " + (String)dtrDilemmas["CurrentNo"] + " votes no";
}

where dtrDilemmas is the SqlDataReader that contains just one record. In
that record are two fields, CurrentYes and CurrentNo, which are both
integers. I have other (varchar) fields which I can use just fine. When
it hits the line shown above, I get the error "specified cast is not
valid".

Anyone any idea why not and how I fix it? TIA

--
Alan Silver
(anything added below this line is nothing to do with me)

Try

litDilCurrentYesNo.Text = ((int)dtrDilemmas
["CurrentYes"]).Tostring() + "votes yes and " + ((int)
dtrDilemmas["CurrentNo"]).Tostring() + " votes no";

HTH,

Elton Wang



>-----Original Message-----
>Hello,
>
>I have an ASP.NET page where I am grabbing an
SqlDataReader and using it
>to populate some controls on the form. Amongst the fields
pulled out of
>the table are two integer fields, which I am trying to
cast as strings
>so they can be displayed in a Literal control.
>
>I am using the following code (heavily edited for
clarity) ...
>
> if (dtrDilemmas.Read()) {
> litDilCurrentYesNo.Text = (String)dtrDilemmas
["CurrentYes"] + "
>votes yes and " + (String)dtrDilemmas["CurrentNo"] + "
votes no";
> }
>
>where dtrDilemmas is the SqlDataReader that contains just
one record. In
>that record are two fields, CurrentYes and CurrentNo,
which are both
>integers. I have other (varchar) fields which I can use
just fine. When
>it hits the line shown above, I get the error "specified
cast is not
>valid".
>
>Anyone any idea why not and how I fix it? TIA
>
>--
>Alan Silver
>(anything added below this line is nothing to do with me)
>.
>

You can't cast the object as a string because it isn't a string. However,
you can use the DataReader's methods to get the string out of it, such as
GetString(). Example:

litDilCurrentYesNo.Text =
dtrDilemmas.GetString(dtrDilemmas.GetOrdinal("Curr entYes")) ...

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Alan Silver" <alan-> wrote in message
news:...
> Hello,
>
> I have an ASP.NET page where I am grabbing an SqlDataReader and using it
> to populate some controls on the form. Amongst the fields pulled out of
> the table are two integer fields, which I am trying to cast as strings
> so they can be displayed in a Literal control.
>
> I am using the following code (heavily edited for clarity) ...
>
> if (dtrDilemmas.Read()) {
> litDilCurrentYesNo.Text = (String)dtrDilemmas["CurrentYes"] + "
> votes yes and " + (String)dtrDilemmas["CurrentNo"] + " votes no";
> }
>
> where dtrDilemmas is the SqlDataReader that contains just one record. In
> that record are two fields, CurrentYes and CurrentNo, which are both
> integers. I have other (varchar) fields which I can use just fine. When
> it hits the line shown above, I get the error "specified cast is not
> valid".
>
> Anyone any idea why not and how I fix it? TIA
>
> --
> Alan Silver
> (anything added below this line is nothing to do with me)

Thanks to both of you. It's obvious now, but it needed pointing out

>Try
>
>litDilCurrentYesNo.Text = ((int)dtrDilemmas
>["CurrentYes"]).Tostring() + "votes yes and " + ((int)
>dtrDilemmas["CurrentNo"]).Tostring() + " votes no";
>
>HTH,
>
>Elton Wang
>
>
>
>>-----Original Message-----
>>Hello,
>>
>>I have an ASP.NET page where I am grabbing an
>SqlDataReader and using it
>>to populate some controls on the form. Amongst the fields
>pulled out of
>>the table are two integer fields, which I am trying to
>cast as strings
>>so they can be displayed in a Literal control.
>>
>>I am using the following code (heavily edited for
>clarity) ...
>>
>> if (dtrDilemmas.Read()) {
>> litDilCurrentYesNo.Text = (String)dtrDilemmas
>["CurrentYes"] + "
>>votes yes and " + (String)dtrDilemmas["CurrentNo"] + "
>votes no";
>> }
>>
>>where dtrDilemmas is the SqlDataReader that contains just
>one record. In
>>that record are two fields, CurrentYes and CurrentNo,
>which are both
>>integers. I have other (varchar) fields which I can use
>just fine. When
>>it hits the line shown above, I get the error "specified
>cast is not
>>valid".
>>
>>Anyone any idea why not and how I fix it? TIA
>>
>>--
>>Alan Silver
>>(anything added below this line is nothing to do with me)
>>.
>>

--
Alan Silver
(anything added below this line is nothing to do with me)

Really, I thought you were able to downcast from Object to String since
string inherits from Object. Can you shed some light on this subject for the
benefit of all?

"Kevin Spencer" wrote:

> You can't cast the object as a string because it isn't a string. However,
> you can use the DataReader's methods to get the string out of it, such as
> GetString(). Example:
>
> litDilCurrentYesNo.Text =
> dtrDilemmas.GetString(dtrDilemmas.GetOrdinal("Curr entYes")) ...
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Neither a follower nor a lender be.
>
> "Alan Silver" <alan-> wrote in message
> news:...
> > Hello,
> >
> > I have an ASP.NET page where I am grabbing an SqlDataReader and using it
> > to populate some controls on the form. Amongst the fields pulled out of
> > the table are two integer fields, which I am trying to cast as strings
> > so they can be displayed in a Literal control.
> >
> > I am using the following code (heavily edited for clarity) ...
> >
> > if (dtrDilemmas.Read()) {
> > litDilCurrentYesNo.Text = (String)dtrDilemmas["CurrentYes"] + "
> > votes yes and " + (String)dtrDilemmas["CurrentNo"] + " votes no";
> > }
> >
> > where dtrDilemmas is the SqlDataReader that contains just one record. In
> > that record are two fields, CurrentYes and CurrentNo, which are both
> > integers. I have other (varchar) fields which I can use just fine. When
> > it hits the line shown above, I get the error "specified cast is not
> > valid".
> >
> > Anyone any idea why not and how I fix it? TIA
> >
> > --
> > Alan Silver
> > (anything added below this line is nothing to do with me)
>
>
>

You can cast anything to a string that IS a string. For example, if you use
object (generally not a good idea), you can store ANY kind of object in it.
So, let's say that the object contains a number. Could you cast it as a
string? No. You would have to Convert it to a string. This can be done using
the .ToString() method, or Convert.ToString().

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Tampa .NET Koder" <> wrote in
message news:0FEBDD3A-BDF9-42F1-8FA7-...
> Really, I thought you were able to downcast from Object to String since
> string inherits from Object. Can you shed some light on this subject for
> the
> benefit of all?
>
> "Kevin Spencer" wrote:
>
>> You can't cast the object as a string because it isn't a string. However,
>> you can use the DataReader's methods to get the string out of it, such as
>> GetString(). Example:
>>
>> litDilCurrentYesNo.Text =
>> dtrDilemmas.GetString(dtrDilemmas.GetOrdinal("Curr entYes")) ...
>>
>> --
>> HTH,
>>
>> Kevin Spencer
>> Microsoft MVP
>> ..Net Developer
>> Neither a follower nor a lender be.
>>
>> "Alan Silver" <alan-> wrote in message
>> news:...
>> > Hello,
>> >
>> > I have an ASP.NET page where I am grabbing an SqlDataReader and using
>> > it
>> > to populate some controls on the form. Amongst the fields pulled out of
>> > the table are two integer fields, which I am trying to cast as strings
>> > so they can be displayed in a Literal control.
>> >
>> > I am using the following code (heavily edited for clarity) ...
>> >
>> > if (dtrDilemmas.Read()) {
>> > litDilCurrentYesNo.Text = (String)dtrDilemmas["CurrentYes"] + "
>> > votes yes and " + (String)dtrDilemmas["CurrentNo"] + " votes no";
>> > }
>> >
>> > where dtrDilemmas is the SqlDataReader that contains just one record.
>> > In
>> > that record are two fields, CurrentYes and CurrentNo, which are both
>> > integers. I have other (varchar) fields which I can use just fine. When
>> > it hits the line shown above, I get the error "specified cast is not
>> > valid".
>> >
>> > Anyone any idea why not and how I fix it? TIA
>> >
>> > --
>> > Alan Silver
>> > (anything added below this line is nothing to do with me)
>>
>>
>>