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 vote354 views1 answer
Toggle unity c#
C#Unity
0 vote300 views2 answers
Get sha1 of file c#
C#
0 vote286 views1 answer
Dotnet target specific framework
C#
0 vote311 views1 answer
Return every digit on a string c#
C#
6 votes276 views2 answers
Left moust click unity
C#
0 vote290 views1 answer
Go to the corresponding brace visual studio C#
C#
0 vote284 views1 answer
Fluent api c# hasmany withmany
C#
0 vote263 views1 answer
Oldest living language
C#
7 votes269 views5 answers
C# or
C#
0 vote324 views2 answers
C# boundingbox text
C#