将excel表格中的数据导入到SQL中

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

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

    }
    private DataSet GetOleData()
    {
        OleDbConnection objConn = null;
        DataSet ds = new DataSet();
       

        string strConn = "Provider=Microsoft.Jet.OleDB.4.0;Data Source=C:\\test.xls;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
        objConn = new OleDbConnection(strConn);
        objConn.Open();
        string strSql = "select   *   from   [Sheet1$]";
        OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
        OleDbDataAdapter sqlada = new OleDbDataAdapter();
        sqlada.SelectCommand = objCmd;
        sqlada.Fill(ds, "MyRecords");

        objConn.Close();

        return ds;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        DataSet btn_ds = GetOleData();

        string sConnectSql = string.Format("server=.;database=Dataset;UID=sa;Password=1111;");
        SqlConnection sqlconn = new SqlConnection(sConnectSql);
        sqlconn.Open();
        SqlCommand com = sqlconn.CreateCommand();

        foreach (DataRow Rows in btn_ds.Tables["MyRecords"].Rows)
        {
            string adaptersql = "insert into excel values ('" + Rows[0] + "','" + Rows[1] + "','" + Rows[2] + "','" + Rows[3] + "')";
            com.CommandText = adaptersql;
            int i = Convert.ToInt32(com.ExecuteScalar());
            if (i >= 0)
            {
                //Response.Write("<script language=javascript>alert('数据导入成功！')</script>");

            }
            else
            {
                Response.Write("<script language=javascript>alert('添加出错，请检查！')</script>");
            }

            string str_row = Rows[0].ToString().Trim();
            Response.Write(str_row);
        }
 /*       string sConnectSql = string.Format("server=.;database=Dataset;UID=sa;Password=1111;");
        SqlConnection sqlconn = new SqlConnection(sConnectSql);
        string adaptersql = "insert into excel * values ('" + Rows[0] + "','" + Rows[1] + "','" + Rows[2] + "','" + Rows[3] + "')";
        SqlCommand com = con.CreateCommand();
        com.CommandText = adaptersql;
        int i = Convert.ToInt32(com.ExecuteScalar());
        if (i >= 0)
        {
            //Response.Write("<script language=javascript>alert('数据导入成功！')</script>");

        }
        else
        {
            Response.Write("<script language=javascript>alert('添加出错，请检查！')</script>");
        }

        */

    }
}