[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

[stanav]

Put it in a Try Catch block?

[effekt26]

Put it in a Try Catch block?

well, it was, how ever it was just giving me the error. It was a index outside of bounds error. Sorry, i meant to say that the line that errors is the

Dim objDocuments(dtaSet.Tables(0).Rows.Count - 1) As Document

--EDIT

i have now got it working. needed to use a variable that would default to zero.

Thanks, Justin