[RESOLVED] To know number of lines in a file

[TATARPRO]

I am usig a dat file in my project and I want to do some calculations base on the number of lines in the file so how can i know the number of lines in that file ?

[Mike Storm]

Explain how you reading that file...

[jmcilhinney]

You basically have no choice but to split the file contents into lines and count them. If you call File.ReadAllLines to get the data as lines already then simply get the Length of the resulting array. If you call File.ReadAllText or the like to get the file contents as a single String then you need to split that String into an array first, e.g.

Dim fileContents = File.ReadAllText(filePath)
Dim lineCount = fileContents.Split({ControlChars.CrLf, ControlChars.Lf}, StringSplitOptions.None)

[TATARPRO]

this is how i want to read it and then put the values inside a datagrid view

Public Sub Open()
        'show the open file dialog
        If MainForm.OpenFileDialog.ShowDialog = DialogResult.OK Then
            'Create a new sheet 
            Dim Nsheet As New ScoresheetForm
            Nsheet.MdiParent = MainForm
            'Call a new streamreader
            Dim reader As New StreamReader(MainForm.OpenFileDialog.FileName, False)
            'Filter out the commas or any other character separator
            Dim filterOut As Char() = ("?':;.,!""").ToCharArray()
            Do While Not reader.EndOfStream()
                'Read each line as a record
                Dim record As String = reader.ReadLine()
                'Seperate all the data items
                Dim data() As String = record.Split(" "c)
                'Populate the datagrid view with the records
                For a As Integer = 0 To Number of lines in file 
                    Nsheet.dgv.Rows.RowCount='Number of lines in file 
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(0)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(1)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(2)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(3)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(4)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(5)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(6)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(7)
                    Nsheet.dgv.Rows(a).Cells(0).Value() = data(8)
                Next
            Loop
            'Set the name and text property to its filename
            ActiveSheet.Text = MainForm.SaveFileDialog.FileName
            ActiveSheet.Name = MainForm.SaveFileDialog.FileName
            Nsheet.Show()
            reader.Dispose()
        End If
    End Sub

[Mike Storm]

To get lines counts jmc just give the answer.
If what you actualy want is rows count

Dagridview.Rows.Count()

Is what you need.
But keep in mind you that if datagridview alows adding rows you need to subtract 1

[TATARPRO]

no thats not what i mean. i am opening the dat file for reading, eah line is a record, the data items are seperated by commas. so it will be read into the data array.so i want to add rows accrding to the number of lines in the file

[Mike Storm]

Then Jmc just give you the answer

[jmcilhinney]

You can't know how many lines are in the file without reading the file. Your code is reading the file line by line and processing each line as it's read. It's simply not possible to know how many lines there are before that process without reading the file twice. You have basically two choices:

1. Read the file into an array first, get the Length of that array and then process the array elements instead of the lines of the file.
2. Process the file as you are and simply increment a variable on each iteration of the loop, then use the variable as the count when you're done processing.

There's no magic solution to this. Programming doesn't exist in a vacuum. Just as you can't magically get the number of items in a list without going through the list outside of programming, so you can't inside either.

[TATARPRO]

i dont understand what you mean

[TATARPRO]

oh sorry i didn't see jmc's post my network is ceasing

[TATARPRO]

oh Jmc i got what you mean thanks