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

2 votes142 views2 answers
Byte to binary c#
C#
16 votes153 views2 answers
C# delete file if exists
C#
0 vote142 views1 answer
C# sprintf equivalent
C#
2 votes150 views2 answers
Inactive after active with press key unity
C#
0 vote135 views1 answer
Commit help
C#
1 vote187 views1 answer
2d ray unity
C#Unity
0 vote141 views1 answer
Casting in c#
C#
4 votes179 views1 answer
C# loop through datatable
C#
0 vote142 views1 answer
Dotnet build command
C#
2 votes118 views1 answer
How to create a new folder with c#
C#