DataSet动态绑定Listview

 DataSet ds = new DataSet();
        SqlDataAdapter apt;
        #region 窗体加载事件
        private void Form1_Load(object sender, EventArgs e)
        {
            string sql = "SELECT * FROM dbo.BookInfo";
            apt = new SqlDataAdapter(sql,SQLHelper.con);
            apt.Fill(ds, "BookInfo");//把BookInfo表数据填充到dataset里面
            this.lvView.BorderStyle = BorderStyle.FixedSingle;//listview边框样式
            this.lvView.GridLines = true;//显示网格
            this.lvView.FullRowSelect = true;//当被选中时，一行变颜色，选中一行
            for (int i = 0; i < ds.Tables["BookInfo"].Columns.Count; i++)//遍历BookInfo表中的列
            {
                ColumnHeader ch = new ColumnHeader();//创建标题头对象
                ch.Width = 60;//标题头宽度60
                ch.TextAlign = HorizontalAlignment.Center;//文本居中对齐
                ch.Text = ds.Tables["BookInfo"].Columns[i].ColumnName;//标题头显示列的名称
                this.lvView.Columns.Add(ch);//将标题头添加到listview中
            }
            for (int i = 0; i < ds.Tables["BookInfo"].Rows.Count; i++)//遍历BookInfo中所有行
            {
                ListViewItem lvi = new ListViewItem();
                lvi.SubItems[0].Text = ds.Tables["BookInfo"].Rows[i]["bookId"].ToString();
                lvi.SubItems.AddRange(new string []{
                ds.Tables["BookInfo"].Rows[i]["bookName"].ToString(),
                ds.Tables["BookInfo"].Rows[i]["bookAuthor"].ToString(),
                ds.Tables["BookInfo"].Rows[i]["bookAuthor"].ToString(),
                ds.Tables["BookInfo"].Rows[i]["bookPrice"].ToString(),
                ds.Tables["BookInfo"].Rows[i]["publish"].ToString() });
                this.lvView.Items.Add(lvi);//将数据添加到listview中
            }
        }
        #endregion