Cannot Convert Type

Error Message:

Quote:

---

DatabaseClass.cs(102,12): error CS0029: Cannot implicitly convert type 'System.Data.DataSet' to 'System.Data.SqlClient.SqlDataReader'

---

Code:

---

public DataSet db_query(string SqlStatement, bool isStoredProc)
        {
                DataSet dSet = new DataSet();

                try
                {
                        if(SqlStatement == "")
                        {
                                MessageBox.Show("SQL Statment is empty.");
                        }
                       
                        if(isStoredProc == true)
                        {
                                String strQuery = "EXEC " + SqlStatement.Trim();
                                SqlDataAdapter sAdapter = new SqlDataAdapter(strQuery,myConnection);
                                sAdapter.Fill(dSet,SqlStatement);
                        }
                        else
                        {
                                string strQuery = SqlStatement.Trim();
                                SqlDataAdapter sAdapter = new SqlDataAdapter(strQuery,myConnection);
                                sAdapter.Fill(dSet,SqlStatement);
                        }
                }
                catch(Exception exp)
                {
                        MessageBox.Show("Error fetching records for the query:- " + SqlStatement + ". Possible cause:- " + exp.ToString() );
                }       
                               
                return(dSet);
        }

public static void Main()
        {
                string myConnectionString = ("server=localhost;database=pubs;user id=steve;password=jensen;");
                Database myDB = new Database();
                SqlDataReader reader;
               
               
                db_open(myConnectionString);
                reader = myDB.db_query("SELECT * FROM authors", false);
               
                while(reader.Read())
          {
                  Console.WriteLine(reader["au_lname"]);
          }
               
                db_close();
        }

---

Obviously the issue is in reader = myDB.db_query, since db_query returns a DataSet and I am trying to read the returned DataSet with the SqlReader...Any ideas on how to do this???

Why would you want to do that? If you are going to read the data with a datareader might as well just return a datareader object.

Why not this:

Code:

---

public static void Main()       
{
        string myConnectionString = ("server=localhost;database=pubs;user id=steve;password=jensen;");
        Database myDB = new Database();
        DataSet myDS = new DataSet();
               
               
        db_open(myConnectionString);
        myDS = myDB.db_query("SELECT * FROM authors", false);
        foreach(DataRow dr in myDS.Tables(0).Rows)
        {
              Console.WriteLine(dr["au_lname"]);
        }
               
        db_close();
}

---

instead of "public DataSet db_query", I just changed it to public "SqlReader db_query"...that way I am not running into the conversion issue...everything seems to be working properly now...It opens the connection, queries the database, returns the records, and closes the connection.