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("default.aspx");
    }
    else if (pIndex == 1)
    {            
        Response.Redirect("default-2.aspx");
    }
    else if (pIndex == 2)
    {          
            Response.Redirect("default-3.aspx");
        }
    }

i am getting error in this line

int pIndex = (int)dataTable.Rows[0][0];

try

int pIndex = int.Parse(dataTable.Rows[0][0].ToString());

now i get this exception

Input string was not in a correct format.

i need to store int not string can u please change the code for integer

thanks finito it works now thanks very much

nps your welcome please mark as solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.