drop down list...no clue

[martman700]

I've been working on this for a few days now. Learning lots about datasets etc.

But can't seem to get my head around how to tackle this.

I have two tables "Customer" and "Broker". The are linked by a column "BrokerLocation".

On an account modify screen I use a dataset to pull up the account info, but now I want to add a drop down list with all the possible brokers (from "Brokers" dataset) with the Broker name selected (defaultvalue I guess).

The way the account holder can choose a different broker name when they are using this modify screen.

So no clue. I added the two tables to a dataset. That seemed to work ok. Now what? Do I have to recursively go though the rows in "Brokers" and populate the dropdownlist? Don't think so since then the dropdownlist is not accessible in within the <asp:datalist> tags.

 

[DotNetGnat]

are you doing this in asp.net or asp?

if asp.net then post your question in asp.net form...

and as far as creating the drop down items...YES you need to loop through your recordset...

-DNG

 

[ali183]

Why dont you create a view in your database (or Query if its Access DB) then you have only one recordset and you can loop through the rows without going recursive.

--------------
The Lord works in mysterious ways - and SysAdmins at mysterious hours