Loading

how to roundup Excel sheet float value in to sqlserver query

deepa ashwi

i am importing data from Excel to SQL Server database.

how to convert a float value in excel to round up value in SQl Query. i need to convert here the Basic Salary from float value into Round Up value(when passing to database).

string ins = "insert into PaySalary1(BasicSalary,HRA)values
('" + Convert.ToDecimal(dtExcel.Rows[i][0]) + "','" + dtExcel.Rows[i][1] + "')";

1 Reply

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

Sunny Sharma13y ago
Hi Deepa,

You can use Math.Abs() to round up the decimal values, like:
---------------------------------------
```
string ins = "insert into PaySalary1(BasicSalary,HRA)values ('" + Math.Abs(Convert.ToDecimal(dtExcel.Rows[i][0])) + "','" + dtExcel.Rows[i][1] + "')";
```
Happy Coding :)

Mark it as answer if it helps you.
Cheers!