MySql查询数据

引用的DLL

MySql.Data.MySqlClient
System.Data
Cityvb.net教程c#教程实体

public class City
{
    public int ID { get; set; }
    public string Name { get; set; }
    public string CountryCode { get; set; }
    public string District { get; set; }
    public int Population { get; set; }
}

连接字符串

string connectionStr = “server=127.0.0.1;database=数据库;User ID=root;password=密码”;
实现逻辑

public List<City> GetCityList()
{
    List<City> cityList = new List<City>();
    string sqlStr = "select * from city";
    using (MySqlConnection con = new MySqlConnection(connectionStr))
    {
        con.Open();
        MySqlCommand command = new MySqlCommand();
        if (con.State != ConnectionState.Open)
        {
            con.Open();
        }
        command.Connection = con;
        command.CommandText = sqlStr;
        using (MySqlDataAdapter da = new MySqlDataAdapter(command))
        {
            DataSet ds = new DataSet();
            da.Fill(ds, "city");
            foreach (DataRow inst in ds.Tables[0].Rows)
            {
                City city = new City();
                city.ID = int.Parse(inst["ID"].ToString());
                city.Name = inst["Name"].ToString();
                city.CountryCode = inst["CountryCode"].ToString();
                city.District = inst["District"].ToString();
                city.Population = int.Parse(inst["Population"].ToString());
                cityList.Add(city);
 
            }
        }
    }
    return cityList;
}