Bind without ParentID

[Cal]

Hi,
  I realize this may be an odd question, but here is my situation, i have two tables:
table1:
stateid, statename

table2:
CountyId, CountyName, stateId

I'm trying to have a structure like this:

Statename
 --> CountyName

my challenge is how to relate the two table to get the parentId. 

I think the answer is simple but for some reason I just can't get the sql right.

Regards,
Cal

[Nikolay Tsenkov]

Hi Cal,

Well, you need to add all records from table1 as records of table2.
Also you need to transform table2:
 - CountyId will become just id;
 - stateId will become parentId (this column should be nullable as the records representing states should have null for it).

From now on it's pretty straight-forward, isn't it?
Hope this is helpful for you!


Regards,
Nikolay Tsenkov
the Telerik team

[Cal]

Amaaazingly simple :)