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 vote364 views1 answer
Unity how to destroy child
C#Unity
1 vote322 views1 answer
C# set file invisible
C#
0 vote307 views1 answer
C# open config file by path
C#
0 vote282 views2 answers
C# wpf control to windw size
C#
-1 vote333 views1 answer
Unity audio source playoneshot
C#Unity
0 vote289 views1 answer
Basic auth swagger .net core 5
C#
2 votes310 views1 answer
Unity gameobject.find not working
C#
0 vote325 views1 answer
Download xml file asp.net web api
C#
1 vote338 views1 answer
C# unity follow object
C#Unity
0 vote312 views1 answer
How to display a form when a button click c# windows form
C#