accessing active directory

[stucker79]

I am working on setting up a training program for work. Each users name will go in a database where it will be paired up with various courses. I would like to retrieve the users from the AD and populate a Sql table with this information. I know how to get the users out of AD and put them into a dataset and consequently get them into a SQL Table. My question is this: what is the best way to sync up this information? Should I create a diffgram? Is this idea just a bad idea to begin with? The reason for doing this is so that we don't have to maintain a list of users in sql. Thanks in advance for any help you can provide.

 

[ThatRickGuy]

Check this thread:

http://www.tek-tips.com/viewthread.cfm?qid=948326

the first post uses the WMI to get the user name, but you can remove the "WHERE Name = System.Environment.Username" part and it will return a list of all users. Not sure if it crosses domains or not, but I think I remember pulling up a list of everyone on the network here with that.

-Rick

----------------------

http://www.ringdev.com