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 vote273 views1 answer
Urlreferrer in asp.net core
C#
0 vote256 views1 answer
For what is ? sign in unity c#
C#
3 votes336 views6 answers
C# timestamp
C#
0 vote284 views1 answer
Remove header visual studio android
C#
3 votes322 views1 answer
Create line in unity
C#Unity
0 vote304 views1 answer
Unity format float to 2 decimal places
C#
1 vote302 views1 answer
C# set file invisible
C#
3 votes283 views2 answers
Webclient c# example post
C#
3 votes309 views1 answer
C# arraylist
C#
0 vote257 views1 answer
Open project in visual studio using command prompt
C#