VB.NET databind to drop down list

I have a stored procedure in SQL Server that returns a list of names that I
would like to bind to a drop down list. This is the code I have, but it is
not working correctly. The drop down contains System.Data.DataRowView


Dim ConString As String = ConfigurationSettings.AppSettings("cs")
Dim myCon As New SqlConnection(ConString)

Dim CmdTextAssignedToListing As String = "usp_GetAssignedToNames"
Dim CmdAssignedToListing As New
SqlDataAdapter(CmdTextAssignedToListing, myCon)

Dim dsAssignedToListing As New DataSet
'fill drop down with user names
CmdAssignedToListing.Fill(dsAssignedToListing)

'Databind to the Drop Down
DropDownAssignedTo.DataSource = dsAssignedToListing
DropDownAssignedTo.DataBind()

Any help is appreciated.

.

Relevant Pages

  • Re: Need help processing multiple result set via stored procedure
    ... But I still got an ASSERT occuring in the Bind() ... assuming that because the way the stored procedure is written, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Multiple Recordset from a Stored Procedure
    ... > Say you have a stored procedure in SQL Server which looks like this ... I am absolutely intrigued by this technique. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Stored Procedure
    ... I have a stored procedure on the SQL server - ... I created a Access database linking some tables from the database on the ... How can I execute the stored procedure from Access. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • calling stored procedure in ms sql server?
    ... how do i use the perl dbi module to call stored procedure in ms sql server? ... Prev by Date: ...
    (perl.dbi.users)
  • Visual Studio 2003 to SQl Server 2000
    ... Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003? ... Smith ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)