Storing Number in an integer from sql Database
- by ar31an
i am using database with table RESUME and column PageIndex in it which type is number in database but when i want to store this PageIndex value to an integer i get exception error
Specified cast is not valid.
here is the code
string sql;
string conString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=D:\\Deliverable4.accdb";
protected OleDbConnection rMSConnection;
protected OleDbDataAdapter rMSDataAdapter;
protected DataSet dataSet;
protected DataTable dataTable;
protected DataRow dataRow;
on Button Click
sql = "select PageIndex from RESUME";
rMSConnection = new OleDbConnection(conString);
rMSDataAdapter = new OleDbDataAdapter(sql, rMSConnection);
dataSet = new DataSet("pInDex");
rMSDataAdapter.Fill(dataSet, "RESUME");
dataTable = dataSet.Tables["RESUME"];
int pIndex =
(int)dataTable.Rows[0][0];
rMSConnection.Close();
if (pIndex == 0)
{
Response.Redirect("Create Resume-1.aspx");
}
else if (pIndex == 1)
{
Response.Redirect("Create Resume-2.aspx");
}
else if (pIndex == 2)
{
Response.Redirect("Create Resume-3.aspx");
}
}
i am getting error in this line
int pIndex = (int)dataTable.Rows[0][0];
