Programming questions on Geography Items Configuration

[Edward]

hi, I've some requirements about the data,
Nations->States->Cities->Counties, four level.

I want to give a friendly UI to customer, but I wasn't satisfied with all
that I thought out, can anybody give me some idea ?

here I list my ideas:
1) each level has one seperate page, the first three has hyperlink to its
child

2) 4 datagrids in 1 page, Master->secondMaster->thirdMaster->Detail, the
performance may be a problem

3) 4 in one datagrid, all the data is stored in one table, with parent
field to be used for refreshing datasource of the datagrid.

looking forward to the first answer, thanks in advance.

Edward

 

[Raymond Lewallen]

Edward,

Look at Master-Detail usage in datagrids. You'll need a primary key with
foreign keys from its related tables in your dataset, which would contain
the 4 tables with relationships setup. Easiest way for you to find a
solution is to Google "datagrid master detail". Lots of examples and code
out there.

HTH,

Raymond Lewallen