<pre lang="text">I have two table and how to create the relationship in c# 1)TBL_PDT(product),pdt_id (primary key),pdt_name,pdt_description; 2)TBL_SIMILAR_PDT(similar product),sid(foreign key of TBL_PDT),sim L_PDT),sim_pdt_id(foreign key of TBL_PDT),sim_pdt_desc; 1)how to call the same product id from same foreign key table (TBL_SIMILAR_PDT)? 2)how to values are dropdownlist1(pdt_id) and dropdownlist2(pdt_id)?
select * from tbl_similar_pdt where ((sid = VALUE) or (sim_pdt_id = VALUE))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)