472,353 Members | 1,150 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Changing decimal simbol in a dataset


I'm showing decimal values in a datagrid, but the decimal point shown is
the "," and the correct is the ".". The datagrid is filled with a
dataset, the dataset is filled with a SQL Server 2000 store procedure.

I'm running the client on the same machine of the database server and
the application server, on this machine it's regional configuration on
the control panel, the decimal simbol it's the "."...

so... how can I fix this? should I format on VB each column, each row of
the dataset?

Thanks for any suggestion!

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #1
1 1454

The best is using the right setting of your OS in the culture it has to be,
when not you can maybe try one of this ones:

\\\set culture
Dim myCIintl As New System.Globalization.CultureInfo("nl-NL")
Application.CurrentCulture = myCIintl
Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")

Know that it makes your application culture dependend.

I hope this helps?

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

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...
by: John Smith | last post by:
Hey folks, I've got a combobox (DropDown List) in a windows form application which is bound to a DataSet. It's value is set to a numeric ID. ...
by: Alberto | last post by:
How can I find out witch is the decimal separator in a particular configuration of a operative system? Thank you
by: Luis Esteban Valencia | last post by:
Hello. I have a datagrid with one row. I have a button that adds a new row. I am trying to implement that when the user selects one product it must...
by: Dan Sikorsky | last post by:
How do you iterate thru a dataset to change money fields to a different value? Here's what I have. My dataset is filled directly from a stored...
by: Les Hughes | last post by:
Hey guys (and gals!), I have a dataset brought back from sqsl server, where some of the columns are already rounded within the dataset (retrieved...
by: Andrés Giraldo | last post by:
Hi! I'm showing decimal values in a datagrid, but the decimal point shown is the "," and the correct is the ".". The datagrid is filled with a...
by: =?Utf-8?B?cGF0cmlja2RyZA==?= | last post by:
Hi everyone! I'm using greece - greek in my control panel's regional options, and so, my decimal point is the comma (,), while it is the dot (.)...
by: muaddubby | last post by:
Hi I'm running into a scenario with a DataSet that has a schema loaded into it, tries to then load data (that matches the schema), and fails with...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.