Do you need to set your DataTextField and DataValueField?
...
DropDownList1.DataSource=ds.Tables("Titles").DefaultView
DropDownList1.DataTextField = "fieldname"
DropDownList1.DataValueField = "fieldname2"
DropDownList1.DataBind()
...
Andrew
-----Original Message-----
From: Michael Gerholdt [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 7:58 AM
To: dotnet
Subject: bind to DropDownList
<code below>
I can't find what I'm doing wrong here. Can someone help me understand
why this code produces 6 rows of:
<option
value="System.Data.DataRowView">System.Data.DataRowView</option>
instead of the actual values I'm looking for? The number of these
returned appears to reflect the actual number of records in the expected
recordset, but this isn't what I wanted to see! Something must be amiss
where I am binding the data, but I can't make out what.
I suspect the second of these two lines is incorrect for this control,
perhaps?
MyCommand.Fill(ds, "Titles")
DropDownList1.DataSource=ds.Tables("Titles").DefaultView
And can someone tell me why in the .Fill method the table must be
specified 'for mapping purposes' when it is present in the sql
statement? The database isn't specified .... And then again in the next
line?
thanks,
Mike
<%@ Page Language="vb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New
SqlConnection("server=PMG;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select distinct type from
titles",
MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "Titles")
DropDownList1.DataSource=ds.Tables("Titles").DefaultView
DropDownList1.DataBind()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:DropDownList id="DropDownList1" runat="server"> </asp:DropDownList>
</p> </form> </body> </html>
---
You are currently subscribed to dotnet as: [EMAIL PROTECTED] To
unsubscribe send a blank email to %%email.unsub%%
---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search Subscription
Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/
---
You are currently subscribed to dotnet as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/
