title: C# Export Active Directory to CSV to include all users & include commas
body: <p>I am working on exporting a CSV file with a list of the Active Directory users at my company. I would like the CSV file to show the employee ID, name, email, and phone number for each user. While I am able to generate a list of the users within the CSV file, I run into 2 problems: <strong>1) the CSV file only seems to output a list of 1,000 users</strong> (while there should be closer to 3,000 users) and <strong>2) I can't figure out how to identify values that have commas within them to stay in one column, without being pushed to the next</strong>. For example, some employee names have a comma within the field. I want it to be read as (the | represents the column break):</p>
  
  <p>123456 | John Smith, ABC | jsmith@company.org | (123)456-7890</p>
  
  <p>instead of:</p>
  
  <p>123456 | John Smith | ABC | jsmith@company.org | (123)456-7890</p>
  
  <p>I know for the latter issue, it involves adding quotes around the field "name", but I'm not sure how to do it or where it belongs. Here is my code for this</p>
  
  <pre><code>    //creates a data table for Active Directory information
      public void AD_Table()
      {
          // **Query all of the users within the AD**            
          DirectoryEntry de = new DirectoryEntry(ConnectToDomain());
          SearchResultCollection results;
          DirectorySearcher ds = null;
  
          ds = new DirectorySearcher(de);
          ds.PropertiesToLoad.Add("employeeID");
          ds.PropertiesToLoad.Add("name");
          ds.PropertiesToLoad.Add("mail");
          ds.PropertiesToLoad.Add("telephoneNumber");
  
          //filters out inactive or invalid employee user accounts
          ds.Filter = "(&amp;(objectCategory=person)(objectClass=user)(employeeID&gt;= 000001)(employeeID&lt;= 999999))";
          results = ds.FindAll();
  
  
  
          //header columns for Data Table
          DataTable dt = new DataTable();
          dt.Columns.Add("Employee ID", typeof(string));
          dt.Columns.Add("Full Name", typeof(string));
          dt.Columns.Add("Office Email", typeof(string));
          dt.Columns.Add("Office Phone", typeof(string));
  
  
          foreach (SearchResult sr in results)
          {
              DataRow dr = dt.NewRow();
              DirectoryEntry entry = sr.GetDirectoryEntry();
              if (entry.Properties["employeeID"].Count &gt; 0)
                  dr["Employee ID"] = entry.Properties["employeeID"].Value.ToString();
              if (entry.Properties["name"].Count &gt; 0)
                  dr["Full Name"] = entry.Properties["name"].Value.ToString();
              if (entry.Properties["mail"].Count &gt; 0)
                  dr["Office Email"] = entry.Properties["mail"].Value.ToString();
              if (entry.Properties["telephoneNumber"].Count &gt; 0)
                  dr["Office Phone"] = entry.Properties["telephoneNumber"].Value.ToString();
              dt.Rows.Add(dr);
          }
  
          string fullFilePath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"\\LSSUpdaterVM\AD\Update\ADWorkEmailPhone.csv");
          //move datatable into CSV
          CreateCSVFile(dt, fullFilePath);
  
      }
  
  
      //creating the CSV file with the AD user info
      public void CreateCSVFile(DataTable dt, string strPath)
      {
          try
          {
              StreamWriter sw = new StreamWriter(strPath, false);
              int columnCount = dt.Columns.Count;
              for (int i = 0; i &lt; columnCount; i++)
              {
                  sw.Write(dt.Columns[i]);
                  if (i &lt; columnCount - 1)
                  {
                      sw.Write(",");
                  }
              }
              sw.Write(sw.NewLine);
  
              foreach (DataRow dr in dt.Rows)
              {
                  for (int i = 0; i &lt; columnCount; i++)
                  {
                      if (!Convert.IsDBNull(dr[i]))
                      {
                          sw.Write(dr[i].ToString());
                      }
                      if (i &lt; columnCount - 1)
                      {
                          sw.Write(",");
                      }
                  }
                  sw.Write(sw.NewLine);
              }
              sw.Close();
          }
          catch (Exception ex)
          {
              throw ex;
          }
      }
  
  }
  </code></pre>
  
  <p>If someone sees where the problem(s) is, please let me know! Any, and all help will be much appreciated! Thanks in advance.</p>