Sql results to string

[tchavez]

Anyone know how to get a sql result into a string?

Such as: "Select admin From access Where (usrs = "me")"

admin has either the value y or f which needs to be evaluated in an IF statement. To determine if the user has access to the page.

 

[jmcilhinney]

To get a single value using ADO.NET you should create an SqlCommand object and call ExecuteScalar.

 

[tchavez]

Sorry I figued out a way to do it.