On this tutorial, you will learn how to INSERT, UPDATE, and DELETE records to Microsoft SQL Server Database. The target audience of this topic are beginners. I will be using my own coding technique which I use in real life experience as a programmer. Before you can start, what you need is an SQL Server installed. Sample sourcecodes used throughout this tutorial series are compatible with either SQL sever versions: SQL 2000, SQL 2005 and SQL 2008.
Upon completion this tutorial series, you should be able to:
1. Know how to connect to SQL server
2. Know how to use how to query from SQL server using SqlDataReader class
3. Know how to Insert, Update and Delete Records.
Assumptions:
I assumed that you already performed the following:
1. Installation of SQL Server
2. Creation of SQL Database
3. Installation of Visual Studio 2005 or higher (Express/Professional/Enterprise)
Table Of Contents:
Topic 1: How to connect to SQL Server
Topic 2: How to SELECT records from SQL Database
Topic 3: How to INSERT record to SQL Database
Topic 4: How to UPDATE record on SQL Database
Topic 5: How to DELETE record on SQL Database
Sunday, June 07, 2009




1 comments:
i see that you are good in vb.net. sir i just want to ask something? if it could be possible to capture the activity of the command prompt to the richtextbox?
Post a Comment