I haven't done a whole lot of databinding work, but shouldn't you just bind to the DataSet directly:
MyCommand.Fill(ds, "Titles") DropDownList1.DataSource = ds --- Patrick Steele ([EMAIL PROTECTED]) Lead Software Architect Image Process Design -----Original Message----- From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 8: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/
