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

8 votes200 views2 answers
Asp.net core get request ip address
C#
18 votes182 views3 answers
C# decimal vs double
C#
1 vote177 views2 answers
C# for
C#
1 vote193 views1 answer
C# separate string by a new line
C#
0 vote203 views2 answers
Autoit console write
C#
0 vote178 views1 answer
Unity mix gradient colors
C#
0 vote203 views1 answer
Getelement video
C#
0 vote186 views1 answer
How to generate random unique id in c#
C#
13 votes190 views2 answers
C# create a text file
C#
0 vote194 views1 answer
Unity c# image invisible
C#