C# TreeView和ListView读取Excel表格

        本人刚开始工作时，完全是一只小白，从未接触过C#，领导分配一个任务，利用Treeview和Listview对Excel进行编辑和显示。今天偶然想起来这个小程序，分享给大家。

软件效果图：

具体代码利用Oledb将Excel数据保存然后进行编辑:

   string xlsname = "";
        DataSet ds = new DataSet();
        DataTable alldata = null;

        OleDbConnection conn = null;
        private void readxls(string args_xlsname)
        {

            string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + xlsname + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=0\";";
            conn = new OleDbConnection(connstr);
            {
                using (OleDbDataAdapter da = new OleDbDataAdapter("Select * from [Sheet1$]", conn))//
                {
                    da.Fill(ds, "excel");
                }
            }
            alldata = ds.Tables[0];

            //MessageBox.Show(alldata.Rows.Count.ToString());
        }

/**********************************实现treeview和数据的连接********************************************************/

        private void Form1_Load_1(object sender, EventArgs e)
        {

            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "EXCEL文件(*.xlsx)|*.xlsx";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                xlsname = ofd.FileName;
            }
            string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + xlsname;
            readxls(xlsname);

            DataView fist = new DataView(alldata);