Results 1 to 2 of 2

Thread: My doubts in ADO

  1. Mar 2nd, 2005, 01:06 AM #1
    mahivr
    mahivr is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2004
    Location
    india
    Posts
    95

    My doubts in ADO

    hi,

    i have some question/doubts about ADO.NET

    1. If i use dataset with paging (ex 1000 pages). how the records fetched from Database,it fetches all pages in single request or fetched according to the page the user cliked?

    2. how to implement disconnected natures using dataset



    v.r.mahendran
    Reply With Quote Reply With Quote
  2. Mar 2nd, 2005, 06:25 AM #2
    dj4uk
    dj4uk is offline
    Frenzied Member dj4uk's Avatar
    Join Date
    Aug 2002
    Location
    Birmingham, UK Lobotomies: 3
    Posts
    1,131

    Re: My doubts in ADO

    1. If you are using ASP.NETs built in paging it still passes all the records from the database to the ASP.NET application. You need to implement your own custom paging only to return the records you will display client-side from the database.

    2. The dataAdapter you use to fill the dataset should handle the opening and closing of the database connection.

    HTH

    DJ
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width