There are 2 Textbox in my web page (say TxtParam1 and TxtParam2), whose datatype is DOUBLE in Database
When I am trying to update both TxtParam1 and TxtParam2 value in database, using "update query", it throws MySqlException as below:
MySql.Data.MySqlClient.MySqlException: Data truncated for column 'X' at row 1
Update query im using is:
string query = "update Table1 SET Param1='" + TxtParam1 + "', Param2='" + TxtParam2 + "' where id='" + id + "'";
DataManager.DatabaseManager.GetOrCreateConnection(DataManager.DatabaseManager.ConnectionType.MySQL).ExecuteNonQueryCommand(query, null);
Please reply how to solve it.