var items = (from p in db.tbl_film
select new {
ID=p.flm_id,name=p.flm_name,description=p.flm_description,link=p.flm_link,sub=p.flm_sub_link,cate=p.flm_category,pic=p.flm_pic
});
foreach (var itemlist in items)
{
ListViewItem lvi = new ListViewItem(itemlist.ID.ToString());
lvi.SubItems.Add(itemlist.name);
lvi.SubItems.Add(itemlist.description);
lvi.SubItems.Add(itemlist.link);
lvi.SubItems.Add(itemlist.sub);
lvi.SubItems.Add(itemlist.cate);
lvi.SubItems.Add(itemlist.pic);
listView1.Items.Add(lvi);
}