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 vote183 views1 answer
How to mock abstract httpcontext using moq .net core
C#
0 vote204 views2 answers
Component dynamic vue
C#
0 vote183 views1 answer
Darf man in hotels übernachten
C#
41 votes196 views4 answers
Make a list c#
C#
7 votes176 views2 answers
C# stop loop
C#
0 vote245 views1 answer
Populate toolstripitems to combobox
C#
18 votes212 views3 answers
Unity Pause Game c#
C#Unity
0 vote172 views1 answer
C# random sleep
C#
0 vote186 views1 answer
Unity break if statement
C#
0 vote182 views1 answer
Lock pc using c#
C#