c mysql dataset查询_MySql查询数据

引用的DLL

MySql.Data.MySqlClient

System.Data

City实体

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 GetCityList()

{

List cityList = new List();

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;

}