在两个表的基础上将字段与gridview绑定 [英] Binding the fields with gridview on the basis of two tables

问题描述

我有两个桌子.一个用于物品，另一个用于物品许可.
项目包含字段:itemid，项目名称，公司名称
和itempermission包含以下字段:Permissionid，adminid，productid.

我想通过网格视图绑定项目表中存在其productid的项目表的那些字段.

I have two tables . One for item and another for itempermission .
Items contain fields : itemid,itemname,companyname
and itempermission contains fields : permissionid,adminid,productid.

I want to bind those fields of item table whose productid present in the itempermission through Grid View .

推荐答案

请尝试根据条件查询此查询以联接两个表

Hi,

try this query for joinning two tables based on condition

   select I.itemid,I.itemname from Item as I,itempermission as IP
where I.itemid=IP.productid

之后，将结果绑定到gridview

您可以编写所有Best

After that bind result to gridview

All the Best

联接查询.用这个

you can write join query. use this one

select I.itemid,I.itemname,I.companyname from Item I Inner join itempermission IP on I.itemid=IP.productid

这篇关于在两个表的基础上将字段与gridview绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！