<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