当前位置:编程学习 > C#/ASP.NET >>

ADO.net 中的LISTVIEW 控件 在连接SQL2005 时 , 两个字符串怎样相关联?

就是 把SQL中的数据显示在LISTVIEW 控件中事,如何把它们绑定! --------------------编程问答-------------------- private void AddDataToList()
        {
            this.lstview.Items.Clear();

            DataBase db = new DataBase();
            string sql = "......";
            DataTable dt = db.Select(sql);
            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    ListViewItem lst = new ListViewItem();
                    lst.Text = dr[0].ToString();
                    lst.SubItems.Add(dr[1].ToString());
                    lst.SubItems.Add(dr[2].ToString());
                    lst.SubItems.Add(dr[3].ToString());
                    lst.SubItems.Add(dr[4].ToString());
                    lst.SubItems.Add(dr[5].ToString());
                    lst.SubItems.Add(dr[6].ToString());
                    lst.SubItems.Add(dr[7].ToString());
                    lst.SubItems.Add(dr[8].ToString());
                    lst.SubItems.Add(dr[9].ToString());
                    lst.SubItems.Add(dr[10].ToString());
                    lst.SubItems.Add(dr[11].ToString());
                    lst.SubItems.Add(dr[12].ToString());
                    lst.SubItems.Add(dr[13].ToString());
                    lst.SubItems.Add(dr[14].ToString());//有多少列则添加多少子项
                    this.lstview.Items.Add(lst);
                }
            }
        }
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,