MySQL选择结果保存到C#变量中

你能检查我的代码并回答我如何将 mysql 选择结果保存到 C# 字符串中吗？

try
{
    MySqlDataReader reader = null;
    string selectCmd = "SELECT * FROM  TabelaUtilizatori";
    MySqlCommand cmd = new MySqlCommand(selectCmd, _dbConnect.getConnection());
    string result = cmd.ExecuteScalar().ToString();
    label2.Text = result;
}
catch (Exception ex) {
    MessageBox.Show(ex.Message);
}

或者也许这样？

            using (_dbConnect.getConnection())
             {
            MySqlCommand command = new MySqlCommand(
                  "SELECT NAME FROM TABELAUTILIZATORI WHERE EMAIL = '[email protected] /cdn-cgi/l/email-protection'"        
              _dbConnect.getConnection());


            MySqlDataReader reader = command.ExecuteReader();


                while (reader.Read())
                {
                 label2.Text=
                }

            reader.Close();
        }

多谢 ！

是的，您可以为此使用 ExecuteReader() ..

        try
        {
            MySqlDataReader reader = null;
            string selectCmd = "SELECT * FROM  TabelaUtilizatori";

            MySqlCommand command = new MySqlCommand(selectCmd, _dbConnect.getConnection());
            reader = command.ExecuteReader();

            while (reader.Read())
            {
                string ColumnName = (string)reader["ColumnName"];
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }