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

Question

How can i import CSV file in ASPNet C

Mudassar · Accepted Answer

ReferhttpwwwcodeprojectcomArticles290242ImportDatafromaTextorCSVfileintoSQLServe

abhinav · Answer

DProjectsSEOAnalysisSEOAnalysisbinCSVFile5232012csv 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 residesstring strmnth  ddlmonthSelectedValueReplace3434 3434            int stryear  ConvertToInt32ddlyearSelectedValue            string strwebsite  ddlsiteSelectedValue            string strDirectory  ServerMapPath34bin34  34CSVFile34            if DirectoryExistsstrDirectory                DirectoryCreateDirectorystrDirectory            string strFileName  DateTimeNowToShortDateStringReplace3434 3434  34csv34            strFileName  strDirectory  3434  strFileName            if FileExistsstrFileName                FileDeletestrFileName            filexcelSaveAsstrFileName            int j  1            int k  1            SqlConnection conLinq  new SqlConnectionWebCon

Mudassar · Answer

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

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

Company

Explore

Follow us

Contact Us