Execute Non Query: Input string was not in a correct format

Help
, , ,
1

i want to insert string value to database integer column
Capture1
but following error occurred

Capture
Capture979×502 24 KB

here i attached my process and excel sheetabc.xlsx (8.1 KB)
Main.xaml (26.1 KB)
can you please help me to solve this problem ?

2

you are telling “insert string value to database integer column”

Obviously it will throw an error because data types are not matching.
Make sure all input values match with the database types.

3

@KarthikByggari
when i try to read excel integer value by using Get Row Item
it returns following error
Get Row Item: Int32Converter cannot convert from System.Double.

4

Are you converting the value to Integer?

6

@KarthikByggari
here my process
Main.xaml (27.5 KB)

7

Main.xaml (27.5 KB)

hope this will work for you.
Thanks!

8

hi @Deepak94
no its not work

9

Create a variable lets say ‘newage’ and assign a default value to it.
newage=Convert.ToInt32(“age”)
And now use newage in insert query

10

ok.
what error you got this time ?

11

@Deepak94

Capture3
Capture3923×324 17 KB

12

Ok.
Try one more time…
Main.xaml (28.2 KB)

13

@Deepak94

Capture4
Capture4825×422 15.9 KB

14

can you check your column type of sql table ?
Try to change to varchar.

15

@Deepak94
i need to insert int data in database table
Capture

16

Yes.
Change the data type of radioval from varbinary to varchar

1 Like
17

@Deepak94
solve
thank you very much :smiling_face_with_three_hearts:

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.