Display DataSet data

[agibsonsw]

Hello. VB Express 2010.
The following fragment is supposed to display the data from a DataSet following inserting of a new record, but doesn't work.

strSql = "SELECT StaffID, FirstName, LastName FROM dbo.Staff WHERE StaffID = " & CInt(txtID.Text)
da = New SqlDataAdapter(strSql, cnn)
da.Fill(ds, "NewMember")
txtOutput.Text = ds.ToString

I also tried ds.Tables("NewMember").ToString.
The new staff record is inserted correctly using the ID number in the txtID textbox.

How can I output the data from a DataSet to a TextBox? Thanks, Andy.

[HansV]

I don't know anything about VB Express 2010, but aren't you supposed to specify a table, row and column?

txtOutput.Text = ds.Tables(0).Rows(0).Item(0).ToString

[agibsonsw]

Hello.
That works fine. I was following an example from Teach Yourself SQL Server Express by Alison Balter. It's a disappointing book as it has lots of
coding mistakes and is poorly organised. Thanks, Andy.