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.