Start learning with our library of video tutorials taught by experts. Get started

Visual Studio 2010 Essential Training
Illustration by

Creating typed datasets


From:

Visual Studio 2010 Essential Training

with Walt Ritscher

Video: Creating typed datasets

Datasets are the basis of most of the drag-drop designer tools in Visual Studio. The dataset acts like an in-memory disconnected representation of a database. As you can imagine, creating a dataset by hand is a tedious process. Fortunately for us, Visual Studio contains a tool for generating datasets. These types of Datasets are known as strongly typed datasets in some circles. The benefit of using the tool is it quickly creates all of the Dataset parts. The benefit of having a strongly typed Dataset is that all the columns are correctly named and typed, so a column in the database that contains a double value will have a column in the dataset of type double.
Expand all | Collapse all
  1. 2m 3s
    1. Welcome
      1m 2s
    2. Using the exercise files
      1m 1s
  2. 7m 19s
    1. Understanding the Visual Studio versions
      3m 51s
    2. Setting up your developer computer
      3m 28s
  3. 58m 2s
    1. Creating a Visual Studio project
      4m 58s
    2. Working with Solution Explorer
      6m 32s
    3. Working with big projects
      3m 53s
    4. Taking a tour of the Integrated Developer Environment (IDE)
      8m 36s
    5. Introducing drag-and-drop UI design
      7m 38s
    6. Working with the Properties window
      6m 44s
    7. Looking at Server Explorer
      7m 4s
    8. Exploring the new Help engine
      6m 41s
    9. Setting options for the IDE
      5m 56s
  4. 39m 25s
    1. Creating a simple WPF application
      1m 32s
    2. Building the UI with the editors
      9m 14s
    3. Working with the application code
      3m 37s
    4. Communicating with the web site
      7m 15s
    5. Connecting your data
      8m 4s
    6. Binding to an RSS feed
      5m 4s
    7. Packaging and deploying the application
      4m 39s
  5. 39m 46s
    1. What languages are supported in Visual Studio 2010?
      1m 17s
    2. Exploring basic settings for the Code Editor
      5m 35s
    3. Writing a C# program
      6m 48s
    4. Writing a VB program
      6m 29s
    5. Working with C++
      6m 38s
    6. Working with F Sharp
      6m 9s
    7. Font and color options
      6m 50s
  6. 1h 5m
    1. Formatting your code
      6m 43s
    2. Navigating your code
      7m 44s
    3. Using the Task List
      2m 26s
    4. Commenting your code
      2m 45s
    5. Documenting your code
      8m 26s
    6. Using IntelliSense effectively
      7m 0s
    7. Working with code snippets
      6m 25s
    8. Refactoring your code
      5m 15s
    9. Understanding code generation
      2m 10s
    10. Generating code with T4
      6m 29s
    11. Using the Class View, Class Designer, and Class Diagram tools
      5m 51s
    12. Refactoring VB with CodeRush Xpress
      4m 33s
  7. 1h 11m
    1. Working with project and item templates
      8m 38s
    2. Creating a console application
      7m 5s
    3. Creating a class library
      6m 26s
    4. Creating a web site with ASP.NET
      7m 37s
    5. Creating a rich internet application with Silverlight
      6m 57s
    6. Creating a classic Windows application with Windows Forms
      10m 31s
    7. Creating a dramatic Windows application with Windows Presentation Foundation (WPF)
      4m 41s
    8. Creating a WCF service
      9m 1s
    9. Using an existing WCF service
      6m 38s
    10. Navigation UI designs with the Document Outline view
      3m 41s
  8. 33m 18s
    1. Creating a data project with SQL Project
      6m 24s
    2. Clarifying the confusion on .NET Data
      3m 31s
    3. Using ADO.NET in your application
      6m 50s
    4. Creating typed datasets
      7m 55s
    5. Using the data binding tools
      8m 38s
  9. 30m 13s
    1. Debugging code
      9m 32s
    2. Working with the Watch and other debug windows
      7m 46s
    3. Other debugging techniques
      6m 50s
    4. IntelliTrace historical debugging in Visual Studio Ultimate
      6m 5s
  10. 17m 56s
    1. Understanding Visual Studio editions and test tools
      2m 22s
    2. Verifying your code with unit tests
      8m 58s
    3. Running performance and load tests
      6m 36s
  11. 34m 5s
    1. Building your application
      4m 19s
    2. Customizing the build process with MSBuild
      6m 36s
    3. Setting assembly information
      2m 12s
    4. Deploying a basic Windows application
      2m 19s
    5. Creating an installer with Visual Studio
      7m 39s
    6. Creating a ClickOnce application
      5m 13s
    7. Setting up IIS for deploy
      2m 9s
    8. Deploying a Silverlight or ASP.NET application
      3m 38s
  12. 14m 0s
    1. Understanding source control
      2m 9s
    2. Setting up Team Foundation Server source control
      3m 5s
    3. Using Team Foundation Server source control
      8m 46s
  13. 17m 31s
    1. Understanding the .NET Office integration
      4m 16s
    2. Making a Word 2010 application
      7m 54s
    3. Making an Excel 2010 add-in
      5m 21s
  14. 31m 34s
    1. Understanding the extensibility model in Visual Studio
      2m 17s
    2. Adding external tools to the Tools menu
      4m 42s
    3. Creating macros
      7m 16s
    4. Using the Extension Manager
      5m 1s
    5. Creating an MEF add-in
      7m 9s
    6. Deploying and installing an add-in with VSIX
      5m 9s
  15. 25m 34s
    1. Working with configuration files
      5m 37s
    2. Using the Settings Editor
      7m 30s
    3. Using the Resources Editor
      6m 59s
    4. Localizing your resources
      5m 28s
  16. 1m 17s
    1. Goodbye
      1m 17s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Visual Studio 2010 Essential Training
8h 9m Intermediate Nov 16, 2010

Viewers: in countries Watching now:

In Visual Studio 2010 Essential Training, author Walt Ritscher demonstrates how to use Visual Studio 2010 Professional to develop full-featured applications targeting a variety of platforms. Starting with an overview of the integrated developer environment, the course covers working with code editors, navigating and formatting code, and deploying applications. Also included are tutorials on running performance and load tests, and debugging code. Exercise files accompany the course.

Topics include:
  • Creating a Visual Studio project
  • Building the user interface
  • Binding to an RSS feed
  • Coding with IntelliSense
  • Creating rich Internet applications with Silverlight
  • Building Windows applications with Windows Forms
  • Integrating with SQL Server
  • Working with Microsoft Office applications
  • Understanding extensibility in Visual Studio
  • Working with data, ADO.NET and datasets
  • Using source control
Subject:
Developer
Software:
ASP.NET Silverlight Visual Studio
Author:
Walt Ritscher

Creating typed datasets

Datasets are the basis of most of the drag-drop designer tools in Visual Studio. The dataset acts like an in-memory disconnected representation of a database. As you can imagine, creating a dataset by hand is a tedious process. Fortunately for us, Visual Studio contains a tool for generating datasets. These types of Datasets are known as strongly typed datasets in some circles. The benefit of using the tool is it quickly creates all of the Dataset parts. The benefit of having a strongly typed Dataset is that all the columns are correctly named and typed, so a column in the database that contains a double value will have a column in the dataset of type double.

I'm inside Visual Studio, and I've opened a Solution called CreatingDataSets, which contains one project. This project contains a Windows Form with three buttons and a list Box. I'm going to ask Visual Studio to create a typed dataset for me by going to my project and adding a database. I'm going to choose add an existing item, and then I'm going to go to my Desktop open my Exercise Files folder and scroll down to the Assets section.

You need to be sure that your filter inside this dialog is set to All Files, so that you can see the database file. This is the database file I'm looking for, northwnd.mdf; I'm going to click on Add. Now, Visual Studio recognizes that it can generate a dataset from this database, so it asks me, would I like to create a dataset or an Entity Data model. I'm going to create the simpler of the two, which is the dataset, and then I want to click on Next.

It just went out and talked to that database and has retrieved the list of all of the resources that are available in that database. Here is the listing of the tables. Within the tables, I can see things like the different column names. There is also a section that shows the Stored Procedures inside that database. I'm just going to take a couple of tables from the database. I'm going to take the Products table and the Shippers table, and I'm going to leave the dataset name the same.

Next, I'm going to click on Finish. Now, inside my app.config file, that wizard generated this connectionString. I can then use this connectionString to connect to the database. In fact, all I need to do is talk to the dataset, and it automatically will connect and talk to the database. Let me show you what I'm talking about. I'm going to go to this Fill DataSet button and double-click on it.

I'm going to declare an instance of the products table by typing "var products", the name of my dataset, which was "northwndDataSet.ProductsDataTable". This is the line of code where I'm going to create the TableAdapter. And as you can see there is a ProductsTableAdapter and a ShippersTableAdapter, I'm working with the products, so I am going to choose this one here.

The TableAdapters job is to talk to the database. This is where it does the Select queries, the Delete queries, the Update queries, and the Insert queries. So next, I'm going to ask the TableAdapter to fill the products table. So I say ta.Fill and then I pass in the table that I want to fill, which in my case would be that instance of the products class.

And then I'll tell my listBox to use the ProductName when it's showing the data. And lastly, I need to make sure that I fill my listBox. My listBox is called listBox1. I choose DataSource =, and then I'm going to assign the products table. Now, I see, I forgot to put a set of parentheses after this new line.

It's nice to have IntelliSense. I'll press F5 to run the application and Y to dismiss that dialog, and I'll click on the Fill DataSet, and I'm now using that strongly typed dataset. You can see down, here in this example, I can also use the strongly typed access. The product has a UnitPrice property on it, which I can use to set or retrieve the unit price of a particular product. But I'd rather show you for the rest of the demo is how to create my own extra query against the database.

So I'm going to open this XSD file that was created for me when I generated the dataset. This contains a designer surface for making changes to my dataset. I'll double-click on this file, and here you can see the Products table and the Shippers table, and then at the bottom you see the ProductsTableAdapter. Remember, this is what gets the data out of the database and puts it into the products table, and takes the changes of the data and puts it back into the data source. So I'm going to come down here on the bottom, and I'm going to add a new query.

I like to choose SQL statements, a SELECT query. It's already stubbed in the code for a basic query. And I'm just going to come down here and say, Where UnitPrice > some parameter value @price. So now this is a parameterized query. I'll pass this piece of information in, and it will return all the products that are greater than this price.

I'll click on Next. I'm going to call my method that is going to be on my TableAdapter GetDataByPrice, and I'll click on Next and Finish. Notice there is a new row here now. There is a GetDataByPrice. So now I'll go back to my form, and I'll go to this Fill Products by Price, and I just need to write two lines of code. var ta = new.

I need that same TableAdapter, and now that TableAdapter has my new query on it, so I'm going to say listBox. DataSource = ta.GetDataByPrice. And watch what happens when I hit the open parenthesis. Over here it says I need a price parameter to give to the query, so I'm going to use 40M--M for decimal--and then I need to uncomment this line of code and this line of code.

Here is a little trick. I'm going to highlight all four lines and then do Ctrl+K, Ctrl+U. Press F5 to run the application, choose to save the data, and there are all the products that are greater than $40. Now you have the general idea how to create a dataset. You still need to write code to work with the data, however. Watch the Binding movie in this chapter to see how to use the drag and drop designer to quickly set up data bindings in your user interface.

Find answers to the most frequently asked questions about Visual Studio 2010 Essential Training.


Expand all | Collapse all
please wait ...
Q: Which edition of Visual Studio 2010 do I need to follow along in this course?
A: The course is taught with Visual Studio 2010 Professional, but can also be used with the Premium or Ultimate editions. The Express editions of Visual Studio, including Visual Basic 2010 Express, Visual C# 2010 Express, and Visual C++ Express, are not covered in this course.
Q: I'm attempting to download the exercise files for this course, and my virus protection is blocking me from unzipping the downloaded file. Are the files corrupted?
A: The alert is a false-positive message. Your antivirus software is detecting the active code included in the exercise files, which in some ways resembles viral code. There is nothing to be alarmed about and you can ignore the warning. This is common among coding courses and environments.
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Visual Studio 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.