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 vote350 views1 answer
C# webclient vs httpclient
C#
0 vote362 views1 answer
C# return list
C#
3 votes342 views4 answers
C# byte array to bitmap
C#
41 votes334 views5 answers
How to print in c#
C#
0 vote347 views1 answer
Calculate string length vs pixels c#
C#
0 vote436 views1 answer
C# process start
C#
0 vote318 views3 answers
C# shuffle array
C#
2 votes350 views1 answer
Play a sound c#
C#
4 votes353 views1 answer
C# require administrator permissions
C#
3 votes322 views2 answers
C# app path
C#