I keep getting an invalid cast exception when trying to retrieve data from an AutoNumber field in Access. Here is what I have:
My problem is occuring on this line:
I have the AutoNumber column setup as a Long Integer in Access. Is there something about the AutoNumber type that I need to know to be able to use a DataReader on it?
Thanks,
Brad
Code:
private int GetSessionNumber()
{
//Check database connection. If closed, open it
if (aLib.SQLConnection.State==System.Data.ConnectionState.Closed)
aLib.SQLConnection.Open();
string sql = "SELECT MAX(Session_ID) As S FROM User_Tests " +
"WHERE Test_ID = '" + testID + "' AND User_ID = '" + taker.UserID + "'";
OleDbCommand getSession = new OleDbCommand(sql,aLib.SQLConnection);
OleDbDataReader sessionReader = getSession.ExecuteReader();
sessionReader.Read();
int session = sessionReader.GetInt32(0); //Invalid Cast
MessageBox.Show(Convert.ToString(session));
sessionReader.Close();
return(session);
}
My problem is occuring on this line:
Code:
sessionReader.GetInt32(0); //Invalid Cast
I have the AutoNumber column setup as a Long Integer in Access. Is there something about the AutoNumber type that I need to know to be able to use a DataReader on it?
Thanks,
Brad