Import CSV file to SQL Server Database using ASP.Net and C#

Refer

http://www.codeproject.com/Articles/290242/Import-Data-from-a-Text-or-CSV-file-into-SQL-Serve

'D:\Projects\SEOAnalysis\SEOAnalysis\bin\CSVFile\5_23_2012.csv' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

string strmnth = ddlmonth.SelectedValue.Replace("%", "");
            int stryear = Convert.ToInt32(ddlyear.SelectedValue);
            string strwebsite = ddlsite.SelectedValue;
            string strDirectory = Server.MapPath("~/bin") + @"\CSVFile";
            if (!Directory.Exists(strDirectory))
                Directory.CreateDirectory(strDirectory);

            string strFileName = DateTime.Now.ToShortDateString().Replace(@"/", "_") + ".csv";

            strFileName = strDirectory + @"\" + strFileName;

            if (File.Exists(strFileName))
                File.Delete(strFileName);


            filexcel.SaveAs(strFileName);



            int j = 1;
            int k = 1;

            SqlConnection conLinq = new SqlConnection(WebConfigurationManager.ConnectionStrings["MyConnection"].ToString());
            connection con = new connection();

            try
            {
                DataTable dtExcel = new DataTable();

                //string SourceConstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=NO;IMEX=1\"";
                string SourceConstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+ strFileName +" ;Extended Properties=\"text; HDR=Yes; IMEX=1 \"";
                OleDbConnection conn = new OleDbConnection(SourceConstr);
                conn.Open();

The path must exist on the machine where the application is running