Visual Basic

Public Overloads Function LoadOrdersData() As Data.DataSet
             Dim sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("SqlConn3").ConnectionString)
       Dim sqlDa As New SqlDataAdapter("spBackOrders", sqlConn)
       Dim sqlDs As New Data.DataSet

       sqlDa.SelectCommand.CommandType = Data.CommandType.StoredProcedure
       sqlDa.SelectCommand.Parameters.AddWithValue("@Customer", Session("CustCode"))
       sqlDa.SelectCommand.Parameters.AddWithValue("@Customer2", Session("CustCode2"))

       Try
           sqlConn.Open()
           sqlDa.Fill(sqlDs)
           sqlConn.Close()
           Return sqlDs
       Catch

       Finally
           If sqlConn.State = Data.ConnectionState.Open Then
               sqlConn.Close()
           End If
       End Try
   End Function