Convert System.Data.DataSet to String

[gunnar66]

Hi I pretty new in asp.net and now using web matrix My problem is very easy, but I still can't work it out. I want to read from a record in a Access database, into a string variable. i Have tried this: Sub Button2_Click_1(sender As Object, e As EventArgs) dim ret ret= SjekkStatus("SOMETEXT") Label3.Text = ret End Sub Function SjekkStatus(ByVal navn As String) as System.Data.DataSet 'find record Return dataSet End Function This will not work because the function return a dataset. But i want to convert it to a string. How can i do this. Thx

[Mike Ellison]

Hi there. The DataSet object has a Tables collection, and each DataTable in the collection has a Rows collection of DataRow objects - I think you're looking for something like this:

Sub Button2_Click_1(sender As Object, e As EventArgs)
dim ret as string
ret= SjekkStatus.Tables(0).Rows(0)("SOMETEXT")
Label3.Text = ret
End Sub

Basically, the assignment line says "look inside the DataSet 'SjekkStatus', inside its first table, inside that table's first row, and retrieve the value from the column named 'SOMETEXT'."