listview problem

[amber]

I have a listview (lstvwAmend) (containing 2 columns) that is populated by a filtered dataview (dvRPA) that is based on a dataset (dsRPAmend1) pulling data from a SQL Server database
This dataview will contain 0-10 records.
The dataview is displaying field 1 & field 2 from my dataview
When a user clicks on one of the items in the listview, I want to set the value of a textbox on my form to equal field 3 from the same row in my dataview
I can't seem to make this work

I'm not sure if this is relevant, but pasted below is the code that populates my listbox

lstvwAmend.Data Bindings.Clear(
lstvwAmend.Refr esh(

DsRPAmend1.Clea r(
SqlDA_RPAmend.F ill(DsRPAmend1

dvRPA = New DataVie

With dvRP
.Table = DsRPAmend1.Tabl es("TDT_ROAD_PE RMIT_AMEND"
.RowFilter = "ID_ROAD_PE RMIT = '" & txtRPID.Text & "'
.Sort = "NUM_AMENDM ENT
End Wit

'create listview to display amendment number and associated C
Dim i As Intege

lstvwAmend.Item s.Clear(
lstvwAmend.Refr esh(
For i = 0 To dvRPA.Count -
Dim LVI As New ListViewIte
LVI.Text = dvRPA.Item(i).I tem(3
If IsDBNull(dvRPA. Item(i).Item(5) ) The
Els
LVI.SubItems.Ad d(dvRPA.Item(i) .Item(5)
End I
lstvwAmend.Item s.Add(LVI
Nex

Any suggestions
Thanks
amber

[Claes Bergefall]

Store each item from dvRPA into the Tag property of the
corresponding ListViewItem, i.e. add this to your loop:
LVI.Tag = dvRPA.Item(i)

Then add a handler to the SelectedIndexCh anged event
from the listview and extract the data that you want

/claes

"amber" <an*******@disc ussions.microso ft.com> wrote in message
news:4F******** *************** ***********@mic rosoft.com...

I have a listview (lstvwAmend) (containing 2 columns) that is populated by a filtered dataview (dvRPA) that is based on a dataset (dsRPAmend1) pulling
data from a SQL Server database. This dataview will contain 0-10 records.
The dataview is displaying field 1 & field 2 from my dataview.
When a user clicks on one of the items in the listview, I want to set the value of a textbox on my form to equal field 3 from the same row in my
dataview. I can't seem to make this work.

I'm not sure if this is relevant, but pasted below is the code that populates my listbox:
lstvwAmend.Data Bindings.Clear( )
lstvwAmend.Refr esh()

DsRPAmend1.Clea r()
SqlDA_RPAmend.F ill(DsRPAmend1)

dvRPA = New DataView

With dvRPA
.Table = DsRPAmend1.Tabl es("TDT_ROAD_PE RMIT_AMEND")
.RowFilter = "ID_ROAD_PE RMIT = '" & txtRPID.Text & "'"
.Sort = "NUM_AMENDM ENT"
End With

'create listview to display amendment number and associated CP
Dim i As Integer

lstvwAmend.Item s.Clear()
lstvwAmend.Refr esh()
For i = 0 To dvRPA.Count - 1
Dim LVI As New ListViewItem
LVI.Text = dvRPA.Item(i).I tem(3)
If IsDBNull(dvRPA. Item(i).Item(5) ) Then
Else
LVI.SubItems.Ad d(dvRPA.Item(i) .Item(5))
End If
lstvwAmend.Item s.Add(LVI)
Next

Any suggestions?
Thanks,
amber

[amber]

Thanks for your help
I'm still doing something wrong
I have added the line
LVI.Tag = dvRPA.Item(i
and left the LVI.Text = dvRPA.Item(i) or else the text wouldn't display
So it all looks good, but the textbox still won't update
My code for the SelectedIndexCh anged event is
Me.txtAmend.Dat aBindings.Clear (
Me.txtAmend.Dat aBindings.Add(" text", dvRPA, "ID_ROAD_PERMIT _AMEND"
my dataview (dvRPA) is declared at the class level

I do this exact same thing with my listboxes, with the exact same code, and it works great, but with my listview,
when the listview item is selected, no matter how many items there are, or which one is selected,
the textbox (txtAmend) is always populated with the item that is associated with the first item in the listview

Any ideas

Thanks
Amber

[Claes Bergefall]

Do you have to use databinding?

Private Sub OnSelectedIndex Changed()
If myListView.Sele ctedItems.Count = 0 Then
txtAmend.Text = String.Empty
Else
Dim o as myDataType = CType(myListVie w.SelectedItems (0).Tag,
myDataType)
txtAmend.Text = o.Item(3).ToStr ing
End If
End Sub

/claes
"amber" <an*******@disc ussions.microso ft.com> wrote in message
news:99******** *************** ***********@mic rosoft.com...

Thanks for your help.
I'm still doing something wrong.
I have added the line:
LVI.Tag = dvRPA.Item(i)
and left the LVI.Text = dvRPA.Item(i) or else the text wouldn't display.
So it all looks good, but the textbox still won't update.
My code for the SelectedIndexCh anged event is:
Me.txtAmend.Dat aBindings.Clear ()
Me.txtAmend.Dat aBindings.Add(" text", dvRPA, "ID_ROAD_PERMIT _AMEND")
my dataview (dvRPA) is declared at the class level.

I do this exact same thing with my listboxes, with the exact same code, and it works great, but with my listview, when the listview item is selected, no matter how many items there are, or which one is selected, the textbox (txtAmend) is always populated with the item that is associated with the first item in the listview.
Any ideas?

Thanks,
Amber