DataReader empty

[watherton]

ok i have this slight problem that is beginning to wear me down.

I have a method that calls a class, which is supposed to return the method a datareader object. When the class returns to the method though the datareader is empty.

here is the code:

public SqlDataReader AuthenticateUser()
{


SqlDataReader dataReader = null;
Classes.Connection conn = new Connection();

SqlParameter[] prams =
{
conn.MakeInParam("@Username",SqlDbType.Char,10,str Username),
conn.MakeInParam("@Password",SqlDbType.Char,10,str Password),
conn.MakeOutParam("@UserID",SqlDbType.Int,4),
conn.MakeOutParam("@bSuccess",SqlDbType.Bit,1),
conn.MakeOutParam("@dLastLogon",SqlDbType.DateTime ,8)
};

conn.RunProc("sp_CheckLogon",prams, out dataReader)

return datareader

here is the calling method

public void RunProc(string procName, SqlParameter[] prams, out SqlDataReader dataReader)
{
SqlCommand objCMD = CreateCommand(procName, prams);
dataReader = objCMD.ExecuteReader();
}


the orignal code was taken from this website ('http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=3) if that helps.

what i need to happen is access the elements with the datareader and populate my local variables etc, but everytime i create a reader.read() object it just ends up in a continous loop because the datareader is empty.

If i have not made myself clear then please say so - any help would be a massive help.

Cheers

Wayne

[sde]

what type of database are you trying to read?

can you also show the code you are trying to read with? your reader is named 'dataReader' , so your loop should be dataReader.Read();

public void RunProc(string procName, SqlParameter[] prams, out SqlDataReader dataReader)
{
  SqlCommand objCMD = CreateCommand(procName, prams);
  dataReader = objCMD.ExecuteReader();

  // your loop should be something like this i think
  while(dataReader.Read())
  {

  }
}

[watherton]

Sql 2000

[sde]

i think it would be easier for you to use this approach:

using System;
using System.Data.SqlClient;

public class Test
{
  public static void Main()
  {
    Test t=new Test();
    t.Run();
  }
  
  public void Run()
  {
    SqlConnection conn = new SqlConnection("Data Source=localhost; Integrated Security=SSPI; Initial Catalog=pubs");
    SqlCommand  cmd = new SqlCommand("SELECT * FROM emp_test", conn);
    try
    {    	
      conn.Open();
      
      SqlDataReader myReader = cmd.ExecuteReader();
      Console.WriteLine("Code \t Emp. Name \t Emp. Phone");
      Console.WriteLine("-----------------------------------------");
      while (myReader.Read())
      {
        Console.WriteLine("{0}\t{1}\t\t{2}", myReader.GetInt32(0), myReader.GetString(1), myReader.GetString(2));
      }
    		
      myReader.Close();
      conn.Close();
    }
    catch(Exception e)
    {
      Console.WriteLine("Exception Occured -->> {0}",e);
    }    	
  }
}