C# mysql query

MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM customers",con);
MySqlDataReader reader = cmd.ExecuteReader();
	while (reader.Read())
	{
    	//You can get values from column names
    	Console.WriteLine(reader["customerName"].ToString());
      	//Or return the value from the columnID, in this case, 0
    	Console.WriteLine(reader.GetInt32(0));
	}
con.Close();

Similar codes

-1 vote233 views1 answer
Unity check if colliders are touching
C#
-1 vote225 views1 answer
How to fix unity crashing
C#Unity
0 vote249 views1 answer
EventSource Web API C#
C#
1 vote239 views2 answers
Structure in c sharp with example
C#
1 vote181 views1 answer
C# get next item in list
C#
0 vote170 views1 answer
C# get a value from value tuple list
C#
0 vote216 views1 answer
Epplus how to align text to right
C#
-1 vote234 views1 answer
Unity get layermask
C#Unity
11 votes174 views2 answers
Unity change tmp text from script
C#
0 vote169 views1 answer
How to count letters in c#
C#