I am having problems with the following code.

        Dim strConnection As String = ConfigurationSettings.AppSettings("OSF")
        Dim objConnection As New SqlClient.SqlConnection(strConnection)



        objConnection.Open()
        Dim strSQL As String = "SELECT SisterContact.ReligiousName FROM SisterContact INNER JOIN DeathNotice ON SisterContact.SisterUID = DeathNotice.SisterID"
        Dim objAdapter As New SqlClient.SqlDataAdapter(strSQL, objConnection)
        Dim objDataSet As New DataSet()
        objAdapter.Fill(objDataSet, "dtDeathNotice")
        lstDeathNotices.DataSource = objDataSet.Tables("dtDeathNotice")
        lstDeathNotices.DataBind()
        objConnection.Close()

In lblDeathNotices all that is appearing is System.Data.DataReader as the text...when what I want to appear is the data from the objDataSet.

Any Ideas?

Thanks in advance

Typically, when you are going to bind a dataset to a control, you bind it to a repeating control like a Repeater, DataList or DataGrid. A label only will show a text value for a single item, it doesn't know how to bind multiple things.

You are trying to bind multiple rows correct? From you query I would expect multiple rows to be returned. Take a look at the repeater control. It will provide you with a very simple repeatable control you can use for simple repeating text output.

Peter
------------------------------------------------------
Work smarter, not harder.