golagha_program
سه شنبه 23 تیر 1388, 16:29 عصر
سلام دوستان خوبم.
توي لايه داده از يك idatareader استفاده مي كنم.پرسش هاي ساده مثل
Select * from product رو به راحتي مقدار بر مي گردونه ولي نمي تونه جواب اين پرسش رو بر گردونه
SELECT P.Serial, P.Code, P.FirstName, P.LastName, P.FatherName, P.Issn, P.NationalNo, P.Address, P.TelNo, P.PostalCode, P.BirthDate, P.BirthLocation,
P.FaxNo, P.Email, P.UserName, P.Password, P.Dsc, P.Type, P.Symbol, P.Picture, P.Signature, P.IsActive, P.AuditorRef, T.ThumbPrint,
P.FirstName + ' ' + P.LastName AS FullName, C.DisplayLabel AS TypeName, A.Name AS AuditorName
FROM dbo.Personnel AS P LEFT OUTER JOIN
dbo.Constant AS C ON P.Type = C.FieldValue AND C.TableName = 'Personnel' AND C.FieldName = 'Type' LEFT OUTER JOIN
dbo.Auditor AS A ON P.AuditorRef = A.Serial LEFT OUTER JOIN
(SELECT PT.PersonnelRef, PT.ThumbPrint
FROM dbo.PersonnelThumbPrint AS PT INNER JOIN
(SELECT PersonnelRef, MAX(Serial) AS Serial
FROM dbo.PersonnelThumbPrint
GROUP BY PersonnelRef) AS LT ON PT.Serial = LT.Serial) AS T ON T.PersonnelRef = P.Serial
آيا idatareader مي تواند داده هاي مربوط به چند جدول را بر گرداند؟
ببخشيد سوال رو اينجا پرسيدم چون دارم يك پروژه وب مي نويسم.
توي لايه داده از يك idatareader استفاده مي كنم.پرسش هاي ساده مثل
Select * from product رو به راحتي مقدار بر مي گردونه ولي نمي تونه جواب اين پرسش رو بر گردونه
SELECT P.Serial, P.Code, P.FirstName, P.LastName, P.FatherName, P.Issn, P.NationalNo, P.Address, P.TelNo, P.PostalCode, P.BirthDate, P.BirthLocation,
P.FaxNo, P.Email, P.UserName, P.Password, P.Dsc, P.Type, P.Symbol, P.Picture, P.Signature, P.IsActive, P.AuditorRef, T.ThumbPrint,
P.FirstName + ' ' + P.LastName AS FullName, C.DisplayLabel AS TypeName, A.Name AS AuditorName
FROM dbo.Personnel AS P LEFT OUTER JOIN
dbo.Constant AS C ON P.Type = C.FieldValue AND C.TableName = 'Personnel' AND C.FieldName = 'Type' LEFT OUTER JOIN
dbo.Auditor AS A ON P.AuditorRef = A.Serial LEFT OUTER JOIN
(SELECT PT.PersonnelRef, PT.ThumbPrint
FROM dbo.PersonnelThumbPrint AS PT INNER JOIN
(SELECT PersonnelRef, MAX(Serial) AS Serial
FROM dbo.PersonnelThumbPrint
GROUP BY PersonnelRef) AS LT ON PT.Serial = LT.Serial) AS T ON T.PersonnelRef = P.Serial
آيا idatareader مي تواند داده هاي مربوط به چند جدول را بر گرداند؟
ببخشيد سوال رو اينجا پرسيدم چون دارم يك پروژه وب مي نويسم.