Problem in accessing 4 decimal values while uploading excel

Prabu Spark

Hi sir,
Problem in accessing 4 decimal values while uploading excel into asp.net c#. I have created one website that upload one excel file containing one field 'customerid' as "5.53861.11.11.100126", but it shows null value while the other values like "1.14026836"
showing the correct values in 'customerid' field.

My question is why i cant able to read the 'customerid' field as "5.53861.11.11.100126". I can able to read the value "1.14026836". Kindly give me the solution for this problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
What's the type of the DataColumn object corresponding to that field?

If 'dt' is your DataTable you should be able to get it with the expression:

dt.Columns["customerid"].DataType.ToString()
Prabu Spark13y ago
Hi, I cant able to access the 4 decimal values during upload, i am not using any variable, in dataset itself i am getting null value for the custid column, if i have two decimal values it is shown in the column but i cant able to show 4 decimal values. Kindly give me the solution for this problem.
Vulpes13y ago
The only thing I can think of is that you're trying to load the 'customerid' field into a variable of type float, double or decimal.

That works fine as long as there's only one decimal point but fails if there are multiple decimal points in the field.

If that's in fact what you're trying to do, then you'll need to load the field into a string variable instead.