?
Solved

How do i do select all record from dbgrid

Posted on 1998-09-10
3
Medium Priority
?
160 Views
Last Modified: 2010-04-30
i want to select all record from dbgrid..i can select dbgrid visibls row all record..how do i do select all record from dbgrid..help me...help me...i'm sorry..i can't English very well....
0
Comment
Question by:greenfeild
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:greenfeild
ID: 1434238
Edited text of question
0
 
LVL 14

Accepted Solution

by:
waty earned 400 total points
ID: 1434239
Here are 2 functions : Select / Deselect

Private Sub cmdSelectAllArticle_Click()
   ' *** Select all article
   
   Dim nI            As Integer
   
   dataBalayage.Recordset.MoveFirst
   Do While dataBalayage.Recordset.EOF = False
      DBGridBalayage.SelBookmarks.Add dataBalayage.Recordset.Bookmark
      dataBalayage.Recordset.MoveNext
   Loop
   
End Sub

Private Sub cmdDeselectAllArticle_Click()
   ' *** Clear all bookmarks
   
   Do While DBGridBalayage.SelBookmarks.Count > 0
      DBGridBalayage.SelBookmarks.Remove 0
   Loop

End Sub

0
 

Author Comment

by:greenfeild
ID: 1434240
i'm very appriciate your answer..
Your answer is much useful to me..
thank you..
very very thank you...

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses
Course of the Month14 days, 3 hours left to enroll

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question