Problem with sql reader

Expand Post »

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:

(Toggle Plain Text)

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

Anyhelp would be great.
Thanks in advance.

Similar Threads

Problem with php and SQL in PHP
Problem Inserting into SQL database on server in ASP.NET
SQL Server 2000 Help in MS SQL
Problem with URL access to SQL Server 2000 db in RSS, Web Services and SOAP
problem with connection to sql server in ASP.NET

Dark_Omen

Reputation Points: 23

Solved Threads: 6

Posting Pro

Offline

573 posts
since Apr 2004

Permalink

May 27th, 2005

Re: Problem with sql reader

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

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.

tgreer

Team Colleague

Reputation Points: 227

Solved Threads: 37

Made Her Cry

Offline

1,697 posts
since Dec 2004

Permalink

May 28th, 2005

Re: Problem with sql reader

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

Dark_Omen

Reputation Points: 23

Solved Threads: 6

Posting Pro

Offline

573 posts
since Apr 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Modifying head tag of parent file.

Next Thread in C# Forum Timeline: Azman Help

DaniWeb Message

Cancel Changes

User Name
Password