Put the Query result of MySql in to a C# list or array?

Question

I've done some searching for the answer, but only find a lot of PHP answers. I need this for a C# application. Can any one point me in the right direction?

I'm doing this, but this only returns the first row into my variable:

    Query("SELECT SaksNummer FROM casetracking")

    public static string Query(string query)
    {
        string x;
        mysqlCon.Open();
        cmd = new MySqlCommand(query, mysqlCon);
        x = cmd.ExecuteScalar().ToString();
        mysqlCon.Close();
        return x;
    }

D'Arcy Rittich · Accepted Answer · 2010-12-14 14:50:11Z

5

ExecuteScalar is designed to only return one (thus scalar) value:

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Try using ExecuteReader. Example:

public void CreateMySqlDataReader(string mySelectQuery, MySqlConnection myConnection) 
 {
    MySqlCommand myCommand = new MySqlCommand(mySelectQuery, myConnection);
    myConnection.Open();
    MySqlDataReader myReader;
    myReader = myCommand.ExecuteReader();
    try
    {
      while(myReader.Read()) 
      {
        Console.WriteLine(myReader.GetString(0));
      }
    }
    finally
    {
      myReader.Close();
      myConnection.Close();
    }
 }

answered Dec 14, 2010 at 14:50

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pablo Recalde Over a year ago

An update with new language features could be nice, this is 9 years old now.

Collectives™ on Stack Overflow

Put the Query result of MySql in to a C# list or array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related