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

11 votes168 views6 answers
Ternary operator in c#
C#
0 vote129 views1 answer
How to show error xtramessagebox in devexpress c#
C#
3 votes129 views1 answer
How to name GameObject in c#
C#
5 votes182 views2 answers
Smooth rotation unity
C#Unity
14 votes164 views4 answers
Unity call function from another script
C#
2 votes128 views1 answer
Serilog log level hierarchy
C#
3 votes126 views1 answer
Unity get speed of object
C#
0 vote131 views1 answer
What function is called just before the a script is ended c#
C#
0 vote127 views1 answer
Wpf background color
C#
0 vote128 views1 answer
C# remove exit icon
C#