return dataset in presentation layer

Hi
How can I access my getquery  function from businesslayer in my userinterface aspx.vb page so that it returns a dataset.


 Public Function getquery(ByVal parm1 As String, ByVal parm2 As String,
     Optional ByVal parm2 As Boolean = False) As DataSet

        Try
         
            getquerydata = iobj_DataAccessLayer.GetQueryDataSet(parm1, parm2 and so on )
        Finally
            If Not (iobj_DataAccessLayer) Is Nothing Then iobj_DataAccessLayer.Dispose()
        End Try
    End Function

getquery  is my function in business layer

GetQueryDataSet  is a method in dataaccess layer that returns dataset


PNKJAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
molkuConnect With a Mentor Commented:
Put a return statement in your Function. You can then call it from your code behind like:
Dataset ds = yourBusinessLayerObject.getquery("parm1", "parm2", false)
Public Function getquery(ByVal parm1 As String, ByVal parm2 As String,
     Optional ByVal parm2 As Boolean = False) As DataSet
 
  Try
    return iobj_DataAccessLayer.GetQueryDataSet(parm1, parm2 and so on )
  Finally
    If Not (iobj_DataAccessLayer) Is Nothing Then
       iobj_DataAccessLayer.Dispose()
  End Try
 
End Function

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.