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 vote174 views1 answer
Ef core set identity_insert off
C#
4 votes186 views2 answers
Dotnet install ef
C#
0 vote152 views1 answer
Webtest fullscreen extend window maximize
C#
1 vote123 views3 answers
C# record
C#
0 vote159 views1 answer
C# convert list to string and back
C#
0 vote169 views1 answer
Csharp datagridview filter column
C#
0 vote167 views1 answer
Stroke dash array wpf
C#
7 votes248 views2 answers
Unity move character
C#Unity
24 votes192 views2 answers
How to destroy an object in unity
C#
-1 vote166 views2 answers
C# check characters in string
C#