Import CSV file to database using ASP.NET

See more:

SQL-Server

SQL-Server-2008

Hi,

I am trying to import values from CSV to SQL server 2008 Database

I am inserting 3 columns to table.
Two values from CSV file. One value is from program.
When I run my code, rows are inserted with null values

But my column count is showing as 3.

Below is my code

i = 0;
fil="Desktop";
string line=string.Empty;
StreamReader sr = new StreamReader(filepath);
line = sr.ReadLine();
line = sr.ReadLine();

string[] value = line.Split(',');
DataTable dt = new DataTable();
DataRow row;
i=0;
foreach (string dc in value)
{
    if (i == 0)
    {
        dt.Columns.Add(new DataColumn(fil));
       // dt.Columns.Add(new DataColumn(DateTime.Now.ToString()));
        dt.Columns.Add(new DataColumn(dc));
        i++;
    }
}
string value1;
while ( !sr.EndOfStream )
{
    value1 = sr.ReadLine().Split(',')[0];
    value = new string[] { value1 };
    dt.Columns.Add(new DataColumn(value1));
    if(value.Length == (dt.Columns.Count)-3)
    {
        row = dt.NewRow();
        row.ItemArray = value;
        dt.Rows.Add(row);
    }
}
SqlBulkCopy bc = new SqlBulkCopy(con.ConnectionString,    SqlBulkCopyOptions.TableLock);
bc.DestinationTableName = "mssp_eps_compliance_report";
bc.BatchSize = dt.Rows.Count;
con.Open();
bc.WriteToServer(dt);
bc.Close();
con.Close();

Please help.

Thanks in advance.