Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Programming > Dropdownbox with ado,sql,vb.net2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Dropdownbox with ado,sql,vb.net2003

Reply to Message Icon

Name: Anthony Arde
Date: February 8, 2006 at 00:54:32 Pacific
OS: win Xp Pro Sp2
CPU/Ram: 3.2 P4
Comment:

Howzit , i`m having a tough time populating a dropdown box with an sql dataset or dataview, seems like it cant do a string conversion.

Dim objdataset2 As DataSet
Dim objDataAdapter2 As SqlDataAdapter

objDataAdapter2 = New SqlDataAdapter( _
"select distinct make from tblcar", objconnection)

objdataset2 = New DataSet
objDataAdapter2.Fill(objdataset2, "tblcar")

Dim objDataView2 As DataView = _
objdataset2.Tables("tblcar").DefaultView


DropDownList1.DataSource = (objdataset2)
DropDownList1.DataBind()


objDataView2 = Nothing
objdataset2 = Nothing
objDataAdapter2 = Nothing

all it does is fill the field with "system.data." dont know why it does this, please help.
Thanks.
Anthony.



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links
Ads by Google


Results for: Dropdownbox with ado,sql,vb.net2003
What's Up With All The VB www.computing.net/answers/programming/whats-up-with-all-the-vb/7089.html

VB & ADO's www.computing.net/answers/programming/vb-amp-ados/501.html

VB and SQL www.computing.net/answers/programming/vb-and-sql/8034.html