using System;
using System.Collections.Generic;
using
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
using Tekla.Structures.Model;
using Tekla.Structures;
using Tekla.Structures.Model.UI;
namespace BEAM_1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog diolog = new OpenFileDialog();
            diolog.Filter = "Excel 文件(*xls)|*xls";
            diolog.FileName = "";
            if (diolog.ShowDialog() == DialogResult.OK)
            {
                string PathString = diolog.FileName.Trim();
                this.listView1.Items.Clear();
                string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source =" + PathString + ";" + "Extended Properties=;'Excel 8.0;HDR=NO;IMEX=1';";
                String strExcel = "select*from[sheet1$]";
                OleDbConnection conn = null;
                try
                {
                    conn = new OleDbConnection(strConn);
                    conn.Open();
                    OleDbCommand cmd = new OleDbCommand(strExcel, conn);
                    OleDbCommand reas = cmd.ExecuteReader();
                  
                    while (reas.Read())
                    {
                        string CeLingDH = reas[0].ToString();
                        string strAssNum = reas[1].ToString();
                        string strParNum = reas[2].ToString();
                        string strSize = reas[3].ToString();
                        string strMaterial = reas[4].ToString();
                        string strGrade = reas[5].ToString();
                        ListViewItem lv = new ListViewItem(CeLingDH);
                        lv.SubItems.Add(strAssNum);
                        lv.SubItems.Add(strParNum);
                        lv.SubItems.Add(strSize);
                        lv.SubItems.Add(strMaterial);
                        lv.SubItems.Add(strGrade);
                        listView1.Items.Add(lv);

                    }
                }
                catch (OleDbException ex)
                {
                    MessageBox.Show("打开错误!" + ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
    }
}