Developing a Visitor manager software

Question

Hi all I am a student(Beginner) learning C# . i have been given a small project to develop a visitor management software. Main features of which are that: - store a picture of the visitor using a webcam - maintain all the database who has visited and who is still in. - print a card for the same visitor. I will appreciate if anybody can help me in this regard that how to develop this small(huge for me) software. I am planning to develop this software in window based application using C# should i take microsoft access or SQL server as the back end database. Any suggestions will be appreciated

Sriram Ramani · Answer

Hi Anoop U can use either of the databases. If u have sql server better use it. Else u can use the Access database itself. What u can do is that get all details from the visitor and store it in the database tables. For photo u can do 1)store the visitor's photo in ur local hard disk 2)store that photo's location in ur harddisk as a text in the database. (but u can directly store images in the database in sql server. visit http://www.codeproject.com/KB/database/ImageSaveInDataBase.aspx) Regarding printing a card u can use a reporting or u can use a print dialog control avl in vs Let me know about ur doings Anoop ....

Sriram Ramani · Answer

Hi Anoop U can use either of the databases. If u have sql server better use it. Else u can use the Access database itself. What u can do is that get all details from the visitor and store it in the database tables. For photo u can do 1)store the visitor's photo in ur local hard disk 2)store that photo's location in ur harddisk as a text in the database. (but u can directly store images in the database in sql server.) Regarding printing a card u can use a reporting or u can use a print dialog control avl in vs Let me know about ur doings Anoop ....