save end of line to data base

Vote count:

0

C#

MySqlConnection connection = new MySqlConnection(myConnectionString); 
string command = "update `triggers` set tri_webbot=@text where `triggers`.TRI_UID='" + TRI_UID + "'";
MySqlCommand myCommand = new MySqlCommand(command, connection);
myCommand.Parameters.AddWithValue("@text", text);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
connection.Close();

Text

test 
    test
        test

when run query text save to field database as 'testtesttest' and does not save end of line and space.

Questino how can save space and EOF(end of line) to database field?

asked 50 secs ago

ashkufaraz

74

save end of line to data base