Filtering records using a Dropdown list control from two tables

Expand Post »

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

Similar Threads

Cascading Dropdown list with (AJAX, PHP) in PHP
How to create a Dropdown List Box with Go Button ??? Help please Urgent in ASP.NET
get BLOB from database based on dropdown list selected value in ASP.NET
problem for dropdown list inrepeator conrtrol in JavaScript / DHTML / AJAX
retain selected value in a dropdown list in ASP

Studio

Reputation Points: 11

Solved Threads: 0

Junior Poster in Training

Offline

59 posts
since Dec 2004

Permalink

Sep 24th, 2009

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

Have you succeded to retreive tblCountry in DropDownList control?

Kusno

Reputation Points: 11

Solved Threads: 17

Junior Poster

Offline

191 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Losing Session Variables in a Frameset

Next Thread in ASP.NET Forum Timeline: SQL Strings

DaniWeb Message

Cancel Changes

User Name
Password