DataTable dt = new DataTable();
string line = null;
int i = 0;

using (StreamReader sr = File.OpenText(@"d:\Test.csv"))
{
 while ((line = sr.ReadLine()) != null)
  {
    string[] data = line.Split(',');
    if (data.Length > 0)
    {
     if (i == 0)
     {
       foreach (object item in data)
       {
         dt.Columns.Add(new DataColumn());
       }
       i++;
      }
      DataRow row = dt.NewRow();
      row.ItemArray = data;
      dt.Rows.Add(row);
     }
    }
   SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
  con.Open();

   SqlBulkCopy s = new SqlBulkCopy(con);
   s.DestinationTableName = "Test3";
   s.WriteToServer(dt);
   s.Close();
   con.Close();