asp.net如何把excel导入到sql

谁知道，最好是实例，测试过的更好，谢谢分享；

---

http://www.92dotnet.com/showtopic-428.aspxC# code:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.IO;


public partial class Excel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

/// <summary>
/// 把Excel中的信息导入到数据库的表中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButASPNET_Click(object sender, EventArgs e)
{
if (this.ExcelFile.PostedFile != null)
{
SqlConnection conn = new SqlConnection("server=.;database=ExcelDB;uid=sa;pwd=123456");
conn.Open();
try
{
string fileurl = typename(ExcelFile);//调用typename方法取得excel文件路径
DataSet ds = new DataSet();//取得数据集
ds = xsldata(fileurl);
int errorcount = 0;//记录错误信息条数
int insertcount = 0;//记录插入成功