Problem with sql reader

[Dark_Omen]

Ok, I am trying to read data back from a database, when I build my program it throws an error saying: "No overload for method 'SqlDataReader' takes '0' arguments."

Here is the code from the program:

SqlDataReader existsRdr = <strong>new SqlDataReader</strong>();
existsRdr.<strong>Read</strong>();

Anyhelp would be great.
Thanks in advance.

[tgreer]

You return a SqlDataReader as the result of the .ExecuteReader() method of the Command object:

SqlConnection myConnection = new SqlConnection(myConnectionString);
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
 myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read()) 
{
    Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
//Implicitly closes the connection because CommandBehavior.CloseConnection was specified.

[Dark_Omen]

Oh, I see. Thanks for the help with that.