1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| Public Function GetValue(ByVal pField As String, _
ByVal pFiltre As String, _
Optional ByVal pDefaultValue As Object = Nothing) As Object
Dim lRequete As New System.Text.StringBuilder
Dim lResultat As Object
If pField Is Nothing OrElse pField.Trim() = "" _
OrElse pFiltre Is Nothing OrElse pFiltre.Trim() = "" Then
Throw New Exception("PARAMETREINCORRECT")
End If
lRequete.Append("select ").Append(pField).Append(" from ").Append(TableName).Append( _
" where ").Append(pFiltre)
Dim lCommand As New OracleCommand
lCommand.CommandType = CommandType.Text
lCommand.CommandText = lRequete.ToString()
lCommand.Connection = MyBase.GetConnexion()
lResultat = lCommand.ExecuteScalar()
If (lResultat Is Nothing OrElse lResultat Is DBNull.Value) _
AndAlso Not pDefaultValue Is Nothing Then
lResultat = pDefaultValue
End If
MyBase.CloseConnexion()
Return lResultat |