Reading a single field from table

[John]

Hi

I need to run a simple select query like below;

select field1 from mytable where id = 123

and assign the returned value of field1 to a variable. What is an easy way
to do this?

Thanks

Regards

[Miha Markic [MVP C#]]

DbCommand.ExecuteScalar

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John" <Jo**@nospam.infovis.co.ukwrote in message
news:us**************@TK2MSFTNGP02.phx.gbl...

Hi

I need to run a simple select query like below;

select field1 from mytable where id = 123

and assign the returned value of field1 to a variable. What is an easy way
to do this?

Thanks

Regards