Re: Large numbers in ADO.net

so, read the access version documentation and look for how many bytes or bits 
does it use for a long integer.
I guess that long integer for it is 32 bits (like pascal and C)
So maibe you would like to use another data type.
Regarding to the reason you are using a number field, isn't it better to use a 
timestamp field?
and let the dbms to do the work?

  ----- Original Message ----- 
  From: Sean Mealin 
  To: programmingblind@xxxxxxxxxxxxx 
  Sent: Thursday, April 23, 2009 7:08 AM
  Subject: 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: