C# excelµ¼Èësql server

ÇóÒ»¸öÍêÕûµÄexcelµ¼Èësql serverµÄ³ÌÐò£¬ÓÃwinformµÄ£¬Óеĸø¸ö²Î¿¼²Î¿¼£¬Ð»Ð»

---

www.51aspx.comÉÏÃæɶ¶¼ÓУ¬×Ô¼ºÈ¥Ï¡£¡£¡£Ë³Â·½Ó·Ö

---

ÍøÉÏÓа¡ 51aspx¿ÉÒÔÏÂÔØ

---

ÒýÓÃ

ÍøÉÏÓа¡ 51aspx¿ÉÒÔÏÂÔØ

ÄÇÊÇÓÃweb¿ØÖÆ̨µÄ
ÎÒÊÇÏëÓÃwinformµÄ

---

¸Ä³ÉFileOpenDialog¿Ø¼þ¾Í¿ÉÒÔÁË

---

ÒýÓÃ

¸Ä³ÉFileOpenDialog¿Ø¼þ¾Í¿ÉÒÔÁË

²»ÓÃÁ¬½ÓÊý¾Ý¿âµÄÂð£¿

---

C# code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace ExcelToSql
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

//°Ñdatatable¶ÁÈësqlÊý¾Ý¿â
private void btnImport_Click(object sender, EventArgs e)
{
string _strExcelFileName = @"D:\³ÌÐò\ExcelToSql\ÇøÓò.xls";
DataTable dtExcel = ExcelToDataTable(_strExcelFileName, "Sheet1");
for (int i = 0; i < dtExcel.Rows.Count; i++)
{
InsertDataToSql(dtExcel.Rows[i][0].ToString(), dtExcel.Rows[i][1].ToString(), int.Parse(dtExcel.Rows[i][2].ToString(