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
Post a Comment