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
5 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?
hi.. thanx for the vb.net tutorial.. please post a tutoria regarding the datagrid in vb.net thanx..
hi i am working as a computer programmer.. Im new to this language vb.net and i wanted to learn from the basics.. i have a question.. why is iti cant declare sqldatareader(). it says that its not accessible in this context because its FRIEND.. whats that?
@sassin
- you should include the following namespaces
Imports System.Data
Imports System.Data.SqlClient
great! im beginner... thank you very much 4 tutorial!
Post a Comment