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.
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