How do I set the footer text for a GridView that has AllowPaging set
to True? I can only get the footer to appear on the first page but I
really want the same text to appear in the footer of all pages, how do
I do that?
Example Code:
Protected Sub Get_Data()
adsQuotes.Selec tCommand = "SELECT [Quote #] FROM [Quotes] WHERE
([Quote Price] 0)" 'access data source
adsQuotes.DataB ind()
gvQuotes.DataBi nd() 'Gridview (50 rows per page)
'show total records and total price in the footer
gvQuotes.Footer Row.Cells(0).Te xt = "Totals: " & lngTotalRecs 'the
footer only appears on the first page, why?
gvQuotes.Footer Row.Cells(1).Te xt = Format(dblTotal Price, "$#,##0.00" )
End Sub
to True? I can only get the footer to appear on the first page but I
really want the same text to appear in the footer of all pages, how do
I do that?
Example Code:
Protected Sub Get_Data()
adsQuotes.Selec tCommand = "SELECT [Quote #] FROM [Quotes] WHERE
([Quote Price] 0)" 'access data source
adsQuotes.DataB ind()
gvQuotes.DataBi nd() 'Gridview (50 rows per page)
'show total records and total price in the footer
gvQuotes.Footer Row.Cells(0).Te xt = "Totals: " & lngTotalRecs 'the
footer only appears on the first page, why?
gvQuotes.Footer Row.Cells(1).Te xt = Format(dblTotal Price, "$#,##0.00" )
End Sub