Looping Access database table

  • (2 Pages)
  • +
  • 1
  • 2

15 Replies - 843 Views - Last Post: 02 July 2013 - 01:27 AM Rate Topic: -----

#16 fanglign  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 48
  • Joined: 24-June 13

Re: Looping Access database table

Posted 02 July 2013 - 01:27 AM

View Postvks.gautam1, on 02 July 2013 - 01:20 AM, said:

View Postfanglign, on 02 July 2013 - 01:02 AM, said:

View Postvks.gautam1, on 02 July 2013 - 12:50 AM, said:

ur query is not what result you want and there is no coding you are doing to populate your data in datagridview.
use this link . only difference is to use Oledb in place of SQL client given in example.


now my problem is i dont know got to code for where clause to populate the data i want. cause all the examples i read was specifying the criteria like country=Mexico
and now i cant list all the module codes out as the data varies as the file changes, and there are over 30k records.

i dont know what should i put in instead of listing the module codes.
Appreciate for your help

how you want to select particular " module code"? where you will input your module code to retrieve particualr "module code"


sorry i dont quite understand what you meant.

hmm, i was thinking of using the WHERE clause with sql select statement
and for the module code i wanna retrieve the distinct data. I know how to obtain distinct data using select distinct
i want to put into datagridview with 2 columns, moduleCode and AdminNo
the output should be like:
EG3901 12344Y
-blank- 23456H

EG3902 64738U
-blank- 99393J
-blank- 63738B

.
.
.

Thank you for you patience

This post has been edited by fanglign: 02 July 2013 - 01:33 AM

Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2