[RESOLVED] [2005] Listbox Exporting And Printing Problem

[Tddupre]

My list box is getting it's data from an access database.

I try to export the contents into a txt file and I get...
System.Data.DataRowView
System.Data.DataRowView
System.Data.DataRowView
System.Data.DataRowView
System.Data.DataRowView

I get the same thing when I try to print it out.

[jmcilhinney]

You are presumably just looping through the items and calling ToString on them. If your ListBox is bound to a DataTable then each item is a DataRowView. What you're seeing IS the result of calling ToString on a DataRowView. If what you actually want is the text displayed in the ListBox for each item then you need to loop through the item indexes and call GetItemText for each one. The documentation for the ListBox class could have told you that and that's the first place you should have looked. The documentation for the type or member you're using and having trouble with should always be the first thing you look at.

[Tddupre]

Sorry I am pretty much a noob, but I got it somewhat working, but now it exports/prints only the first entry in the list box.

I've looked for solutions but couldn't find any

Me.lstAccounts.DataSource = ds.Tables(0)
            Me.lstAccounts.DisplayMember = "Username"
            Me.lstAccounts.Text = Me.lstAccounts.GetItemText(Me.lstAccounts.DataSource)

[jmcilhinney]

If you were getting multiple lines of output before you must have been using a loop. You still need to use a loop. You need to call GetItemText for each item in the control. NOT for the DataSource, for each item in the control. Take the highlight as a clue as to what sort of loop you need.

[Tddupre]

If you were getting multiple lines of output before you must have been using a loop. You still need to use a loop. You need to call GetItemText for each item in the control. NOT for the DataSource, for each item in the control. Take the highlight as a clue as to what sort of loop you need.

Thx I get what u r saying, but i tried a couple of things and i can't get the loop to work properly.

[Crushinator]

Hello,

If possible, could you please post what code you have so far? Someone here will be able to help you more if they see what you are trying to do versus what you are actually doing.

Basically from what I see, you have a table. ds.tables(0)
This table has rows. You need to loop through these rows, reading the data you want off of the row.

Very short example of what I'm thinking might be your root issue:

dim dt as new DataTable = ds.tables(0)

For Each dr as DataRow In dt.rows '// This is the For Each loop what JM was implying to

'//Read from the row and assign whatever you need to here

Next dr

[Tddupre]

Hello,

If possible, could you please post what code you have so far? Someone here will be able to help you more if they see what you are trying to do versus what you are actually doing.

Basically from what I see, you have a table. ds.tables(0)
This table has rows. You need to loop through these rows, reading the data you want off of the row.

Very short example of what I'm thinking might be your root issue:

dim dt as new DataTable = ds.tables(0)

For Each dr as DataRow In dt.rows '// This is the For Each loop what JM was implying to

'//Read from the row and assign whatever you need to here

Next dr

I just cant figure out how to loop the GetItemText Properly And What The GetItemText should be assigned to e.g Datasource

[Crushinator]

Oh, I thought you were trying to assign to the listview, not read from it. Sorry, that was my fault.

Hmm, could you do something like:

dim fs as new IO.FileStream("C:\", FileMode.CreateNew)
dim sw as new IO.StreamWriter(fs)

For i As Integer = 0 To (lstAccounts.Items.Count - 1)

'//Get whatever values and output however you need
sw.writeline(lstAccounts.items(i).subitems(0).text)

Next i

sw.close()
fs.close()

Not sure if something like this is what you're looking for.

[Tddupre]

http://kyrepairs.com/AM.wmv
^^
Right Click Save As

Video Explaining what is wrong and what im confused with.

[jmcilhinney]

For Each item As Object In myListBox.Items
    MessageBox.Show(myListBox.GetItemText(item))
Next

As the name suggests, GetItemText gets the text for an item. What you do with that text, i.e. String object, is up to you.