Solved

Drop Down List Displays system.data.datarowview

Posted on 2009-04-03
3
660 Views
Last Modified: 2013-11-26
I'm trying to populate a drop down list with one column of a sql view but instead I'm getting system.data.datarowview on every row. I've read about the column names etc. being incorrect etc and have checked that. I've also tried using dbo.vDepts and vDepts for the view name but it made no difference.

Thanks in advance!!
Imports System

Imports System.Collections

Imports System.Data

Imports System.Net.Mail

Imports System.Net

Imports System.IO

Imports System.Security.Permissions

Imports System.Text

Imports System.DirectoryServices
 

Partial Public Class _Default

    Inherits System.Web.UI.Page

    Dim strUser As String

    Dim strDate As Date

    Dim DS As System.Data.DataSet
 

 Private Sub FillDropdown()

        Dim sConn As Data.SqlClient.SqlConnection

        Dim sComm As Data.SqlClient.SqlCommand

        Dim sAdapt As Data.SqlClient.SqlDataAdapter
 

        sConn = New Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("MyConnection2").ConnectionString)

        sComm = New Data.SqlClient.SqlCommand("Select Depts from dbo.vDepts", sConn)

        sAdapt = New Data.SqlClient.SqlDataAdapter(sComm)

        sConn.Open()
 

        DS = New DataSet

        sAdapt.Fill(DS)

        sComm.ExecuteReader()

        DropDownList10.DataSource = DS

        DropDownList10.DataBind()

        sConn.Close()
 

    End Sub

Open in new window

0
Comment
Question by:JB4375
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
oobayly earned 500 total points
ID: 24061480
You should set the DataTextField property for the drop down list to the column you wish to display:
DropDownList10.DataTextField = "Depts "

Open in new window

0
 
LVL 1

Author Comment

by:JB4375
ID: 24061849
It works!!
Thanks Oobayly!!
0
 
LVL 1

Author Closing Comment

by:JB4375
ID: 31566313
Right on the money the first time!! Thanks!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now