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

5 votes297 views3 answers
Unix time c#
C#
0 vote251 views1 answer
Unity point between two positions
C#
0 vote282 views1 answer
Check if two timespans intersect c#
C#
4 votes281 views2 answers
Wpf label text in center
C#
0 vote286 views1 answer
Linked list follow what in c#
C#
2 votes279 views1 answer
Unity 2d detect click on sprite
C#
2 votes276 views2 answers
Transform widget in flutter
C#
3 votes291 views6 answers
Update value in list c#
C#
0 vote673 views1 answer
C# dictionary with dictionary as value
C#
4 votes263 views2 answers
C# console beep sounds
C#