Hi i have a following method
Public Function Bind() As DataSet
Dim sqlConn As SqlConnection = New SqlConnection(CManager.AppSettings("ConnectionString"))
Dim adapter As SqlDataAdapter = New SqlDataAdapter("Get", sqlConn)
Dim ds As New DataSet("ds")
adapter.SelectCommand.CommandType = CommandType.StoredProcedure
i am closing the sql connection and disposing the dataadapter after teh RETURN statement,will any statement after return execute ...?can any one tell me whats the best approach to go about it.