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 vote247 views1 answer
C# read from text documenmt
C#
0 vote245 views3 answers
Reporting Progress from Async Tasks c#
C#
0 vote226 views1 answer
Precision comparison in C#
C#
1 vote255 views1 answer
Convert array object to int[] c#
C#
36 votes261 views5 answers
How to find length of list c#
C#
0 vote242 views1 answer
C# today without time
C#
2 votes257 views1 answer
C# gzip byte array
C#
0 vote232 views1 answer
C# read single key
C#
2 votes238 views1 answer
Delete null elements array c#
C#
0 vote240 views1 answer
Unity control physics of multiple simulation
C#