selecting from datatable and binding to repeater

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,282
Latest member
RoseannaBa

Latest Threads

Top