customize paging in asp.net

[aftab]

Hi
As i am doing a search results page where we have to list
lots of results using paging in ASP.NET. I have two
different databases one from sqlserver and one from oracle.
so i have to query the tables in Sqlserver and oracle and
fetch the results.

say for example i have fields
hotelID and hotelName in sqlserver

and hotelDesc and hotelAmenities in oracle server.

So when putting a search i have retreive all the four fields
in a row fashion in the format of numbered paging and also
a <next page> link (if a person not selecting a numbered page,
he can move to next page) , provided with all these i have to
format each result (each record fetched from both database)
with images and links. And there is no relational field between
these two database servers.

I tried with Datagrid but customization is limited here.

can u pls provide a solution as fast as possible as my deadline for the
project is nearing, it will be really helpful for me.
Aftab

 

[William Ryan eMVP]

What logic are you currently using to match the data from the first
datatables to the second one. If you can do this manually we can get there
programatically. Also, remember that you can define datarelations between
datatables that have no 'real' physical relation in a database. you can
even create your own DataColumns and use these to relate things back to each
other.

Can you let me know a little more about how you are currently matching the
data up?

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/