Join Walt Ritscher for an in-depth discussion in this video Using ADO.NET in your application, part of Visual Studio 2010 Essential Training.
ADO.NET is the core library for accessing data from relational and ODBC databases.…There are a number of specialized namespaces, but for today's example, I'm going…to use the SQL client classes.…I am going to start by showing you some basic ADO.NET code.…I'll show you how to connect to a database.…We'll execute queries against the database using the command object, and then…I'll show you how to store data in a local cache, known as a DataSet.…I am inside of Visual Studio, and I've opened a solution called WorkingWithAdo.…Inside that is a project that already contains a database called northwind.mdf,…and it contains a form, Form1.cs.…
If I open up this user interface, I'll see there are three buttons and one list box.…I am going to start by showing you how to connect to the database.…I'll do that by double-clicking on this Connect button, which will take me to my C# code.…To get a little more screen real estate, I am going to close this output window…on the bottom of the screen.…Before you do anything with the database, you need to create a connection.…
- 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
Skill Level Intermediate
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.
1. Getting Started
2. Exploring the Visual Studio Workspace (IDE)
3. Building a Simple Application
4. Exploring the Code Editors
5. Working with Code
6. Understanding the Project Types
7. Digging Into Your Data
8. Debugging Your Application
9. Testing Your Application
10. Deploying Your Application
11. Working with Source Control
12. Integrating with Microsoft Office Applications
Making an Excel 2010 add-in5m 21s
13. Extending Visual Studio
14. Configuring Your Application
- Mark as unwatched
- Mark all as unwatched
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.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.