Re: customize paging in asp.net

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/19/04 

Date: Wed, 19 May 2004 14:07:43 -0400

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/
"aftab" <kaftab@sstil.com> wrote in message
news:emhhy%23bPEHA.736@tk2msftngp13.phx.gbl...
> 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
>
>
>
>
>

Relevant Pages

  • Re: Size of SQLServer databases with indices
    ... > I am starting to examine using SQLServer instead of Oracle. ... I then checked the size of the database. ... In SQL Server, yes, indexes take up space. ...
    (microsoft.public.sqlserver)
  • Re: ADO.NET and SQL, Oracle
    ... Miha Markic [MVP C#] wrote: ... >> at the moment a large pack of feature which are absent in SqlServer ... > I like Sql server more than Oracle becuase: ... > Perhaps Oracle is a better database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Multiple Database Support - .NET 2.0
    ... > that's not bound to any particular database. ... sqlserver has named parameters, ... sqlserver uses SCOPE_IDENTITYfor identity fields, oracle / ... > This is something different than Object-Relational Mapping (ORM). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: synchronization with heterogeneous tables and referential integrity
    ... In my application's database design there are entities which have foreign keys referenced to some tables that should be maintained by the accounting application in SQLServer. ... My idea is to build "shadow" tables in Oracle with the same structure of the SQLServer tables and implement a scheduled batch process that keep them synchronized with SQLServer using a database link and Heterogeneus Services. ...
    (comp.databases.oracle.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)