how to get sql row into variables

[Thomas Henz]

Hi!

I'm trying to get a single data row (SELECT name,telnr FROM table WHERE
id=3) into a something so that I gain 2 variables with name and telnr
that I can print out or modify (locally not in the DB). What do I have
to do?

Thanks,

Tom

[Chris Jackson]

Use a SqlDataReader object, and then just use reader["fieldName"] to access
values.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
--
"Thomas Henz" <th***@t-online.de> wrote in message
news:bi*************@news.t-online.com...

Hi!

I'm trying to get a single data row (SELECT name,telnr FROM table WHERE
id=3) into a something so that I gain 2 variables with name and telnr
that I can print out or modify (locally not in the DB). What do I have
to do?

Thanks,

Tom