DaniWeb Forum Index > Software Development > C#

C# RSS

Problem with sql reader

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2004

Posts: 573

Reputation: Dark_Omen is an unknown quantity at this point

Solved Threads: 5

Dark_Omen

Offline

Posting Pro

Problem with sql reader

May 26th, 2005

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:

Help with Code Tags

(Toggle Plain Text)

  
SqlDataReader existsRdr = new SqlDataReader();
existsRdr.Read();

Anyhelp would be great.
Thanks in advance.

•

Join Date: Dec 2004

Posts: 1,655

Reputation: tgreer is an unknown quantity at this point

Solved Threads: 35

tgreer

Offline

Made Her Cry

Re: Problem with sql reader

May 27th, 2005

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

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
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.
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.