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 vote132 views2 answers
Remove specific character from string c#
C#
0 vote144 views2 answers
How to loop through a list and skip first element in c#
C#
2 votes126 views1 answer
How to insert into a list c#
C#
0 vote131 views1 answer
Wait some seconds without blocking UI execution
C#
0 vote129 views2 answers
For c#
C#
1 vote158 views1 answer
C# iformfile to string
C#
0 vote159 views1 answer
C# .net 3.5 post json httpclient
C#
1 vote156 views1 answer
C# add two int variables
C#
0 vote146 views1 answer
Fix autofill issue asp.net mvc
C#
1 vote127 views1 answer
C# System.Resources.MissingManifestResourceException error
C#