Exectuting SQL Code From Program

I am an OLD programmer, basic, Pascal, c, FORTRAN, and haven't programmed for about 15 years.I am now taking on a challenge to develop a reporting tool for my Exchange 2007 group.I am currently stuck on snippet of code that returns the result of a simple SQL Query.I am using VS2008 and developing in VB.The database that the program will front end for is SQL 2005.All variables not explicitly declared are globally declared.[code]No matter how I try to recover the information, I have even executed it as a stored procedure; I get the wrong value returned.I believe that it is caused by the use of the .executeNonQuery() command as the results are either 0 or -1.Can anyone verify this for me and explain what I should be using to return the correct value (33) from the query.I am trying to return this value to terminate a loop that I will execute to fill a list of the exchange mailbox servers in a form to add new exchange servers.