NullException Error,

See more:

SQL-Server-2005

VS2008

VB

, +

Hi!

I need help to sort NullException Error. The code is as given below. Pls. tell me what can be wrong. The error says: the function doesn't return any value on all code paths.


************* Stored procedure - GetAccountByCat************

USE [ERPFinAccounting]
GO
/****** Object: StoredProcedure [dbo].[GetAccountByCat] Script Date: 01/16/2011 10:45:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetAccountByCat]
@AccCat varchar(1)
AS

SELECT * FROM AccountsTable WHERE AccountCat = @AccCat


*********************** from class *********

#Region "GetAccountDetail - Return Information about all Accounts"
        Public Function GetAccountDetail(ByVal cat As String) As DataSet
            Dim localDSOutput As DataSet
            Dim ParamsStoredProcedure As String = "GetAccountByCat"
            Try
                Dim localOutPutServer As New DataServer(PrivateConnectionString)
                localOutPutServer.BuildParameter( _
                "@AccCat", cat, DataServer.SQLDataType.SQLChar, , ParameterDirection.Input)
                localDSOutput = localOutPutServer.returnDataSet(ParamsStoredProcedure)
                Return localDSOutput
            Catch ExceptionObject As Exception
                'LogException(ExceptionObject)
            Finally
            End Try
        End Function

**************************