Error converting datatype varchar to float error

Question

Hello everyone,   I wrote a code in C #. This code inserts the data that I take from PLC into sql. When I run the .exe file on my own computer, the program runs without error and the insert operation takes place. However, when I run the same program on the same code on another computer, I get an "Error converting data type varchar to float" error. The .NET Framework versions of both computers are identical. What can be the problem?

Rajanikant Hawaldar · Accepted Answer

in another computer at database table datatype is same as in your first computer database? before convert that varchar to float first check that is IsNumric(column)  then only convert to float

Enes Kucukpehlivan · Answer

The values ​​I want to send to the database are already float. In general, I think it wouldn't work anywhere if there was a problem with the data types.

Enes Kucukpehlivan · Answer

Thank you for your answer. Yes, database tables are exactly the same, the only thing different is computers. Nothing else is different.

Nikhil Sangani · Answer

Please check this error is from sql side and you have used cast anywhere??