Thursday, June 19, 2014

How to connect two tables data without having a key and when you can not do change in Database?

For my friend Ayman,
Suppose you have data as above.
make xml as below,

<xml>
 <listdata>
  <data>
      <id>1</id>
      <routelinkid>1</routelinkid>
      <routeid>2</routeid>
  </data>
  <data>
      <id>2</id>
      <routelinkid>2</routelinkid>
      <routeid>1</routeid>
  </data>
  <data>
    <id>3</id>
      <routelinkid>3</routelinkid>
      <routeid>3</routeid>
  </data> </listdata>
</xml>

these fields you can write dynamically and can search from tags. Follow some article which shows how to read, write data from xml.
Id relation works as middle man table. which having keys of two table as reference.

No comments:

Post a Comment