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 vote311 views1 answer
Linq query to fetch parent child data from same table in c#
C#
0 vote312 views1 answer
Unity product.hasreceipt
C#
3 votes347 views1 answer
Create a directory if it doesnt exist c#
C#
6 votes300 views1 answer
Net core 5.0 create model from database
C#
0 vote304 views1 answer
Save position unity
C#
4 votes304 views1 answer
Instantiate list with values c#
C#
0 vote376 views1 answer
Unity I run exe second monitor
C#Unity
4 votes313 views2 answers
C# get desktop path
C#
0 vote362 views1 answer
Download xml file asp.net web api
C#
2 votes333 views1 answer
C# datetime get number of week
C#