Excel数据导入数据库操作指南

using System.IO;
using System.Data.OleDb;
using System.Data.SqlClient;


private void button2_Click(object sender, EventArgs e)
        {
            string connsString = "Data Source=(local);Initial Catalog=master;Integrated Security=SSPI";
            OpenFileDialog of = new OpenFileDialog();
            if (of.ShowDialog() == DialogResult.OK)
            {
                TransferData(of.FileName,"sheet1", connsString);
            }
            string sql = string.Format("select * from sheet1");
            SqlConnection conn = new SqlConnection(connsString);
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            label1.Text = dataGridView1.RowCount.ToString();
        }
        public void TransferData(string excelFile, string sheetName, string connectionString)
        {
            DataSet ds = new DataSet();
            try
            {
                string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + excelFile + "';Extended Properties=Excel 8.0;";
                OleDbConnection conn = new OleDbConnection(strConn);
                conn.Open();