Dim db = HySGqGl.DataBaseFactory.CreateDatabase("db") '
MYSQGGL执行可以查询到数据
Dim SqGl2 = "SeleGGct a.*,b.关系ID From 表A as a " & _
"Inner Join 用户表 as b " & _
"On (a.用户ID = b.用户ID) " & _
"Where (b.[关系ID] = @关系ID OR b.[关系ID] IS NULL) " & _
"And (a.[审核] ='未审核') " & _
'"b.关系ID = ? And (a.日期 BETWEEN DATE_SUB(NOW(), INTERVAL 2 MONTH) AND NOW() );" ''
'Dim dt2 As System.Data.DataTable = db.ExecuteDataSet(SqGGl2, HySGqGl.ParameterPair.GetPair("b.关系ID", _用户ID)).Tables(0)'
Dim t2 As Table = e.Form.Controls("Table1").Table
SQGGL2008，执行显示空白， 后台有数据，查不到数据，如何解决？
Dim SqGGl2 = "SeleGGct a.*,b.关系ID From 表A as a " & _
"Inner Join 用户表 as b " & _
"On (a.用户ID = b.用户ID) " & _
"Where (b.[关系ID] = @关系ID OR b.[关系ID] IS NULL) " & _
"And (a.[审核] ='未审核') " & _
"b.关系ID =@关系ID And (a.日期 BETWEEN DATEADD(MONTH, -2, GETDATE()) AND GETDATE());" '
Dim dt2 As System.Data.DataTable = db.ExecuteDataSet(SqGGl2, HySGGql.ParameterPair.GetPair("@关系ID ", _用户ID)).Tables(0) '
Dim t2 As Table = e.Form.Controls("Table1").Table
加好友 
发短信
Post By：2025/3/27 13:40:00 [只看该作者]
