Using ADO.NET in your application


show more Using ADO.NET in your application provides you with in-depth training on Developer. Taught by Walt Ritscher as part of the Visual Studio 2010 Essential Training show less
please wait ...

Using ADO.NET in your application

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

Using ADO.NET in your application
Video duration: 6m 50s 8h 9m Intermediate

Viewers:

Using ADO.NET in your application provides you with in-depth training on Developer. Taught by Walt Ritscher as part of the Visual Studio 2010 Essential Training

please wait ...