C#将SQL查询的select结果直接填充在listview里显示

每次从SQL数据库取出数据需要显示时,都要经过非常麻烦的步骤,为了方便快速的开发程序,我写了一个函数,自动将select 后的结果显示到listview里,并且自动将列标题一块显示出来

 

 

        public bool FillListView(System.Windows.Forms.ListView mylistview, string SQL)
        {
            try
            {
                mylistview.Items.Clear();

                SqlDataReader rd = GetDataReader(SQL);
                if (rd == null)
                    return false;

                //给ListView添加不足的列
                for (int i = mylistview.Columns.Count; i < rd.FieldCount; i++)
                {
                    mylistview.Columns.Add(rd.GetName(i), 100, System.Windows.Forms.HorizontalAlignment.Center);
                }
                //读出数据
                while (rd.Read())
                {
                    ListViewItem lvi = new ListViewItem();
                    lvi.Text = rd[0].ToString();
                    for (int i = 1; i < rd.FieldCount; i++)
                        lvi.SubItems.Add(rd[i].ToString());
                    mylistview.Items.Add(lvi);
                }
                rd.Dispose();
                return true;
            }
            catch
            {
                return false;
            }
        }

 

 

 

此函数已在不同项目中使用多年,效果非常好,已收录到自己的通用C#库里

C#将SQL查询的select结果直接填充在listview里显示
微信打赏支持