deepa ashwi

deepa ashwi

  • NA
  • 109
  • 602.5k

how to roundup Excel sheet float value in to sqlserver query

Jun 30 2013 12:07 PM
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] + "')";

Answers (1)