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

Have you succeded to retreive tblCountry in DropDownList control?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.