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 ListView