CodeSnippets (Classes)

Here are some ready made classes to help you with simple tasks like connecting to the database etc.


1. Function to connect to the Oracle Database:


Create a class in App_Code folder

Public Class OracleDataAcc

Public Shared Function GetOracleConnection(ByVal Parid As String) As OracleDataReader

Dim conn As New OracleConnection("Data Source=XXX; User Id=XXX;Password=XXX;")

Dim cmd As OracleCommand = New OracleCommand

cmd.CommandText = "usp_XXX"

cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@ID", id)

conn.Open()
Dim dr As OracleDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

Return dr

End Function

End Class