c# - Trying to import data from Excel sheet into SQL Server table with different datatypes -


i try import data excel sheet sql server table. have 1 column data type decimal.

i error:

input string not in correct format.

this code

price = convert.todecimal(((excel.range)range.cells[row, 13]).text) 

i have resolved myself thank kind response , kind support. here solution

   string pricevalue = ((excel.range) range.cells[row, 14]).text;    cards.price = convert.todecimal(pricevalue); 

Comments

Popular posts from this blog

sql - invalid in the select list because it is not contained in either an aggregate function -

Angularjs unit testing - ng-disabled not working when adding text to textarea -

How to start daemon on android by adb -