windows services - Decimal value is read as scientific notation in sql server -
i have windows service reads .csv particular folder , puts in sql server. have code shown below:
private void updateworkorder(list etchrecord)
{ object[] objarr = new object[] { convert.toint32(etchrecord[1]), convert.todatetime(etchrecord[2]), convert.todatetime(etchrecord[3]), convert.todecimal(etchrecord[4]), convert.toint32(etchrecord[5]), **convert.todecimal(etchrecord[6])};** --> field dbmanager.execdataset("usp_etchrate_saveworkorderdata", objarr); }
and have stored procedure in sql server responsible stroing in sql table. problem shows decimal values in field shown above scientific notation. tried changing text doesn't work
Comments
Post a Comment