如何显示数据使用ASP.NET和放大器的数据库来; HTML [英] How Can I display data coming from a database using ASP.NET & HTML
问题描述
我提出,从数据库中检索项的列表的查询:
I made a query that retrieve a list of items from a database:
CREATE PROCEDURE dbo.GetSubjects(@DayComing varchar(10) , @UserId varchar(3))
AS
IF EXISTS(
SELECT Std_ID
FROM Student
WHERE Std_ID = @UserID)
BEGIN
SELECT TimeTable.Ttb_Subject
FROM Student INNER JOIN
Class ON Student.Std_Class = Class.Cls_ID INNER JOIN
TimeTable ON Class.Cls_ID = TimeTable.Ttb_Class
WHERE (TimeTable.Ttb_WeekDay = @DayComing) AND (Student.Std_ID = @UserID)
END
ELSE BEGIN
SELECT TimeTable.Ttb_Subject, TimeTable.Ttb_Class
FROM Teacher INNER JOIN
TimeTable ON Teacher.Tch_ID = TimeTable.Ttb_Teacher
WHERE (TimeTable.Ttb_WeekDay = @DayComing)
END
现在我要显示在ASP页米,但我不知道我能做到这一点。你知道的任何教程,可以帮助我?
Now I want to show m at asp page, but I don't know how can I do it. Do you know any tutorials that can help me with this ?
感谢。
推荐答案
您有几种选择,例如LINQ2SQL,Linq2EF,ADO.NET,一些其他的框架...
You have several options, for example Linq2Sql, Linq2EF, ADO.NET, some other framework...
下面是关于如何使用ado.net完成这个啧啧:
的http://www.$c$cproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET
Here's a tut on how to accomplish this with ado.net: http://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET
下面是你如何使用LINQ 2 SQL做到这一点:
<一href=\"http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx\" rel=\"nofollow\">http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx
Here's how you do it with Linq 2 SQL: http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx
和LINQ 2实体框架:
http://msdn.microsoft.com/en-us/data/gg699321
And Linq 2 Entity framework: http://msdn.microsoft.com/en-us/data/gg699321
这篇关于如何显示数据使用ASP.NET和放大器的数据库来; HTML的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!