<WebMethod()> _

    Public Function getReqs() As System.Xml.XmlDocument

    Try

        Dim dbConn As OleDbConnection = GetConnection()

        Dim dbCMd As New OleDbCommand

        Dim dbAdapter As New OleDbDataAdapter

        Dim dbReqs As New DataSet

        dbCMd.CommandText = "SELECT [reqID],[type],[Device],[releaseType] as [tech],[complete],[newVers],[product],[date] FROM [reqs] AS [reqs]"

        dbCMd.Connection = dbConn

        dbAdapter.SelectCommand = dbCMd

 

        dbReqs.DataSetName = "Reqs"

        dbAdapter.Fill(dbReqs, "[reqID]")

        dbConn.Close()

 

        Dim xmldoc As New System.Xml.XmlDocument

        xmldoc.LoadXml(dbReqs.GetXml())

        Return xmldoc

 

    Catch ex As Exception

        Return Nothing

    End Try

End Function