title: How to Upload CSV file to sql server table using C#?
body: <p>I got the error message below when I tried to upload a csv file to a SQL Server table using C# (csv file has no header).
  Error Message : "A column named '           ' already belongs to this DataTable"</p>
  
  <p>I tried to find some solutions somewhere on the web but I'm  really stuck with it.
  My code :</p>
  
  <pre><code>SqlConnection con = new SqlConnection(@"server=.;Initial Catalog=myDtabase;Integrated Security=SSPI;");
  
              string filepath = @"c:\\my_CSV_file.csv";
  
              StreamReader sr = new StreamReader(filepath);
  
              string line = sr.ReadLine();
              string[] value = line.Split(',');
              DataTable dt = new DataTable();
              DataRow row;
  
              foreach (string dc in value)
              {
                  dt.Columns.Add(new DataColumn(dc));
              }
  
              while (!sr.EndOfStream)
              {
                  value = sr.ReadLine().Split(',');
                  if (value.Length == dt.Columns.Count)
                  {
                      row = dt.NewRow();
                      row.ItemArray = value;
                      dt.Rows.Add(row);
                  }
              }
  
              SqlBulkCopy bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock);
              bc.DestinationTableName = "my_SQLServer_Table";
              bc.BatchSize = dt.Rows.Count;
              con.Open();
              bc.WriteToServer(dt);
              bc.Close();
              con.Close();
  </code></pre>