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

2 votes200 views1 answer
Unity public static variable
C#
0 vote206 views1 answer
Angular === vs ==
C#
0 vote204 views1 answer
Listbox items to string c#
C#
1 vote240 views1 answer
How to make an object appear and disappear in unity
C#Unity
0 vote210 views1 answer
Custom player spawner mirror
C#
0 vote213 views1 answer
How to remove from list from index c#
C#
3 votes229 views5 answers
Bitmap to byte array c#
C#
0 vote226 views1 answer
Unity get refresh rate
C#
2 votes218 views4 answers
The request was aborted: Could not create SSL/TLS secure channel.
C#
0 vote213 views1 answer
C# how to load type of class from string
C#