Join David Gassner for an in-depth discussion in this video Selecting data for a report, part of ASP.NET Essential Training.
The ASP.NET Framework makes it easy to create a report that includes both the…output data and the form controls that the user interacts with, to indicate…which data they want to present. For this demonstration, I'll work with the…file SelectData.aspx.…In this version of the page, there is an SQLDataSource with a joint table query…and a GridView that's presenting the data. When I run the page in the browser,…I see that all of the data from the table is displayed. The first step in…creating this sort of filtered report is to create a user interface that the…user can interact with.…
I am going to use an ASP.NET control called the DropdownList. In HTML terms,…it's the Select control, but it will be dynamically populated with data from…one of the database tables. I first need an SQLDataSource object that gets the…data for that table. I'll place the cursor in the page right before the GridView.…The easiest way to get there is to select the GridView, and then press the…Left-Arrow key, then press Enter to create a new paragraph. If you move the…
Author
David Gassner
Updated
2/13/2013Released
4/28/2009- Storing data with SQL Server
- Using the GridView control to present and edit dynamic data
- Creating a data entry system
- Attaching external CSS files
- Creating pages to log in and authenticate visitors
- Installing Internet Information Services (IIS) on Windows XP and Windows Vista
- Deploying an ASP.NET website on IIS
Skill Level Beginner
Duration
Views
Q: When trying to create a new database, after pasting the text into the SQL Management Suite and executing the query, the database is not created and the following message appears:
Database 'mybookstore' does not exist. Make sure that the name is entered correctly.
What is causing this error?
A: The database must be explicitly created before the script is run. Start by right-clicking on the Databases item in the left panel, then follow the prompts to create the database. Then retry the query.
Q: I am running into problems installing the latest version of ASP.NET. Has the installation procedure changed since this tutorial was recorded?
A: The installation process for the newest version of ASP.NET and its associated tools is a little different than in ASP.NET 3.5, which was used to record this course. You can download Microsoft Web Platform Installer 2.0 from:
<a href="http://www.microsoft.com/web/downloads/platform.aspx" target="blank">http://www.microsoft.com/web/downloads/platform.aspx</a>
Microsoft Web Platform Installer 2.0 includes everything you need:
ASP.NET 4?
Visual Web Developer 2010?
SQL Server Express
You must have one of the following operating systems:
Windows 7?
Windows Vista?
Windows Vista SP1?
Windows XP SP2+?
Windows Server 2003 SP1+?
Windows Server 2008?
Windows Server 2008 R2
You must have administrator privileges on your computer to run the Web Platform Installer.
Q: This course was updated on 2/13/2013. What changed?
A: Since this course was recorded, Microsoft has released both ASP.NET 4.5, the latest version of the server-side web application server, and Visual Studio Express 2012 for Web (the successor product to Visual Web Developer). Both have been adapted to work on Windows 8. There will be some visual changes and some functional changes, but most of the server-side code shown in the course is the same. This update provides a map for those working with the latest software so they can navigate their way through the course.
In particular, we added <em>What's new</em> movies for both ASP.NET 4 and 4.5, a movie explaining the significance of the update, a movie on installing SQL Server Express 2012, and one on exporting database scripts in SQL Server Management Studio 2012, as well as updates to visuals throughout the course.
Q: In the chapter on user authentication, an authentication error results when I try to use the Login component or register a new user. How do I fix this?
A: This is a known error that can occur when using the original release of Visual Studio 2012 Express for Web. Update your copy of Visual Studio for Web to at least maintenance release 1, and then try the exercise again.
-
Introduction
-
Welcome1m 42s
-
Prerequisites2m 21s
-
Using the exercise files1m 32s
-
-
1. Getting Started
-
2. Using Microsoft SQL Server 2008
-
Creating a new database8m 51s
-
Testing SQL queries3m 53s
-
3. Creating ASP.NET Pages
-
4. Programming in ASP.NET
-
Using loops6m 52s
-
Using functions9m 25s
-
Using trace statements4m 47s
-
Debugging with breakpoints5m 45s
-
Commenting code4m 38s
-
5. Creating Reusable Code
-
Creating web controls5m 53s
-
-
6. Using Cascading Style Sheets in Web Forms
-
Attaching external CSS files3m 12s
-
Defining a CSS selector6m 10s
-
7. Presenting Dynamic Data
-
8. Creating a Data Entry System
-
Redirecting page requests9m 39s
-
Creating an update page6m 20s
-
Deleting database records2m 35s
-
9. Validating User Input
-
10. Creating Reports
-
Selecting data for a report6m 52s
-
11. Managing Session State
-
Using session variables6m 37s
-
12. Securing a Site with Forms Authentication
-
13. Deploying a Web Site
-
Installing IIS on Windows XP6m 32s
-
-
Conclusion
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Selecting data for a report