Tony,
Add an alias field to your query like Total Then concatenate the two fields. Then do a select on just the value and the total field. HTH --Eric -----Original Message----- From: Tony Trapp [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 1:32 PM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Need help with asp:dropdownlist hey guys this is the deal, I a database that has two tables in it. One for members and one for regions, both have ID's in my select statement I have joined these two tables and also counted how many members are in the members table with in the join. example: ------------------------------------------------- select count(dbo.members.ID)as userscount,dbo.members.ID,dbo.province.region from dbo.members, dbo.province WHERE (dbo.members.ID = dbo.province.ID) group by dbo.members.ID, dbo.province.region Order by dbo.province.region ASC ------------------------------------------------- end example Now I have 3 colums to work with, what I want to do in the drop downlist text is show the region and count, Example: California (10) and for the value Example: 21 puting it all together would be like this in html <select name="memregs" onchange="__doPostBack('esregs','')" language="javascript" id="memregs"> <option value="21">California (10)</option> </select> My question is how can I do this? The dropdownlist only allows for one paremetor to be put in for the text value. If any one know of a tutorial or example that would really help as well. Tony... _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] e> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
