How to Use sort property


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: How to Use sort property

  1. #1
    Saiful Guest

    How to Use sort property


    How do you use the Sort property of the ADO Recordset? Any example.

    I wish to sort on two column fields. Say AParam first then followed by ASequence.

    How do my Sort statement looks like assuming my recordset is RS.

    RS.Sort ???

    rgds,
    Saiful

  2. #2
    Erwin Guest

    Re: How to Use sort property

    Try this

    strSort = Fieldname1 & Fieldname2 & " ASC"
    AdoRS.Recordset.Sort = strSort

    Erwin


    "Saiful" <md-saifulamri_omar@hp.com> schreef in bericht
    news:39ae6763$1@news.devx.com...
    >
    > How do you use the Sort property of the ADO Recordset? Any example.
    >
    > I wish to sort on two column fields. Say AParam first then followed by

    ASequence.
    >
    > How do my Sort statement looks like assuming my recordset is RS.
    >
    > RS.Sort ???
    >
    > rgds,
    > Saiful




  3. #3
    dhruvesh Guest

    Re: How to Use sort property


    read "ADO tutorial" in microsoft MSDN help for VB



    "Saiful" <md-saifulamri_omar@hp.com> wrote:
    >
    >How do you use the Sort property of the ADO Recordset? Any example.
    >
    >I wish to sort on two column fields. Say AParam first then followed by ASequence.
    >
    >How do my Sort statement looks like assuming my recordset is RS.
    >
    >RS.Sort ???
    >
    >rgds,
    >Saiful



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center