if (CSVFileUpd.HasFile)
{
string filePath = CSVFileUpd.PostedFile.FileName;
string filenameStor = CSVFileUpd.FileName;
string filenameType = System.IO.Path.GetExtension(CSVFileUpd.PostedFile.FileName);
if (filenameType.ToString().Trim().ToLower() == ".csv")
{
System.IO.Stream str = default(System.IO.Stream);
str = CSVFileUpd.PostedFile.InputStream;
System.IO.StreamReader sr = new System.IO.StreamReader(str);
string[] tokens = null;
string line = null;
// string token = null;
//Response.Write("<table>");
System.Data.DataTable dt = new System.Data.DataTable("CSVFileData");
// Define 3 columns
System.Data.DataColumn dc;
dc = new System.Data.DataColumn("Id");
dt.Columns.Add(dc);
dc = new System.Data.DataColumn("Name");
dt.Columns.Add(dc);
dc = new System.Data.DataColumn("Prefix");
dt.Columns.Add(dc);
do
{
line = sr.ReadLine();
if (line == null)
break; // TODO: might not be correct. Was : Exit Do
if (line == "")
{
lblMessage.Text = "File content is empty!";
break;
}
//Response.Write("<tr>");
tokens = line.Split(',');
if (line.Split(',').Length != 3)
{
lblMessage.Text = "Invalid file! File should have 3 columns.";
break;
}
if (tokens[0].Length > 0 && tokens[1].Length > 0)
{
dt.Rows.Add(tokens[0], tokens[1], tokens[2]);
}
} while (!(line == null));
// Response.Write("</table>");
sr.Close();
lblMessage.Text = CSVFileUpload(dt);
}
else
{
lblMessage.Text = "Please select .CSV/.csv file!";
}
}
protected string CSVFileUpload(System.Data.DataTable dtCSV)
{
using (System.Data.SqlClient.SqlBulkCopy bulk = new System.Data.SqlClient.SqlBulkCopy("Data Source=LOCALHOST\MSSQLSERVER;Initial Catalog=Reporting_Testing;Integrated Security=True"))
{
try
{
bulk.DestinationTableName = "MyDetails";
bulk.WriteToServer(dtCSV)
return "CSV File uploaded successfully!";
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
}
