Csharp: listview control binding database from datatable

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

listView1.GridLines = true;//显示行与行之间的分隔线               listView1.FullRowSelect = true;//要选择就是一行               listView1.View = View.Details;//定义列表显示的方式              listView1.Scrollable = true;//需要时候显示滚动条              listView1.MultiSelect = true; // 可以多行选择               listView1.HeaderStyle = ColumnHeaderStyle.Clickable;              if (dt.Columns.Count > 0)            {                //表頭名                foreach (DataColumn column in dt.Columns)                {                    listView1.Columns.Add(column.ColumnName);                }                  int r = 0;                //每一行                foreach (DataRow row in dt.Rows) // Loop over the rows.                {                    ListViewItem item = new ListViewItem(row[0].ToString());                    for (int i = 1; i < dt.Columns.Count; i++)                    {                        if (i == 2)//因是二進制，顯示不了                        {                            item.SubItems.Add("");                        }                        else                        {                            item.SubItems.Add(row[i].ToString());                        }                    }                    listView1.Items.Add(item);                   r++;                                     }                }

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsChineseCalender
{
    /// <summary>
    /// 20130117 
    /// 塗聚文
    /// </summary>
    public partial class TreeViewDataForm : Form
    {

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public DataTable setData()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("CompanyUid", typeof(Guid));
            dt.Columns.Add("CompanyID", typeof(int));
            dt.Columns.Add("CompanyName", typeof(string));
            dt.Columns.Add("CompanyParentID", typeof(int));
            dt.Rows.Add(Guid.NewGuid(), 1, "塗聚文", 0);
            dt.Rows.Add(Guid.NewGuid(), 2, "塗聚文1", 1);
            dt.Rows.Add(Guid.NewGuid(), 3, "塗聚文2", 1);
            dt.Rows.Add(Guid.NewGuid(), 4, "塗聚文3", 1);
            dt.Rows.Add(Guid.NewGuid(), 5, "塗聚文31", 4);
            dt.Rows.Add(Guid.NewGuid(), 6, "塗聚文32", 4);
            dt.Rows.Add(Guid.NewGuid(), 7, "塗聚文321", 6);


            return dt;
        }
        /// <summary>
        /// 
        /// </summary>
        public TreeViewDataForm()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void TreeViewDataForm_Load(object sender, EventArgs e)
        {
            LoadData();
        }
        /// <summary>
        /// 
        /// </summary>
        private void LoadData()
        {
            this.listView1.Items.Clear();
            listView1.GridLines = true;//显示行与行之间的分隔线    
            listView1.FullRowSelect = true;//要选择就是一行    
            listView1.View = View.Details;//定义列表显示的方式   
            listView1.Scrollable = true;//需要时候显示滚动条   
            listView1.MultiSelect = true; // 可以多行选择    
            listView1.HeaderStyle = ColumnHeaderStyle.Clickable;
            
            DataTable dt = setData();//
            //listView1.DataBindings = dt;
           // listView1.Items.Add(new ListViewItem(new string[]{},0);
            //表頭名
            if (dt.Columns.Count > 0)
            {
                foreach (DataColumn column in dt.Columns)
                {
                    listView1.Columns.Add(column.ColumnName);
                }
            }
            int k = 0;
            foreach (DataRow dr in dt.Rows)
            {
                //1種方式
                //this.listView1.Items.Add(new ListViewItem(new string[] { dr["CompanyUid"].ToString(), dr["CompanyName"].ToString(), dr["CompanyParentID"].ToString(), dr["CompanyID"].ToString() },k++));

                //2種方式
                ListViewItem lvitem = new ListViewItem();
                lvitem.SubItems[0].Text = dr["CompanyUid"].ToString();
                lvitem.SubItems.Add(dr["CompanyName"].ToString());
                lvitem.SubItems.Add(dr["CompanyParentID"].ToString());           
                lvitem.SubItems.Add(dr["CompanyID"].ToString());
                listView1.Items.Add(lvitem);
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void listView1_DoubleClick(object sender, EventArgs e)
        {
            
        }
        /// <summary>
        /// 選擇的行
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void listView1_ItemActivate(object sender, EventArgs e)
        {
            int index = listView1.SelectedIndices[0];
            string k = "";
            if (listView1.SelectedIndices != null && listView1.SelectedIndices.Count > 0)
            {
                ListView.SelectedIndexCollection c = listView1.SelectedIndices;
                k= listView1.Items[c[0]].Text; //
                MessageBox.Show(k);
            }
            //選擇的行數
            MessageBox.Show(listView1.SelectedIndices.Count.ToString());
            //共有多少列
            MessageBox.Show(listView1.Items.Count.ToString());
            ListView.SelectedIndexCollection indexes = this.listView1.SelectedIndices;            
            foreach (int indext in indexes)
            {
                k = this.listView1.Items[indext].SubItems[0].Text;
                 k=k+","+this.listView1.Items[indext].SubItems[1].Text;
                 k = k + "," + this.listView1.Items[indext].SubItems[2].Text;
                 k = k + "," + this.listView1.Items[indext].SubItems[3].Text;
            }
            //顯示出一行的值
            MessageBox.Show(k);
        }
    }
}