Filtering records using a Dropdown list control from two tables

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Dec 2004
Posts: 57
Reputation: Studio is an unknown quantity at this point 
Solved Threads: 0
Studio Studio is offline Offline
Junior Poster in Training

Filtering records using a Dropdown list control from two tables

 
0
  #1
Sep 21st, 2009
Hi

I am looking for some guidance. I have two DB tables, the tables are as follows:


tblCounty

countyID (int) AgentID (int) CountyName(text)


tblAgent

AgentID(int) Name(text) Contact Number(text)


What i want to do is to use a Dropdown list control to retrieve all the county's from tblCounty then when a user selects a county from the list the agent linked with that county will appear on the same page in something like a repeater control. I am guessing this is possible just i cant figure out how to do it

Just to let you know i am new to .NET and might need a step by step process.

Any help would be welcome, Thanks in advance
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 177
Reputation: Kusno is an unknown quantity at this point 
Solved Threads: 14
Kusno's Avatar
Kusno Kusno is offline Offline
Junior Poster

Re: Filtering records using a Dropdown list control from two tables

 
0
  #2
Sep 24th, 2009
Have you succeded to retreive tblCountry in DropDownList control?
NEVER NEVER NEVER GIVE UP
Reply With Quote Quick reply to this message  
Reply

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC