[RESOLVED] when dataset executes stored proc..error

[effekt26]

Hello all,

I currently have the below code, which is used to execute a data adapter fill method...

currently it executes a stored procedure. however, when no results are returns, it gives an error. the procedure doesnt need to give any results, as its a search function.

here is the code below.

Public Shared Function SearchDocuments(ByVal Query As String, ByVal SearchString As String) As Document()
            Dim dtaLayer As New DataLayer
            Dim htParameters As New Hashtable
 
            htParameters.Add("@searchString", SearchString)
 
            Dim dtaSet As DataSet = dtaLayer.ReturnParametisedDataSet(Query, htParameters)
 
            Dim objDocuments(dtaSet.Tables(0).Rows.Count - 1) As Document
 
 
            For i As Integer = 0 To dtaSet.Tables(0).Rows.Count - 1
                Dim objDocument As New Document
                objDocument.DocumentCode = Convert.ToString(dtaSet.Tables(0).Rows(i)("document_code"))
                objDocument.Title = Convert.ToString(dtaSet.Tables(0).Rows(i)("document_title"))
                objDocument.Description = Convert.ToString(dtaSet.Tables(0).Rows(i)("document_description"))
                objDocument.Category = Convert.ToString(dtaSet.Tables(0).Rows(i)("category_title"))
                objDocument.DateAdded = Convert.ToDateTime(dtaSet.Tables(0).Rows(i)("document_date_added"))
                objDocument.DateOfRevision = Convert.ToDateTime(dtaSet.Tables(0).Rows(i)("document_date_revision"))
                objDocument.DateLastRevised = Convert.ToDateTime(dtaSet.Tables(0).Rows(i)("document_last_revised"))
                objDocument.Author = Convert.ToString(dtaSet.Tables(0).Rows(i)("document_author"))
                objDocument.Version = Convert.ToString(dtaSet.Tables(0).Rows(i)("document_version"))
 
                objDocuments(i) = objDocument
 
            Next
 
 
            Return objDocuments
 
        End Function

how do i stop it from breaking when no results are returned.

Thanks, Justin