private void GetData() { var dbCon = MySqlConnector.Instance(); if (dbCon.IsConnect()) { //suppose col0 and col1 are defined as VARCHAR in the DB string query = @"SELECT post_id, message FROM xf_post where message like '%[img]http://test.suineg.org%';"; var cmd = new MySqlCommand(query, dbCon.Connection); MySqlDataReader reader = cmd.ExecuteReader(); messages = ConvertData(reader).ToList(); } }
private void SaveData() { var dbCon = MySqlConnector.Instance(); dbCon.Connection.Close(); foreach (PostData postD in messages) { if (dbCon.IsConnect()) { MySqlCommand command = dbCon.Connection.CreateCommand(); command.CommandText = $"UPDATE XF_POST SET message = @data WHERE Post_Id =@id"; command.Parameters.AddWithValue("@data", postD.Message); command.Parameters.AddWithValue("@id", postD.PostId); command.ExecuteNonQuery(); } //dbCon.Connection.Close(); } }