C # SQL uses a string variable in a where query statement with an INT type variable

When using the where statement to access the database, the where statement is queried using the variables defined above and above.

String sql3 = String. Format ("Update Ships set containernum= '" +list1[0]. containernum+ "' Where Name= '" +list[0]. Shipname+ "'");

Ships is the table name Containernum is the field name in the table

List1[0]. Containernum is an int type variable above, list[0]. ShipName is the string type variable above

You only need to manipulate the variables within the double quotation marks of the SQL statement, i.e.

("SELECT * from table name  where field name = '" + Variable name + "'    ") Note: ' + variable name + '  to enclose two double quotes in two single quotes

C # SQL uses a string variable in a where query statement with an INT type variable