如何从 SQL Server Express 2005 数据库创建 ASPX 文件
我知道这是一个低级问题，但是，作为一个数据库人员，我对如何解决这个问题知之甚少。我在 Windows 2003 R2 服务器上安装了 SQL Server Express 2005。处于我职位的人创建了很多数据库并构建了运行我们的 Intranet 和几个网站的 .NET 应用程序（？）。
我的任务之一是使用他的数据库之一来构建“设备检查”数据库。数据库已经建立，我可以毫无问题地查看已存储的表格和信息。我的问题是每个人都记得内联网上有一个可以提供此信息的区域（我是个新手）。还完成了两份简短的报告，以显示可用的设备以及“谁拥有什么”设备。
在过去的几天里，我一直在试图弄清楚如何使这项工作发挥作用，但一无所获。之前在这里的那个家伙不合作。从长远来看，我觉得这并不重要，也不觉得我应该为此努力，但我的上级却认为。他们对此越来越不耐烦了。
谁能帮我解决这个问题吗？我只需要一种方法来表示数据库中已有的数据并创建一个可以在我们公司内联网上动态更改的页面以及两个报告。我熟悉创建静态 HTML 页面，但这超出了我的范围。我可以在其他区域看到 aspx 和 aspx.cs 文件，但我对它们了解不多 - 我更像是网络管理员。
这些信息需要以三年级学生能够理解的方式传达（不要让我觉得自己太白痴......）
有人愿意帮忙吗？
I know this is a low-level question but, not being a database person, I have limited knowledge of how to go about this. I have SQL Server Express 2005 installed on a Windows 2003 R2 server. The guy who was in my position created a lot of databases and built .NET applications (?) that run our Intranet and a couple websites.
One of the things I have been tasked with is to use one of his databases to build an 'equipment check out' database. The database has already been built and I have no problem viewing the tables and information already stored. My problem is that everyone remembers an area on the Intranet where this information was available (I'm fairly new). Two brief reports were also done to show what was available and 'who had what' equipment.
I have spent the past few days trying to figure out how to make this work and am coming up empty. The guy who was here before is uncooperative. In the grand scheme of things I don't feel like this is important or that I should be working on it but my superiors do. They are getting impatient about this.
Can anyone please help me figure this out? I just need a way to represent the data that is already in the database and create a page that can be dynamically changed on our company Intranet -- as well as the two reports. I'm familiar with creating static HTML pages but this is out of my league. I can see in other areas there are aspx and aspx.cs files but I don't know much about them -- I'm more of a Network Admin person.
The information needs to be conveyed in a manner that a 3rd grader would understand (without making me feel like TOO much of an idiot...)
Anybody willing to help?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
看看这是否可以帮助你。
http://www.asp.net /web-pages/videos/create-a-data-driven-dynamic-web-page
See if this can help you.
http://www.asp.net/web-pages/videos/create-a-data-driven-dynamic-web-page
我将重点关注在网站上查找此信息曾经所在的位置。检查用户的浏览器历史记录，搜索文件内容中的关键字等。这比学习网站编程花费的时间要少得多。
根据您的评论更新答案：
由于您确实被这个问题“困扰”，并且您只与两个用户打交道，因此我建议使用报告包来解决问题，而不是为人力资源和会计人员提供基于网络的解决方案。我只是觉得在这么短的时间内要学的东西太多了。根据您的描述，我假设用户没有编辑网站上的信息，只是查看它，对吧？
获取 Crystal Reports 30 天免费下载：
http://www.sap.com/solutions/sap-crystal-solutions/query-reporting-analysis/sapcrystalreports/index.epx
这是一个很好的报告包，拥有非常大的用户根据。您查找学习资源（网络/书籍）不会有任何问题。
I would focus on finding the location on the site where this information used to be located. Check your User's browser history, search file contents for keywords etc. This would take a lot less time than learning to program websites.
Updated Answer Based on your comments:
Since you are really "stuck" with this problem, and you are only dealing with two users, I would suggest solving the problem with a reporting package instead of giving the HR and Accounting person a web based solution. I just think there is too much to learn in such a short amount of time. I'm assuming by your description that the users are not editing the information on the site, just viewing it, right?
Grab a 30 day free download of Crystal Reports:
http://www.sap.com/solutions/sap-crystal-solutions/query-reporting-analysis/sapcrystalreports/index.epx
It's a nice reporting package, with a very large user base. You won't have any trouble finding learning resources (Web/books).
如果我正确理解你的问题，你是一个非程序员（或者更多，如果是 IT 专业人士），你只想拥有已经在数据库中设计的数据的 UI 表示。
假设您对 Visual Studio 及相关知识有一些基本了解，我建议您去阅读/观看动态数据。下面的 URL 应该会给你一个良好的开端。
有关此内容的更多信息，请访问http://www.asp.net/dynamicdata
If I understand your question correctly, you being a non-programmer (or more if IT Pro), you just want to have the UI representation of data which is already designed in database.
Assuming that you have some basic knowledge about Visual Studio and related, I can suggest to go up and read/watch about the Dynamic Data. Below URL should give you a good start for this.
More information on this is available here http://www.asp.net/dynamicdata
你要做到这一点是相当困难的。但如果您必须这样做，那么这里有一个简单的方法：
1.打开Visual Studio
2. 创建一个新网站（文件 -> 新建 -> 网站）
3. 打开服务器资源管理器窗口（查看 -> 服务器资源管理器）
3.1 创建新的数据连接（此处提供与登录 Sql Server Management Studio 时类似的信息）
3.2 单击数据连接下列出的“表”节点，然后将该表拖至网页。
4. 保存所有内容并按 F5。
如果一切顺利，您将在网格内的网页中看到表格的内容。试试这个，无论你遇到什么困难，都可以在这个答案下发表评论。我们会尽力解决这个问题。
It'd be pretty hard for you to make this. But still if you must then here's a simple way to do it:
1. Open Visual Studio
2. Create a new Web Site (File -> New -> Web Site)
3. Open Server Explorer window (View -> Server Explorer)
3.1 Create new data connection (here provide info similar to when you log into Sql Server Management Studio)
3.2 Click on the Tables node listed under your data connection and drag this table to a web page.
4. Save everything and hit F5.
If everything goes fine you'll see the contents of the table in a web page inside a grid. Try this and wherever you get stuck put a comment under this answer. We'll try to sort this out.