Home

How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio

Aug 5, 2010 09:49 PM

Colorful whimsical landscape with playful characters, mountains, and trees.

This five-part series on C# programming covers many things. First, you learn how to save to the Microsoft SQL Server. Then, you'll learn how to retrieve that data. You'll also learn how to navigate the DataSet, edit SQL data, and delete data. If you have Microsoft Visual Studio and SQL Server, give this lesson a try.

Video #1: Saving to SQL Server using C# and ADO.NET

Objects used: SqlConnectionString, SqlDataAdapter, Text Boxes, Button - click event.

Video #2: Retrieving Data from SQL Server using C# and ADO.NET

Objects used: SqlConnectionString, SqlDataAdapter, DataSet

Video #3: Using BindingSource to Navigate the DataSet with C#

Video #4: Editing SQL Data using the SqlDataAdapter UpdateCommand with C#

Video #5: Deleting Data from SQL using SqlDataAdapter and the DeleteCommand with C#

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.