Sunday, August 14, 2011

My ADO.NET Training Notes


ADO.NET - Notes

Introduction

Hi, this blog is a collection of the notes i took while attending a training session on .NET; Not much theory or explanation has been included here, only screeenshots and examples, just thought it might be useful for someone. 

To learn/use the examples in this blog (or learn .NET in general), i suggest that you download and install, the Visual studio 2010 (or 2008) express edition and SQL Server Management Studio 2008 from the Microsoft website (You will easily find them by searching for them in google). Also, if you are a complete beginner to web technology (HTML, CSS, Database, ASP.NET), i suggest you go through the book "Beginning ASP.NET 4.0 in C# and VB"- Wrox Publication. Also,  the O'Reilly HeadFirst series of books on C#, Javascript, SQL etc are a great help in learning concepts involved in .NET.

P.S. Only the source code and screen shots for the applications have been given, the tables, DB and the construction of the forms should be performed by the user/reader.

Contents



  1. Using ADO.NET in WIndows Forms
  2. Search DB using Windows Forms
  3. Insert into a Table using Windows Forms Application
  4. Update Record in Table using Windows forms Application
  5. Delete Record from Table using Windows Forms Application
  6. Sample Student login and registration system using Windows Forms Application