db.SelectBBS();//这是从dataSet数据集中填充数据的方法
DataTable dt = db.ds.Tables["NewBBS"];
this.listView1.Clear();//清空全部,包括标题
this.listView1.Columns.Add("序号",60,HorizontalAlignment.Center);
this.listView1.Columns.Add("留言者", 65, HorizontalAlignment.Center);
this.listView1.Columns.Add("留言类型", 60, HorizontalAlignment.Center);
this.listView1.Columns.Add("留言内容", 150, HorizontalAlignment.Center);
this.listView1.Columns.Add("留言日期", 100, HorizontalAlignment.Center);
this.listView1.Columns.Add("回复内容", 150, HorizontalAlignment.Center);
this.listView1.Columns.Add("回复日期", 100, HorizontalAlignment.Center);
this.listView1.Items.Clear();//清空内容
foreach (DataRow dr in dt.Rows)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = dr[0].ToString();
lvi.SubItems.Add(dr[1].ToString());
lvi.SubItems.Add(dr[2].ToString());
lvi.SubItems.Add(dr[3].ToString());
lvi.SubItems.Add(dr[4].ToString());
lvi.SubItems.Add(dr[5].ToString());
lvi.SubItems.Add(dr[6].ToString());
this.listView1.Items.Add(lvi);
}
//让listView自适应内容宽度
foreach (ColumnHeader item in this.listView1.Columns)
{
item.Width = -2;
}
06-14
1552
06-05
4586
04-25
426
02-18
736