Input string was not in a correct format

Question

Hi Please help me I really don’t know what to do… Here is my code. Function ROWS( ByVal dt As DataTable ByVal dtNew As DataTable) As DataRow Dim workRow As DataRow Dim i As Integer Try workRow = dtNew.NewRow() For i = 0 To 39 workRow(i) = dt.Rows(0).Item(i).ToString Next Catch ex As Exception MsgBox(ex.ToString) End Try Return (workRow) End Function dt comes from CSV files.I just want to add new row to this datatable from other datatable(dtNew) which has only one row. This is the error that I get: Input string was not in a correct format.Couldn't store in F16 Column. Expected type is Int32. What should I do??????

Sep · Answer

I found something which helped me.I created Schema.ini and put it right beside the csv file. the problem is solved. Here is my Schema.ini: [AllRecords.csv] Format=Delimited() ColNameHeader=False MaxScanRows=0 CharacterSet=ANSI Col1=F1 integer Col2=F2 char Col3=F3 integer Col4=F4 char Col5=F5 char Col6=F1 char Col7=F1 char Col8=F1 char Col9=F1 char Col10=F10 char Col11=F11 char Col12=F12 char Col13=F13 char Col14=F14 char Col15=F15 char Col16=F16 char Col17=F17 char Col18=F18 char Col19=F19 Float Col20=F20 char Col21=F21 char Col22=F22 char Col23=F23 Float Col24=F24 Float Col25=F25 Float Col26=F26 Float Col27=F27 Float Col28=F28 char Col29=F29 char Col30=F30 char Col31=F31 char Col32=F32 char Col33=F33 Float Col34=F34 Float Col35=F35 char Col36=F36 char Col37=F37 char Col38=F38 char Col39=F39 char Col40=F40 char

Sep · Answer

I am loading datatable from CSV file and I think there is no data type in csv files(text file).You are right it happen in culomn15 which is F16 but as I told you I get my data from CSV file.

Jan Montano · Answer

At what column number does the error occur? Assuming you have F1...F2...F16 and so on columns my guess is it occurs in the 16th column (i=15). workrow(15) expects an integer value and when you do this workRow(i) = dt.Rows(0).Item(i).ToString the error occurs. Debug what column number it occurs and verify if that column is indeed of string type and not a numeric type.

Sep · Answer

I really don't know what you mean!!!!!!!!!!!!!!!!!!!!1 'i' is a counter and I assigned values to datarow's item by i not to i. Please have a look again it is not what you think.Anyway the datarows' items are not interger.most of them are string and other things