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 vote105 views3 answers
Macy's thanksgiving day parade spongebob
C#
0 vote92 views1 answer
Rgb to console color
C#
0 vote214 views1 answer
C# create dynamic object
C#
1 vote100 views1 answer
System.Linq.IOrderedEnumerable`2[System.Char,System.Char] çözümü
C#
0 vote102 views1 answer
C# winscp upload file
C#
0 vote95 views2 answers
C# convert string to uri
C#
15 votes95 views2 answers
Convert base64 string to string c#
C#
1 vote107 views1 answer
Warum wächst Weizen besonders gut in den Steppen?
C#
106 votes250 views6 answers
C# get random integer
C#
3 votes118 views1 answer
Unity if in editor
C#Unity