3
Contributors
10
Replies
26
Views
3 Years
Discussion Span
Last Post by srina
Featured Replies
  • Read [an online tutorial](http://mysearch.avg.com/search?q=vb.net+beginners+tutorial&sap=hp&lang=en&mid=db03133e5f194dcda6a432aca5b3bf0e-baa57dcead4b7a5e84023a7a15763c2ac4851706&cid=%7BCFC7EC74-63BD-4D63-AB0D-84A811600F4A%7D&v=15.0.0.2&ds=hk018&d=4%2F15%2F2013+8%3A04%3A14+AM&pr=sa&snd=hp&sap_acp=1&pid=safeguard&sg=1) that teaches you how to read text files. Once you understand how to do that the rest is simple (just add each line to the list box) Read More

0

Thank you for your response..I'm in extreme help,completely failing ...It is a csv file and I'm just trying to load the first item in listbox...this is what I have so far
I used the load procedure
then for I as int = 0 to n
line= books(I)
data= line.split(","c)
booklist(I).title= data(0)
..... and for the rest of the categories I needed
next
dim query= from headings in booklist
order by headings.title
select headings
for each headings in query
listbox.items.add(headings.title)

0

You can use a For Each Loop to iterate through the array.

For Each record As String In data
    ' Do some data processing...
Next
0

that's what I did...I think.its posted above.still not working..im stuck...there's definitely something im missing just don't know what

0

In your LINQ statement, there is no need to use Select (in c# you have to). since you are only pulling records of the same type.

I've also noticed you are pulling from one heading. since you are declare a heading as the first index of data.

data= line.split(","c)
booklist(I).title= data(0)

The foreach statement is confusing. You are using headings in the Linq statement and in the foreach statement. I would use something more like this for the Linq statement.

Dim query = From heading In data
            Order By heading.title

Then the for each loop should work.

For Each h as heading in query
    ' I'm doing data processing...
Next
0

there four other categories of data (two are integers)on the same line each separated by a comma...
I guess that's why I thought I had to use the select statement...im basically teaching myself this from the web,youtube, and forums like this...and I still have no clue..everytime I debug...it says indexoutofrange

0

Meaning that the index you are tryng to reach does not exist.

For example your For loop:

for I as int = 0 to n

means that 'I' will increment to the next value each time the condition is ran. If I use I as a variable in the loop for example:

For I as integer = 0 to 10
    Console.WriteLine (MyArray(I)) ' write the record at the index of 'I' to console.
Next

Now, if I have only 10 records in the array, the last index would be 9 (arrays are 0 based meaning they start at 0 and not 1). The loop will error out since the index would be higher then the number of indices in the array.

The error will be an 'IndexOutOfRange' exception; or the index I want does not exist in the array I am iterating through.

Edited by Maligui

0

I left out the part before the for loop.. dim n as books.count-1(thinking that would take me to the end of the file) which would be the counter...

0

I think this is something like you were working on.

Dim line As String
Dim data() As String

'declare the number of books variable, then assign it.
Dim n As Integer = books.count - 1

' For Loop
' This loop will run until 'I = n' or while 'I = (books.count -1)'
For I as Integer = 0 to n
    line = books(I)
    data = line.split(","c) ' divide the string by a comma, 
                            ' and assign them to the string array 'data'
Next

' now we will iterate through the data array and pull the records.
For Each s As String in data
    Console.WriteLine(s)
Next
0

its weird because thats what the code looks like...with the exception of line 16..when I tried that it didnt work...I must be missing something somewhere

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.