The following code doesn't retrieve the rows infact there are rows present in that. Can anyone help me out with this.
Ur help will be appreciated.

VB Code:
  1. OleDbConnection conn = new OleDbConnection(pathinfo);
  2.     String SQL,dr;
  3.     void Page_Load()
  4.     {
  5.         Page.DataBind();
  6.         SQL="Select Sum(Poamount) as amount from stats where Buyer='Brad' group by Poamount";
  7.         dbCommand1 = new OleDbCommand(SQL,conn);
  8.         conn.Open();
  9.         OleDbDataReader dataRead = dbCommand1.ExecuteReader();
  10.         dr = dataRead.GetString(dataRead.GetOrdinal("amount"));
  11. //      dr = dataRead.GetInt32(0);
  12.         dataRead.Close();
  13.         conn.Close();
  14.     }

The error says there are no rows/columns.

Thanks a lot