Bonnie,
This is exactly the syntax I tried but I got compilor error. The error say something like "cannot cast string to integer" which is what the (int) syntax is for. But there has to be a way, I think.
Thank you.
>Dmitry,
>
>
>I haven't used a DataReader, so I'm not 100% sure, but I wouldn't imagine it would be any different than anything else. Try leaving off the ToString() and casting it to int:
>
>
>int MyField = (int)drMyTable["fld_name"];
>
>
>~~Bonnie
>
>
>>I was wondering, how do you get an int type field from a data reader.
>>
>>For example, I can get a string type field (or int type) from a data reader (e.g. drMyTable) as a string:
>>
>>
>>string MyField = drMyTable["fld_name"].ToString();
>>
>>
>>But if the field "fld_name" is INT, do I have to still get it as a string and then convert to INT? Is there a way to do it right from the dr?
>>
>>TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham