GridView怎么绑定不同表中的不同字段?????????
解决方案 »
- 最近把项目从vs2003升级到2010,高分急
- 使用什么控件可以临时批量存储页面数据?
- GridView绑定关联
- 在VS2008中的web编程中,如何获取ListView的某一个行的某一列的值??
- 无法上传文件
- 小弟没分了请教个问题!好心人进来帮着看看!DataGrid问题在线等!
- 谁了解在线杀毒做法的,进来救命啊!
- 数据库添加记录不成功,原因出在何处??
- 谁有RowUpdating的范例代码 分享一下 谢谢
- 如何在dll反编译出的cs中加入新的cs文件
- asp.net站点发布后,本地访问正常,其他机器访问无法显示图片与css样式
- 提交数据时获取双重绑定的Repeater中子Repeater的text的文本值?
比如我建立了一个视图,视图里面是几个表的联合查询
CREATE VIEW dbo.cg_purchase
AS
SELECT a.[ID], a.DeptID,h._Name as Dept,a.BillID, Type=CASE WHEN a.Type=1 THEN '采购' ELSE '退货' END, _Date=convert(char(10),a._Date,120), a.OperatorID, a.ProvID, a.StockID,
ChkDate=convert(char(10),a.ChkDate,120), a.ChkOperatorID,Status=CASE WHEN a.Status=1 THEN '待审核' ELSE '已审核' END, a.Re,
b.JobNO AS OperatorNO, b._Name AS Operator, e.SupNO, e._Name AS Provider,
d._Name AS StockName, c.JobNO AS ChkOperatorNO, a.InCash,
c._Name AS ChkOperator,e.pyCode as ProviderCode,a.OperationID,dbo.aa_gettotalprofit(a.[ID],6) as Total,dbo.aa_gettotalprofit(a.[ID],9) as GoodsAmount,a.OperationBill
FROM dbo.Purchase a LEFT OUTER JOIN
dbo.StaffList b ON a.OperatorID = b.[ID] LEFT OUTER JOIN
dbo.StaffList c ON a.ChkOperatorID = c.[ID] LEFT OUTER JOIN
dbo.StockList d ON a.StockID = d.[ID] LEFT OUTER JOIN
dbo.SupplierList e ON a.ProvID = e.[ID] LEFT OUTER JOIN
dbo.BranchList h ON a.DeptID=h.[ID]
那么我只用读取视图,然后绑定数据源就型了
SELECT t1.id,t2.name from [idtable] t1
join [nametable] on t1.id=t2.id这样返回的就是两个表的连接结果