D
drdave
When I try to bind to the row object in the code below I get object
reference error... I've searched and not been able to come up with a
solution.. maybe it can't be done??
For Each x in YearArrList
n = (x + 1)
n = "12/31/" & n
x = "12/31/" & x
Dim filterstatement As New StringBuilder
filterstatement.append ("effective_date >
#").Append(x).Append("#").Append("And effective_date <
#").Append(n).Append("#").Append("AND prov_prov_id = ").Append(y)
Dim Row As DataRow
Dim Filter As String = (filterstatement.ToString())
'Response.Write (Filter & "<br>")
Dim MatchRows() As DataRow = dset.Tables("Table").Select(Filter)
For Each Row In MatchRows
rptwage_amount.DataSource = Row <----------------------
'Response.Write(Row("effective_date").ToString() & " " &
Row("minimum_wage_amount") & " " & Row("prov_prov_id") & "<br>")
End If
next
Next
any help or samples appreciated..
Dave
reference error... I've searched and not been able to come up with a
solution.. maybe it can't be done??
For Each x in YearArrList
n = (x + 1)
n = "12/31/" & n
x = "12/31/" & x
Dim filterstatement As New StringBuilder
filterstatement.append ("effective_date >
#").Append(x).Append("#").Append("And effective_date <
#").Append(n).Append("#").Append("AND prov_prov_id = ").Append(y)
Dim Row As DataRow
Dim Filter As String = (filterstatement.ToString())
'Response.Write (Filter & "<br>")
Dim MatchRows() As DataRow = dset.Tables("Table").Select(Filter)
For Each Row In MatchRows
rptwage_amount.DataSource = Row <----------------------
'Response.Write(Row("effective_date").ToString() & " " &
Row("minimum_wage_amount") & " " & Row("prov_prov_id") & "<br>")
End If
next
Next
any help or samples appreciated..
Dave