MySQL选择结果保存到c#变量中 [英] MySQL select result save into c# variable

问题描述

能否请您检查我的代码并回答我如何将 mysql 选择结果保存到 C# 字符串中?

Can you please check my code and answer me how can i save a mysql select result into a c# string?

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 = '[e-mail]'"        
              _dbConnect.getConnection());


            MySqlDataReader reader = command.ExecuteReader();


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

            reader.Close();
        }

非常感谢！

推荐答案

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

Yes,You can use ExecuteReader() for this..

        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);
        }

这篇关于MySQL选择结果保存到c#变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！