Pull data from Txt file?

[sentinelace]

I have a file that gets copied every second over network to update a txt file located at c:\folder\data.txt.

The txt file contains data like:

name
serial
in
out
test

All in a row. Currently I am using VB code to pull from this file into excel. I would like to pull this into C#. What is the best way to approach this? I have to use the offset command in VB to get the data set in the proper cells.

[jmcilhinney]

Please provide the actual format of the file, otherwisd we're just guessing.

[sentinelace]

Here is an example of the txt. I want to lay this out as if it where in excel so I can do conditional formatting, etc.

[Blagojce]

First create object where you'll store data from the file.
Next read each line(with TextReader) and add in appropriate property in object.

[sentinelace]

I honestly have no clue how tO do that. Any chance you can provide code?

[pukisoft]

I honestly have no clue how tO do that. Any chance you can provide code?

Here buddy: http://msdn.microsoft.com/en-us/library/db5x7c0d.aspx

[sentinelace]

I see two boxes of code. None that specify where the txt file actually resides. Also I need this in form view or any clean view to display on a monitor. A console window will not work.

[Blagojce]

StreamReader("TestFile.txt") - This means the file is in the same directory with application.
In Windows Forms you can select file with OpenFileDialog.
In the example with open file dialog you have how to read content from file and put in stream. At the bottom you have and RichTextBox for displaying results.

[sentinelace]

is form view the best option I want to make it look similar to an excel sheet?

[Blagojce]

You can use datagridview in form to display the results.