Table to List<T>

Costas

Administrator
Staff member
JavaScript:
MySQLClass db;
private void button1_Click(object sender, EventArgs e)
{
	MySqlException err = null;
	db = new MySQLClass("Data Source=localhost" +
			";Port=3306" +
			";Initial Catalog=x" +
			";User ID=x" +
			 ";Password=x", out err);

	if (err != null)
	{
		MessageBox.Show("error");
		return;
	}

	List<Teams> source = db.GetDATATABLE("select * from x").Rows.Cast<DataRow>().Select<DataRow, Teams>(delegate(DataRow dr)
	{
		Teams rec = new Teams
		{
			id = int.Parse(dr["id"].ToString()),
			date_rec = DateTime.Parse(dr["date_rec"].ToString()),
			champion = dr["champion"].ToString(),
			team1 = dr["team1"].ToString(),
			team1_points = dr["team1_points"].ToString(),
			team2 = dr["team2"].ToString(),
			team2_points = dr["team2_points"].ToString()
		};


		rec.before2000 = (rec.date_rec.Year < 2000);

		return rec;

	}
	).ToList<Teams>();

	Console.Write(source.Count);
}

private class Teams
{
	public int id { get; set; }
	public DateTime date_rec { get; set; }
	public string champion { get; set; }
	public string team1 { get; set; }
	public string team1_points { get; set; }
	public string team2 { get; set; }
	public string team2_points { get; set; }
	public bool before2000 { get; set; }

}
 
Top