Large numbers in ADO.net

Hi all,

I'm having a problem with ADO.net that I just can't seem to figure out.  In
a nutshell, the problem is that I'm trying to write a number that is to big
in a database, but I'm not sure how to fix it.  The number I'm trying to
write is the number of seconds since Jan 1, 1970, so my code looks like
this:

 

Newrow["Update_Time"] = 12345678910;

 

The "Update_Time" is set to a number in the database, and that field size is
set to long integer.  So the whole part of code looks like:

 

DataRow NewRow = MyTable.NewRow();

NewRow["Update_Time"]=12345678910;

NewRow["Update_Name"]="Sean";

MyOLEDBAdapter.Update(MyTable);

 

And I get the error:

Can not convert int64 to int32.

The stacktrace points at the line:

MyOLEDBAdapter.Update(MyTable);

 

I guess I should also say that I'm using an OLEDBCommandBuilder to help with
the OLEDBAdapter object.

 

If I need to give more information, please let me know.  Oh, also the type
of database is an Access file.

 

Thanks so much for any ideas!

 

Sean Mealin

Other related posts: