Re: Large numbers in ADO.net
- From: "black ares" <matematicianu2003@xxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Thu, 23 Apr 2009 09:07:09 +0300
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:
