Storing Number in an integer from sql Database
Posted
by ar31an
on Stack Overflow
See other posts from Stack Overflow
or by ar31an
Published on 2010-06-14T17:17:00Z
Indexed on
2010/06/14
17:22 UTC
Read the original article
Hit count: 171
c#
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];
© Stack Overflow or respective owner