More help required!
I have a table being imported into my VB application that has 3 columns. I have written code to import the table, and have written code to display on the first column (country) in a list view.
What I want to do now is have the user select / highlight an item in the list view, and have the third column (currency) related to that selected country appear in a text box when a button is clicked.
Here's the code I've written that successfully imports the data and displays the first column:
Private Sub frmCountry_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim dataCountry As New DataTable() Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=E:\globexdata\globex.mdb" Dim sqlString As String = "SELECT * FROM countries" Dim dataAdapt As New OleDb.OleDbDataAdapter(sqlString, connectionString) dataAdapt.Fill(dataCountry) dataAdapt.Dispose() Dim qtyRows As Integer = dataCountry.Rows.Count For List = 0 To qtyRows - 1 lstCountryview.Items.Add(dataCountry(List)(0)) Next End Sub
Should I perhaps use something other than a list view?
Sorry to ask for help yet again, but I'm not used to struggling with IT stuff...yet when it comes to VB I've lost my computing mojo!!