Hello there!
Here is my problem, in the simplest scenario:
- an Access 2000 format database (created with Access 2003)
- a simple table that contains one single field defined as Number, Decimal,
18,2
- VS2005 standard, C#
- a data source / dataset that cotains that simple Access table
- a DataGridView, created by drag and drop, with all the helper objects
(adapter, navigator etc) that edits that simple table
- WinXPSP2 with ***Regional Options in Control Panel set to
Romanian*** , with no other customization
And here's the problem: what magic do I have to do to enter decimal numbers
in that grid and save them in the database? Because as long as I type in
1,23 (given that the decimal separator in Romanian Regional Options is the
comma), the grid displays it correctly, I can save it to the daabase, but
when I reload the data by reopening the form, my number is 123 (and it
really IS 123 in the database!).
Thanks in advance.
pax 2 6362
Here are some other details:
- The database is local, it resides on the computer that the app is running
on.
- I first encountered this problem on user's computer, then I was able to
reproduce it on my machine by changing the regional settings to Romanian.
- I upgraded the database to the 2003 format, the problem persists. So it's
not that.
- I used some other control to edit the data, i.e. a simple textbox, still
the same, so it's not datagridview's fault.
- I created the same dummy table on SQL, then used another dataset, the
problem's gone, so it is related somehow to Access!
- used the:
Thread.CurrentT hread.CurrentCu lture = new CultureInfo("ro-RO");
Thread.CurrentT hread.CurrentUI Culture = new CultureInfo("ro-RO");
(and also with 'false' as a second parameter, useUserOverride ), of no
avail. The funny thing here is that on a machine with EN-US regional
settings and the above two lines in place, everything works fine!
- tried to set the Locale Identifier property on the connectionstrin g to
1048 (RO), no news.
So that's pretty much it, I'm out of any ideas...
Any help much appreciated.
Thanks a lot.
Pax
"pax" <pa*@noname.com wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
>
Hello there!
Here is my problem, in the simplest scenario:
- an Access 2000 format database (created with Access 2003)
- a simple table that contains one single field defined as Number,
Decimal,
18,2
- VS2005 standard, C#
- a data source / dataset that cotains that simple Access table
- a DataGridView, created by drag and drop, with all the helper objects
(adapter, navigator etc) that edits that simple table
- WinXPSP2 with ***Regional Options in Control Panel set to
Romanian*** , with no other customization
And here's the problem: what magic do I have to do to enter decimal
numbers
in that grid and save them in the database? Because as long as I type in
1,23 (given that the decimal separator in Romanian Regional Options is the
comma), the grid displays it correctly, I can save it to the daabase, but
when I reload the data by reopening the form, my number is 123 (and it
really IS 123 in the database!).
Thanks in advance.
pax
"pax" <pa*@noname.com wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
>
Hello there!
Here is my problem, in the simplest scenario:
- an Access 2000 format database (created with Access 2003)
- a simple table that contains one single field defined as Number,
Decimal,
18,2
- VS2005 standard, C#
- a data source / dataset that cotains that simple Access table
- a DataGridView, created by drag and drop, with all the helper objects
(adapter, navigator etc) that edits that simple table
- WinXPSP2 with ***Regional Options in Control Panel set to
Romanian*** , with no other customization
And here's the problem: what magic do I have to do to enter decimal
numbers
in that grid and save them in the database? Because as long as I type in
1,23 (given that the decimal separator in Romanian Regional Options is the
comma), the grid displays it correctly, I can save it to the daabase, but
when I reload the data by reopening the form, my number is 123 (and it
really IS 123 in the database!).
Thanks in advance.
pax This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ordz |
last post by:
I want to write a program that will take a decimal with up to 4 places
and convert it to 1/16 ths. I can sort of do that with:
n = 375 * 16 / 1000
Print n; "/16"
I am planning to use an input box to enter the number with no decimal
point.
But I don't know how to get a count of the digits in the denominator.
I will also round off any results that have a decimal place. I need
|
by: Mihajlo Canic |
last post by:
I have a very strange problem. Im working with MS Access db and oledb objects
(oledbadapter, oledbcommand, oledbconnection). Im using local cultureinfo
with "," as decimal separator, which is also set in regional settings of
machine. I have generated typed dataset based on one table with some decimal
fields. Everything works fine until I try to update database decimal column
with value from field, when my decimal comma is ignored (in db is...
|
by: Jean-Marc Blaise |
last post by:
Dear all,
In a version 7 Workgroup Edition FP6 on Windows, a values decimal('7.5',9,2)
is correctly displayed as '7.5'. Applying FP10 or FP11 displays as '7,5' in
the output grid of command center.
Server settings are:
For W2K French, Regional settings=France, Decimal separators is '.'.
For DB, codepage 1252, country 33.
The pb is on version 8, I cannot get a '7.5' displayed in the command
|
by: T.K Kullervo |
last post by:
Hi, is there someway to change the regional settings--> numbers--> decimal
separator for the the program im creating. I dont want to change it
permanently but my program doesnt work if the separator is a comma.
|
by: aa |
last post by:
when I ourput data from Access, numbers bigger than 999 are shown with
letter "B" inserted into the 4th position left to the coma. (in my w2k
regional settings I have the decimal dot separator set to "." and digit
group separater set to nothing. In Access the number are shown with "." as
decimal separator, but for some reason ASP used "," instead)
Say, 3000,00 is shown as 3B 000,00
Why and how do I sort this out?
| |
by: DustWolf |
last post by:
Hello,
I am wondering, what is the standard for including decimal numbers in
XML code? What determines what is the decimal delimiter and what can
be the grouping symbol?
I have just realized that Microsoft's parser decides that based on the
regional settings, invalidating most numbers sent in XML
internationally. Is this a bug or is it correct behaviour, based on
infsufficient information?
|
by: =?Utf-8?B?T2xpdmllciBHSUw=?= |
last post by:
Hello,
I try to convert a volume stored as a string value in an XML file into a
Decimal object. The volume is stored with comma as decimal separator
("210,12") according to french habits. To be independent from the culture of
the current user, I use
decimal.Parse(volume, new System.Globalization.CultureInfo("fr-FR", true));
but this function fails with :
Exception : Input string was not in a correct format.
|
by: pax |
last post by:
Hello there!
Here is my problem, in the simplest scenario:
- an Access 2000 format database (created with Access 2003)
- a simple table that contains one single field defined as Number, Decimal,
18,2
- VS2005 standard, C#
- a data source / dataset that cotains that simple Access table
- a DataGridView, created by drag and drop, with all the helper objects
(adapter, navigator etc) that edits that simple table
|
by: avcitamer |
last post by:
We upgraded our system and problem below occured, pleas help me...
Windows 2003 server SP1
When I set a decimal DB field value to "123,32" (using
ADODB.recordset ) updated value was ok (123.32)
Windows 2003 server SP2
Now when I set a decimal DB field value to "123,32" (using
ADODB.recordset ) updated value is (123.32)
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |