Question

C#中如何将DataTable中的数据绑定到Listview控件(Listview已设置columns属性)

求具体实现代码

Answer 1

private void LoadData(string sql)
{
this.lvRoomList.Items.Clear();
DataTable dt = DbHelper.GetOneTable(sql);
foreach (DataRow dr in dt.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = dr["RoomID"].ToString();
lvi.SubItems.AddRange(new string[] { dr["RoomType"].ToString(), dr["RoomTel"].ToString(), dr["Area"].ToString(), dr["Bak"].ToString() });
this.lvRoomList.Items.Add(lvi);
}
}

Answer 2

DataTable 数据可以重新设置下columns名称再去绑定Listview