private void ItemBind()
{
//SqlConnection conn = BaseClass.DBConn.CjCon();
//conn.Open();
//SqlDataAdapter sda = new SqlDataAdapter("select kch as 课程号,kcm as 课程名 From kcb order by kch", conn);
//DataSet ds = new DataSet();
//sda.Fill(ds);
//this.listView1.Groups.Clear();//清空ListView分组
//this.listView1.Items.Clear(); //清空ListView数据项
//this.listView1.GridLines = true;
//this.listView1.View = View.Details;
//this.listView1.Columns.Clear();//清空ListView列
//DataTable ItemDt = new DataTable();
ColumnHeader ch = null;
ColumnHeader ch2 = null;
//ItemDt = ds.Tables[0];
DataTable dt = ds("select kch as 课程号,kcm as 课程名 From kcb order by kch");
//for (int y = 0; y < ItemDt.Columns.Count; y++)
//{//添加数据列。
ch = new ColumnHeader();
ch2 = new ColumnHeader();
//ch.Text = ItemDt.Columns[y].ColumnName.ToString();
//ch.Name = ItemDt.Columns[y].ColumnName.ToString();
ch.Text = "课程名";
ch.Name = "课程名";
ch.Width = 120;
this.listView1.Columns.Add(ch);
ch2.Text = "kch";
ch2.Name = "kch";
ch2.Width = 230;
this.listView1.Columns.Add(ch2);
//}
//DataTable zdt = jkj.GetDataSet("Select Distinct nd From viewly order by nd", "nian").Tables["nian"];
//ListViewGroup Lvg = null;
//int mmm = 0;
//for (int i = 0; i < ItemDt.Rows.Count; i++)
////{//添加ListView分组
// Lvg = new ListViewGroup(zdt.Rows[i][0].ToString().Trim() + "年");
//mmm = int.Parse(zdt.Rows[i][0].ToString().Trim());
//this.listView1.Groups.Add(Lvg);
//ItemDt.Clear();//清空DataTable中的所有数据。
//// ItemDt = jkj.GetDataTable("select cdlb as 查询类别,count(userid) as 利用人次,count(rc) as 利用卷数 From viewly where nd=" + mmm + " Group by cdlb order by cdlb");
Method(dt);
//// }
}
////// 为ListView绑定数据项
//////DataTable表
///ListViewGroup分组
private void Method(DataTable dd)
{
ListViewItem lvi = null;
for (int x = 0; x < dd.Rows.Count; x++)
{
lvi = new ListViewItem(dd.Rows[x][0].ToString());
for (int k = 1; k < dd.Columns.Count; k++)
{
// lvi.ImageIndex = 0;
lvi.SubItems.Add(dd.Rows[x][k].ToString());
}
this.listView1.Items.Add(lvi);
}
}
|