我有以下的SqlDataSource
,我想将它转换为DataView
并从中读取某一列:
SELECT
dbo.Divisions.DivisionShortcut,
COUNT(DISTINCT dbo.UserQuiz.Username) AS [Number of Participants]
FROM
dbo.Divisions
INNER JOIN
dbo.employee ON dbo.Divisions.SapCode = dbo.employee.DivisionCode
INNER JOIN
dbo.UserQuiz ON dbo.employee.Username = dbo.UserQuiz.Username
INNER JOIN
dbo.Quiz ON dbo.UserQuiz.QuizID = dbo.Quiz.QuizID
WHERE
(dbo.Quiz.QuizID = @QuizID)
GROUP BY
dbo.Divisions.DivisionShortcut
这个
SqlDataSource
允许用户输入测验的编号,并检索该测验中参与者的总数。我想将这个SqlDataSource
转换为一个DataTable
并从中读取一列。那么该如何做呢?
SqlDataSource
。你是否有创建SqlDataSource
的代码出现问题? - Metro Smurf