newto net

newto net

  • NA
  • 74
  • 25.2k

Two table with relation in foreign key out grid view

Jan 25 2012 10:11 PM
Table one
product_mainid, product_mainname, Product_home country

Table Two

product_mainid, product_subproduct, product_price, product_quantity, Product_manufacture



Here for example

Table One
product_mainname id =1, product_mainname = colgate, Product_home country=India,

Table Two
product_mainid foriegn key from table one, product_subproduct=brush, product_price=20rs, product_quantity=10, Product_manufacture=india


How to relate with primary and foriegn key and in one page, while loading a page the second table will showing in grid view and the output after clicking the button will show the another grid view in bottom i will attach the output format for your convience.


Answers (2)