Using Linq to paginate your ObjectDataSource.

Vb.net
'execute Linq query for result set
Dim result As IEnumerable(Of ZipCode) = (From zipcodes In ZipCodeInstance).Skip(0).Take(20)
C#
//execute Linq query for result set
IEnumerable<zipcode> result = (from zipcodes in ZipCodeInstance select zipcodes).Skip(0).Take(20);

Now viewing 1 to 20 out of 43191 records
ZipCityStateLatitudeLongitudeTimeZoneDst
00210PortsmouthNH43.005895-71.013202-51
00211PortsmouthNH43.005895-71.013202-51
00212PortsmouthNH43.005895-71.013202-51
00213PortsmouthNH43.005895-71.013202-51
00214PortsmouthNH43.005895-71.013202-51
00215PortsmouthNH43.005895-71.013202-51
00501HoltsvilleNY40.922326-72.637078-51
00544HoltsvilleNY40.922326-72.637078-51
00601AdjuntasPR18.180103-66.74947-40
00602AguadaPR18.363285-67.18024-40
00603AguadillaPR18.448619-67.13422-40
00604AguadillaPR18.498987-67.13699-40
00605AguadillaPR18.465162-67.141486-40
00606MaricaoPR18.182151-66.9588-40
00607Aguas BuenasPR18.256995-66.104657-40
00609AibonitoPR18.142002-66.273278-40
00610AnascoPR18.288319-67.13604-40
00611AngelesPR18.279531-66.80217-40
00612AreciboPR18.449732-66.69879-40
00613AreciboPR18.458093-66.732732-40

>> next


A Programmers Journal | rss