excel导入sqlserver

  /// <summary>
    ///  Excle导入
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void BtnImprot_Click(object sender, EventArgs e)
    {

        try
        {
            string filepath = ExcelDom.FileName.ToString();
            string fileType = "";
            string filename = "";
            string realPath = "";
            string ext = filepath.Substring(filepath.LastIndexOf(".") + 1, 3);
            if (ext == "xls")
            {

                if (ExcelDom.HasFile)
                {
                    filename = Guid.NewGuid().ToString() + ExcelDom.PostedFile.FileName.Substring(ExcelDom.PostedFile.FileName.LastIndexOf('.'));
                    realPath = Server.MapPath("../") + @"Images/";
                    filepath = @"../Images/" + filename;
                    realPath += filename;
                    ExcelDom.SaveAs(realPath);
                }
                string sqlconn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

                string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + realPath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
                OleDbConnection cnnxls = new OleDbConnection(mystring);
                OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls);
                DataSet myDs = new DataSet();
                myDa.Fill(myDs);
                cnnxls.Close();
                if (myDs.Tables[0].Rows.Count > 0)
                {
                    string strSql = "";
                    SqlConnection conn = new SqlConnection(sqlconn);
                    conn.Open();
                    SqlCommand myCmd = null;

                    for (int i = 0; i < myDs.Tables[0].Rows.Count; i++)
                    {
                        strSql = "insert   into   TBL_CarPunish (carno,cartype,punishtime,location,ispayed,ispassed,isremote) values   ('";
                        strSql += myDs.Tables[0].Rows[i].ItemArray[0].ToString() + "','";
                        strSql += myDs.Tables[0].Rows[i].ItemArray[1].ToString() + "','";
                        strSql += myDs.Tables[0].Rows[i].ItemArray[2].ToString() + "','";
                        strSql += myDs.Tables[0].Rows[i].ItemArray[3].ToString() + "','";
                        string isornot = "";
                        if (myDs.Tables[0].Rows[i].ItemArray[4].ToString() == "是")
                        {
                            isornot = "true";
                        }
                        else
                        {
                            isornot = "false";
                        }
                        strSql += isornot + "','";
                        if (myDs.Tables[0].Rows[i].ItemArray[5].ToString() == "是")
                        {
                            isornot = "true";
                        }
                        else
                        {
                            isornot = "false";
                        }
                        strSql += isornot + "','";
                        if (myDs.Tables[0].Rows[i].ItemArray[6].ToString() == "是")
                        {
                            isornot = "true";
                        }
                        else
                        {
                            isornot = "false";
                        }
                        strSql += isornot + "')";

                        try
                        {
                            myCmd = new SqlCommand(strSql, conn);
                            myCmd.ExecuteNonQuery();
                        }
                        catch
                        {
                            Response.Write("<script language='javascript'>alert('数据导入失败.');</script>");
                        }
                    }
                    Response.Write("<script language='javascript'>alert('数据导入成功.');</script>");
                    conn.Close();
                    GridBindByCondition();
                }
            }
            else
            {
                Alert("请选择Excel文件模板！");
            }
        }
        catch
        {
            Alert("模板数据有误，请检查！");
        }
    }
    /// <summary>
    /// 导出模板
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void BtnDown_Click(object sender, EventArgs e)
    {
        //保存的文件路径
        string FileName = "模板.xls";       
        string filepath = Server.MapPath(FileName);
        Response.Redirect(FileName);
    }