Rows() Property (1 Viewer)

LadyDi

Registered User.
Local time
Today, 16:35
Joined
Mar 29, 2007
Messages
894
I'm trying to create a form in Visual Studio and have run into something I can't get to work. I'm trying to set up a label to reference all the results in one query. I have everything set up, but I have to put Rows() in my variable and I have to put a number in the parenthesis or it won't run. When I put in the number, then it only shows the records at that index. Is there a way to make the Rows() display all the records - the most records it can have are 5. I've tried putting in Rows(0,1) and Rows(0-5) and Rows(*), but nothing works. Do you have any suggestions. Here is the code I have behind my label.

Code:
Me.TA_Error_Codes.FillBy(DS_CV_Calls_DB.Error_Codes_tbl, Me.cbo_Location.SelectedValue)
        If DS_CV_Calls_DB.Error_Codes_tbl.Count > 0 Then
            Dim errorCodes As CV_Calls_DBDataSet.Error_Codes_tblRow = DS_CV_Calls_DB.Error_Codes_tbl.Rows(0)
            Me.lbl_ErrorCodeRef.Text = errorCodes.Error_Desc
        End If
 

Users who are viewing this thread

Top Bottom