[2005] Problem with displaying data in labels

[maco]

Hi!

When I run this code all the dataadapter is displaying is the first item in my database. None of the other is displayed. I have a database with the following values: ID, Title, Length, Actors, Description, Rating, Genre and Location.

My code looks like this:

    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged





        Try

            'Open connection
            cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=movies.mdb;")
            cn.Open()


            Dim ds As New DataSet
            Dim da As OleDb.OleDbDataAdapter

            str = "SELECT * FROM moviedata WHERE Title = '" & ComboBox1.Text & "'"

            da = New OleDb.OleDbDataAdapter(str, cn)
            da.Fill(ds, "TitleResult")


            Label2.Text = "Title: " + ds.Tables("TitleResult").Rows(0).Item(1)
            Label12.Text = "Length: " + ds.Tables("TitleResult").Rows(0).Item(2) + " min"
            Label13.Text = "Actors: " + ds.Tables("TitleResult").Rows(0).Item(3)
            Label14.Text = "Description: " + ds.Tables("TitleResult").Rows(0).Item(4)
            Label15.Text = "Genre: " + ds.Tables("TitleResult").Rows(0).Item(6)
            Label16.Text = "Location: " + ds.Tables("TitleResult").Rows(0).Item(7)


            cn.Close()
        Catch ex As Exception
            MessageBox.Show(ex.ToString())


        End Try



    End Sub

Also when I try to exit the program I get this error:

"There is no row at Index 0" - Any way to avoid that?

Thanks!

[maco]

Hold on! Got it working somehow!

But 2 problems remain.

My last question in the previous post about the error.

And also, I can't display length in a label because it says:

"Conversation from string "Length: " to type 'Double' is not valid. ----> System.FormatException: Input string was not in correct format"

[maco]

Got that thing to work to, changed it from Double to Text in the database, doesn't matter which one it is.

But that last question still?