Отправка текста из richTextBox в таблицу базы данных MySql

listBox1.Items.Add(">" + richTextBox1.Text);
            string mes=richTextBox1.Text;
            MySqlConnection mySqlConnection = new MySqlConnection("server=tsovyan.myjino.ru;port=3306;username=047094112_sergey;password=!@fdsa$UF323);database=tsovyan_deslon");
            
                mySqlConnection.Open();
                MySqlCommand cmd = new MySqlCommand("Insert into messages" +
                "(id_user,id_friend,message,date,message_status) Values ('user','frien','message','date','0')", mySqlConnection);
                mes = cmd.ExecuteScalar().ToString();
            
            richTextBox1.Clear();

string mes=richTextBox1.Text;

MySql.Data.MySqlClient.MySqlConnection conn;
MySql.Data.MySqlClient.MySqlCommand cmd;
 
conn = new MySql.Data.MySqlClient.MySqlConnection();
cmd = new MySql.Data.MySqlClient.MySqlCommand();
 
conn.ConnectionString = strConnection;
 
try
{
    conn.Open();
    cmd.Connection = conn;
 
    cmd.CommandText = "INSERT INTO myTable VALUES(NULL, @number, @text)";
    cmd.Prepare();
 
    cmd.Parameters.AddWithValue("@number", 1);
    cmd.Parameters.AddWithValue("@text", "One");
 
    for (int i=1; i <= 1000; i++)
    {
        cmd.Parameters["@number"].Value = i;
        cmd.Parameters["@text"].Value = "A string value";
 
        cmd.ExecuteNonQuery();
    }
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
    MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
        "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}