How do I output the results of a LINQ command to a text file?

Question

 var arrResults = Array1.Join(Array2, x => x.ID, x => x.ID, (first, second) => new
            {
                IDRecord = first.ID,
                Count1 = first.Count,
                Count2 = second.Count,
            })
            .OrderBy(item => item.IDRecord).ToArray(); 

            // bind & display results in datagrid
            dataGridView1.DataSource = arrResults;

My above code does exactly what I want it to, and shows the results in a dataGrid control. Now, I'd like to export the results to a text file, C:\output.txt, instead. How do I do this?

My previous attempts usually involve getting errors that say "cannot convert from 'string' to System.Collections.Generic.IEnumerable".

Servy · Accepted Answer · 2013-04-05 20:35:04Z

2

First convert the results to strings:

var lines = arrResults.Select(record => 
    record.ID + " " + record.Count1 + " " + record.Count2);//todo fix formatting

Then write them all to a file.

File.WriteAllLines("file.txt", lines);

answered Apr 5, 2013 at 20:35

Servy

204k27 gold badges347 silver badges470 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bash.d · Accepted Answer · 2013-04-05 20:38:20Z

1

Use a System.IO.Streamwriter to write to file

using(StreamWriter sw = new StreamWriter(@"C:\output.txt")){
   foreach(var s in arrResults)
       sw.WriteLine(s);

}

See here for reference.

answered Apr 5, 2013 at 20:38

bash.d

13.3k3 gold badges33 silver badges42 bronze badges

Collectives™ on Stack Overflow

How do I output the results of a LINQ command to a text file?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related