Problem in accessing 4 decimal values while uploading excel

Question

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.

Vulpes · Answer

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 Spark · Answer

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.

Vulpes · Answer

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.