Having a little problem generating a dataset. Instead of getting my data, system.data.datarowview pops up in the dropdownlist that I'm trying to generate. Can anyone enlighten me as to what I'm doing wrong? here's my code.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        If Not IsPostBack Then
            'BindState(ddlConame)
            SetInitialFocus(txtCoNumber)



            connAAP = New SqlConnection(Application("connAAP"))

            'Declare command that calls stored proc that retrieves the list of the companies
            Dim objCommand As New SqlCommand("spAAPSelectCompanies", connAAP)

            objCommand.CommandType = CommandType.StoredProcedure

            Dim dsCompany As New DataSet

            Dim adapter As New SqlDataAdapter(objCommand)


            'Load all the companies listboxes with the list of companies
            Try
                connAAP.Open() 'Open the connection
                adapter.Fill(dsCompany)
                connAAP.Close() 'Close the connection
                ddlConame.DataSource = dsCompany
                ddlConame.DataBind() 'Bind the list of the states to the state's listbox
                ddlConame.Items.Insert(0, "Select Company")
                ddlConame.Items.Item(0).Value = ""

            Catch excep As Exception
                Response.Write("<script language=javascript>alert(""Errors Encountered While Loading Companies into Company Listboxes!"");</script>")
            End Try
        End If
        txtconame.Visible = False
        ddlConame.Enabled = True
    End Sub

got it working:)

In case one of us "newbies" (me!) have the same issue, What did you do to get it to work?

Thanks
Martha

It probably has to do with the fact that only a databind was preformed:

ddlConame.DataSource = dsCompany
ddlConame.DataBind() 'Bind the list of the states to the state's listbox

When you need to do something like this:
ddlConame.DataTextField = "<some field in the datasource>"
ddlConame.DataValueField = "<some field in the datasource>"
ddlConame.DataSource = <datasource>
ddlConame.DataBind()

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

 ddlConame.DataSource = dtrState
            ddlConame.DataTextField = "vchcompanyname"
            ddlCoName.DataBind()
            ddlCoName.Items.Insert(0, "Select Company")
            ddlCoName.Items.Item(0).Value = ""
            ddlCoName.Items.Insert(1, "Other..")

Instead of adding these values each time, it would probably be better to add them to the DropDown Item Collection through the IDE and set the AppendDataBoundItems property to true.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========