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:
OleDbConnection conn = new OleDbConnection(pathinfo); String SQL,dr; void Page_Load() { Page.DataBind(); SQL="Select Sum(Poamount) as amount from stats where Buyer='Brad' group by Poamount"; dbCommand1 = new OleDbCommand(SQL,conn); conn.Open(); OleDbDataReader dataRead = dbCommand1.ExecuteReader(); dr = dataRead.GetString(dataRead.GetOrdinal("amount")); // dr = dataRead.GetInt32(0); dataRead.Close(); conn.Close(); }
The error says there are no rows/columns.
Thanks a lot




Reply With Quote