upload excel file

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.Data.OleDb;
using System.Data;


public partial class Upload_presnews_file : System.Web.UI.Page
{
    string _strKVBDataConnString;

    public string StrKVBDataConnString
    {
        get { return _strKVBDataConnString; }
        set { _strKVBDataConnString = value; }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {

         



          
        }
        catch (Exception ex)
        {
            // lblErrMsg.Text = ex.Message.ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        if (Page.IsValid)
        {
            try
            {
                #region variable
                string FULLNAME, ADDRESS, COUNTRY, STATE, DISTRICT, PINCOD, FOLIO_No, INVESTTYPE, NETDIV, Dividend_Year;
                //DateTime IEPFTRDATE, Date_of_Dividend;
               string IEPFTRDATE, Date_of_Dividend;
                ArrayList _event = new ArrayList();
                #endregion

                string strFolderName = Server.MapPath("iepf/");
                string strFolderPath = "";
                FileUploadiepf.SaveAs(strFolderName + FileUploadiepf.FileName);
                string strFileType = System.IO.Path.GetExtension(FileUploadiepf.FileName).ToLower();
                //        StrKVBDataConnString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
                //@"Data Source=" + strFolderPath + ";" +
                //"Extended Properties=\"Text;HDR=Yes;FORMAT=Delimited\"";
                //StrKVBDataConnString = ("Provider=Microsoft.ACE.OLEDB.12.0;" +
                //  "Data Source=" + strFolderName + FileUploadiepf.FileName + ";" +
                //  "Extended Properties=Excel 12.0 Xml");


                if (strFileType.ToLower() == ".xlsx".ToLower())
                {
                    //strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filetoread + ";" + "Extended Properties=Excel 12.0;";   //Previous Code
                    StrKVBDataConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFolderName + FileUploadiepf.FileName + @";Extended Properties=" + Convert.ToChar(34).ToString() + @"Excel 12.0;Imex=1;HDR=Yes;" + Convert.ToChar(34).ToString(); //Modified Code
                }
                else
                {
                    //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filetoread + ";" + "Extended Properties=Excel 8.0;"; //Previous Code
                    StrKVBDataConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFolderName + FileUploadiepf.FileName + @";Extended Properties=" + Convert.ToChar(34).ToString() + @"Excel 8.0;Imex=1;HDR=Yes;" + Convert.ToChar(34).ToString();   //Modified Code
                    //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filetoread + ";" + "Extended Properties=Excel 8.0;HDR=YES;";
                }

               
                //StrKVBDataConnString = ("Provider=Microsoft.ACE.OLEDB.12.0;" +
                //"Data Source=" + strFolderName + FileUploadiepf.FileName + ";" +
                //"Extended Properties=Excel 8.0 Xml; HDR=YES");
                OleDbConnection objConnection;
                OleDbDataAdapter adapter;
                objConnection = new OleDbConnection(StrKVBDataConnString);
                objConnection.Open();


                //FileUploadiepf.SaveAs( strFolderName+ FileUploadiepf.FileName);

                string strQuery = "SELECT * FROM [Sheet1$]";

                //OleDbConnection objConnection = new OleDbConnection(StrKVBDataConnString);
                //objConnection.Open();
                OleDbDataAdapter EventDataDataAdapter = new OleDbDataAdapter(strQuery, objConnection);

                DataSet EventDataDataSet = new DataSet();
                // Populate the DataSet with the spreadsheet worksheet data
                EventDataDataAdapter.Fill(EventDataDataSet);
                objConnection.Close();

                _event.Add(@"exec sp_stattv_pressnews 'delete'");

                System.Text.StringBuilder EventDataStrB = new System.Text.StringBuilder();

                EventDataStrB.Append("Declare @ID As bigint  ");
                foreach (DataRow drr in EventDataDataSet.Tables[0].Rows)
                {
                    //AMFIcode = drr["AMFIcodenew"].ToString();
                    //eventName = drr["EVENTNAME"].ToString();
                    FULLNAME = drr["FULLNAME"].ToString();
                    ADDRESS = drr["ADDRESS"].ToString();
                    COUNTRY = drr["COUNTRY"].ToString();
                    STATE = drr["STATE"].ToString();
                    DISTRICT = drr["DISTRICT"].ToString();
                    PINCOD = drr["PINCOD"].ToString();
                    FOLIO_No = drr["FOLIO No"].ToString();
                    INVESTTYPE = drr["INVESTTYPE"].ToString();
                    NETDIV = drr["NETDIV"].ToString();
                    try
                    {
                           IEPFTRDATE = Convert.ToDateTime(drr["IEPFTRDATE"]).ToString("yyyy/MM/dd HH:mm:ss");
                    }
                    catch
                    {
                        IEPFTRDATE = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                    }
                    Dividend_Year = drr["Dividend Year"].ToString();
                    try
                    {     Date_of_Dividend = Convert.ToDateTime(drr["Date of Dividend"]).ToString("yyyy/MM/dd HH:mm:ss");
                        //Date_of_Dividend = txtYear + "/" + txtMonth + "/" + txtDate +" 12:00:00 AM";
                    }
                    catch
                    {
                        Date_of_Dividend = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                    }
                    //Response.Write(Date_of_Dividend + "<br/>" + IEPFTRDATE);

                    if (!string.IsNullOrEmpty(FOLIO_No))
                    {
                        _event.Add(@"exec sp_stattv_pressnews 'newsDATAInsert','" + FULLNAME + "','" + ADDRESS + "','" + COUNTRY + "','" + STATE + "','"
                            + DISTRICT + "','" + PINCOD + "','" + FOLIO_No + "','" + INVESTTYPE + "','" + NETDIV
                            + "','" + IEPFTRDATE + "','" + Dividend_Year + "','" + Date_of_Dividend + "' ");
                        //Response.Write(@"exec sp_KVB_IEPF 'IEPFDATAInsert','" + FULLNAME + "','" + ADDRESS + "','" + COUNTRY + "','" + STATE + "','"
                        //   + DISTRICT + "','" + PINCOD + "','" + FOLIO_No + "','" + INVESTTYPE + "','" + NETDIV
                        //   + "','" + IEPFTRDATE + "','" + Dividend_Year + "','" + Date_of_Dividend + "' ");
                    }

                }
                SqlHelper _sqlHelper = new SqlHelper();
                bool flag = false;
                try
                {
                     flag = SqlHelper.MultiTransaction(_sqlHelper.Connection, _event);

                }
                catch (Exception ex)
                {
                    Response.Write(ex.ToString());
                }

                if (flag)
                {
                    Response.Write("File Imported Successfully: strFileNameToImport <br/>");
                }
                else
                {
                    Response.Write("Error Occurred While Importing Data: <br/>");
                }




            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
        }
    }
}