Client\server attendance system over LAN (VB.NET and SQL server)

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I'm trying to develop a Client\Server Attendance system which will work over LAN. Server will be handled by administrators and running on a admins PC. Client program will be installed in students and faculty PC. Each successful logins counting attendance for each user in day and schedule basis. Design and layout is completed and Database transaction functioning very well. I want server and client separated installer which will work on basis on successful LAN connection. All operations (Add user/student/faculty/department/subject) handled by standalone user Admins and rest will be handles by other personals.

How to make separate client and server application ?
How to attach database with my server application and access the database from n-number of client ?
How to release\publish them ?

Front End: VB.NET (Visual Studio 2013)
Back Emd: SQL Server 2008

What I have tried:

Application layout design.
SQL Database design and configurations, Permissions.
Authentication testing.
Encryption Testing.
Successful LAN configuration.
Testing over Debugging mode.

Posted 20-Dec-17 10:16am

Babai JermenKeller Sasmal

Updated 20-Dec-17 17:49pm

Add a Solution

Comments

F-ES Sitecore 20-Dec-17 16:19pm

This isn't a code on demand service where you list vague requirements and we spend our time doing your work. Your question is far too broad to answer and if you don't even know where to start then the task is probably beyond you.

Babai JermenKeller Sasmal 20-Dec-17 16:25pm

Im not looking for codes sir. Im looking for suggetions to develop a client and server separately and some guides over attachment of sql database with my project and also want to know that will this work over LAN ? if so how can i design them. Thank you for everyone precious time.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Accepted Answer · 2017-12-20T17:49:00

Solution 1

Quote:
How to make separate client and server application ?

Technically, you shouldn't have a server app because it is the standard 'SQL Server', nothing more.
So I don't know what you try to do with an app on server side.

In case you server app is about handling Admin features, it is easier to do 1 app for all and activate features depending on user credentials.

Posted 20-Dec-17 17:49pm

Patrice T

Comments

Babai JermenKeller Sasmal 21-Dec-17 4:39am

I want to develop two separate program one will handle database running on admin pc. and second piece of program work as client over LAN which activate feature depending upon user credencials. Thank you for replying

Patrice T 21-Dec-17 6:30am

The admin pc is another client pc.

Babai JermenKeller Sasmal 15-Feb-18 8:30am

will you explain more about server app ?

Client\server attendance system over LAN (VB.NET and SQL server)

1 solution

Solution 1

Add your solution here

Preview 0

Client\server attendance system over LAN (VB.NET and SQL server)

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us