Saturday, December 24, 2005

Using Stored Procedures in VB.net

writing an insert statement
CREATE PROCEDURE sp_InsName
@FirstName varchar(20),
@LastName varchar(30)
AS
BEGIN
INSERT INTO Names(FirstName, LastName)values(@FirstName, @LastName)
END
GO
This doesnot return any values, if we need to call it in vb.net then
add key="GMR" value="server=localhost;database=databasename;uid =userid pwd =password;"
Public ObjCon As New SqlConnection()
Public Sub OpenApplicationConnection()
ObjCon.Close()
ObjCon.ConnectionString = ConfigurationSettings.AppSettings("WebTeam")
ObjCon.Open()
End Sub

Public Function ExecuteQry(ByVal strsql As String) As Boolean
OpenApplicationConnection()
Dim cmdExecute As New SqlCommand(strsql, ObjCon)
cmdExecute.CommandText = strsql
cmdExecute.ExecuteNonQuery()
cmdExecute.Dispose()
End Function

OpenApplicationConnection()
strsql = "sp_InsName 'Abc', 'DEF'"
ExecuteQry(strsql)

No comments: