Loading

how can show name category based id mvc4 & angular4

bishoe nb

how can show name category based id mvc4 angular4 i have 2 table 1. category 2. prdouct in product table i save idcategory how can show namecategory Instead of the idcategory

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

bishoe nb7y ago
Madan Sorab I want to show the name of the section by idcategory using mvc4 And angular
Madan Shekar7y ago
i didn't understand your question properly, stil i m tring to help

category table
id name
1 mobile
2 bokks

product table
id categoryid productname
1 1 iphone
2 2 Java

for list out all categories
select * from category

based on category

select * from product where categoryid=1

second query give results with repect category

Thanks
if it helps mark as a ans