How to create an ASPX file from a SQL Server Express 2005 database_问答_开发者

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开发者_JS百科 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?

See if this can help you. http://www.asp.net/web-pages/videos/create-a-data-driven-dynamic-web-page

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 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).

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

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.