tags:

views:

19

answers:

2
Q: 

how to retain exact numbers that come from Access Database

MY scenario is... I have 6,000 datas in Excel Sheet.. I try to import to Access Database.It enters the Database like this..

UNit Price 34512.00 Vat 4.00

BUt when i Retrieve to DataGridColumn it Shows vat Rate as 4(whole number).I accept zeros has no values..But I need that to be displayed in Grid as 4.0 . How to achieve this

A: 

I'm quite confused about the combination of tags c and datagridview, but I'm going to assume by the second tag you mean .NET WinForms DataGridView. In which case, you'll want to play with the Format property of the DataGridViewColumn to force it to show decimal places.

lc  2010-05-27 06:45:40
for (i = 0; i < dt.Rows.Count; i++){ dvgproductlist.Rows[i].Cells[7].Value = dt.Rows[i]["UnitPrice"].ToString();}This how i retrieve values from access Database to gridview..How can enable here the Format PROPERTY.
Shiny  2010-05-27 09:14:02
In that case, you want to use the built-in format capabilities of `ToString`. In this case, maybe something like `ToString("F1")` which will display as `4.0`.
lc  2010-05-27 09:29:34
+1  A: 

Use a format string, here is some reference Standard Numeric Format Stings

alejandrobog  2010-05-27 06:47:01
or (i = 0; i < dt.Rows.Count; i++) { dvgproductlist.Rows[i].Cells[7].Value = dt.Rows[i]["UnitPrice"].ToString(); } This how i retrieve values from access Database to gridview.. How can enable here the Format PROPERTY.How to achieve this
Shiny  2010-05-27 09:15:39
+1 for the reference link.
lc  2010-05-27 09:30:24

related questions

any good tool for makefile generation?
How do you pass a function as a parameter in C?
Where should a veteran C programmer start in order to master Java ?
Any good book on best practice and guidelines in developing a SDK in C?
How do you determine the size of a file in C?
Decoding printf statements in C (Printf Primer)
Shift operator in C
How to avoid redefining VERSION, PACKAGE, etc.
Alpha blending sprites in Nintendo DS Homebrew
When should I use type abstraction in embedded systems
How to implement continuations?
What are the barriers to understanding pointers and what can be done to overcome them?
Anyone have experience creating a shared library in MATLAB?
String.indexOf function in C
Passing multidimensional arrays as function arguments in C
C/C++ library for reading MIDI signals from a USB MIDI device
Choosing a static code analysis tool
How do you printf an unsigned long long int?
Good STL-like library for C.
Rockbox audio format
Why am I getting a malloc: double free error with realloc()?
Should I learn C?
GTK implementation of MessageBox
Is gettimeofday() guaranteed to be of microsecond resolution?
How to use the C socket API in C++ on z/OS