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

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

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#

(1) Part 1 of 5 - How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio, (2) Part 2 of 5 - How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio, (3) Part 3 of 5 - How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio, (4) Part 4 of 5 - How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio, (5) Part 5 of 5 - How to Add, save & retrieve data in SQL Server using C# programming & Visual Studio

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

9 Comments

very insightful. Big thanks!!!

Love them. Great great help. out of 10 I'm giving the a 10. Wish i could download them though. Great stuff!

Thanks man. Nice tutorials. Can you show how to do the same using WPF and TableAdapters?

very nice ...

My question is, how would i copy/paste and insert data from datagrid view?

Share Your Thoughts

  • Hot
  • Latest