omega_pc
پنج شنبه 08 اردیبهشت 1390, 11:46 صبح
من یه STOREPROCEDURE به صورت زیر نوشتم:
ALTER PROCEDURE dbo.getDesignerRate
@fromdate datetime,
@todate datetime
AS
/* SET NOCOUNT ON */
SELECT d.DesignerID, d.Name + ' ' + d.LastName AS name, COUNT(d.DesignerID) AS TrueCount
FROM Designer AS d INNER JOIN
Question AS q ON d.DesignerID = q.DesignerID INNER JOIN
Quiz_Detail AS qd ON qd.QuestionID = q.QuestionID AND q.AnswerTrue = qd.Selected INNER JOIN
Quiz AS qz ON qz.QuizID = qd.QuizID
where qz.Date between @fromdate and @todate
GROUP BY d.DesignerID, d.Name, d.LastName
تو برنامه هم به صورت زیر ازش استفاده می کنم:
MyDataSetTableAdapters.getDesignerRateTableAdapter gda = new MyDataSetTableAdapters.getDesignerRateTableAdapter ();
var query = from d in gda.GetData(fromdate,toDate)
select new { کدطراح = d.DesignerID, نام_طراح = d.name, تعدادجوابهای_درست = d.TrueCount };
GridView1.DataSource = query;
GridView1.DataBind();
ولی هیچ چیزی تو gridview نشون نمیده
ALTER PROCEDURE dbo.getDesignerRate
@fromdate datetime,
@todate datetime
AS
/* SET NOCOUNT ON */
SELECT d.DesignerID, d.Name + ' ' + d.LastName AS name, COUNT(d.DesignerID) AS TrueCount
FROM Designer AS d INNER JOIN
Question AS q ON d.DesignerID = q.DesignerID INNER JOIN
Quiz_Detail AS qd ON qd.QuestionID = q.QuestionID AND q.AnswerTrue = qd.Selected INNER JOIN
Quiz AS qz ON qz.QuizID = qd.QuizID
where qz.Date between @fromdate and @todate
GROUP BY d.DesignerID, d.Name, d.LastName
تو برنامه هم به صورت زیر ازش استفاده می کنم:
MyDataSetTableAdapters.getDesignerRateTableAdapter gda = new MyDataSetTableAdapters.getDesignerRateTableAdapter ();
var query = from d in gda.GetData(fromdate,toDate)
select new { کدطراح = d.DesignerID, نام_طراح = d.name, تعدادجوابهای_درست = d.TrueCount };
GridView1.DataSource = query;
GridView1.DataBind();
ولی هیچ چیزی تو gridview نشون نمیده