• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

How do i do select all record from dbgrid

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
greenfeild
Asked:
greenfeild
  • 2
1 Solution
 
greenfeildAuthor Commented:
Edited text of question
0
 
watyCommented:
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
 
greenfeildAuthor Commented:
i'm very appriciate your answer..
Your answer is much useful to me..
thank you..
very very thank you...

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now