| 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數(shù)據(jù)項(xiàng) //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++) //{//添加數(shù)據(jù)列。 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中的所有數(shù)據(jù)。 //// ItemDt = jkj.GetDataTable("select cdlb as 查詢類別,count(userid) as 利用人次,count(rc) as 利用卷數(shù) From viewly where nd=" + mmm + " Group by cdlb order by cdlb"); Method(dt); //// } } ////// 為ListView綁定數(shù)據(jù)項(xiàng) //////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); } } |
|
|
