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

0 vote271 views1 answer
How to show messagebox
C#
0 vote253 views1 answer
How to draw a dot in c#
C#
0 vote237 views1 answer
Unity time.fixeddeltatime
C#
1 vote269 views1 answer
Unity cancel invoke
C#Unity
1 vote270 views1 answer
C# monogame mouse position
C#
1 vote269 views1 answer
Time.timescale
C#
0 vote272 views1 answer
C# Search specified string inside textbox
C#
1 vote269 views1 answer
C# KERNEL32.DLL recoverdeleted files
C#
0 vote260 views1 answer
Selenium webdriver what browser am i using?
C#
0 vote258 views1 answer
Ensure multiple variables not null c#
C#