如何显示数据使用ASP.NET和放大器的数据库来; HTML

本文介绍了如何显示数据使用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完成这个啧啧：的www.$c$cproject/Articles/15403/Calling-Stored-procedures-in-ADO-NET

Here's a tut on how to accomplish this with ado: www.codeproject/Articles/15403/Calling-Stored-procedures-in-ADO-NET

下面是你如何使用LINQ 2 SQL做到这一点：weblogs.asp/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: weblogs.asp/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

和LINQ 2实体框架： msdn.microsoft/en-us/data/gg699321

And Linq 2 Entity framework: msdn.microsoft/en-us/data/gg699321