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 vote245 views1 answer
Wpf settings core
C#
0 vote245 views1 answer
Unity add to dictionary
C#Unity
0 vote284 views2 answers
Blazor onchange event not firing with inputselect
C#
5 votes250 views2 answers
Vscode c# how to change to externial terminal
C#
0 vote255 views1 answer
Disable Debug.log Unity
C#
0 vote286 views1 answer
C# statements
C#
5 votes297 views1 answer
Unity movetowards 2d
C#Unity
0 vote286 views1 answer
Billboard canvas unity
C#Unity
0 vote255 views1 answer
Como guardar archivo en un botón asp.net
C#
5 votes308 views5 answers
Clear array c#
C#