Some times back the visual basic was the mostly widely used for developing applications. The VB is most popular for its graphical environment. The Visual Basic .Net is the extension of visual basic programming language. The new language provides many new features. If we compare the VB with VB.NET, there are huge changes in all areas. The VB.NET is designed to take advantage of the .NET framework classes. New features (in comparison with VB) 1).

Stored procedures are series of SQL statements grouped into a single unit, we can pass parameters to the stored procedures same like the passing parameters to the functions Simple stored procedure USE [databasename] GO /****** Object: StoredProcedure [dbo].[user_insert_mycomment] Script Date: 11/19/2008 22:45:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

We have 4 types of Exceute methods, through which we can excecute the quries angainst Database. 1). ExecuteNonQuery(() 2). ExecuteReader() 3). ExecuteScalar() 4). ExceuteXmlReader() 1). ExecuteNonQuery(() Explanation: Executes a command but does not return any value or output usage conditions: UPDATE, INSERT, DELETE statements using System; using System.Data;