Front End for SQL Database 2016 connection

Lydia Russell

Hi, I have created a backend Employee sign in/out database and need to create a front end. Please tell me what is the easiest method to create this front end and some guidelines on how to do it.

Please find attached a visual to the image gallery, hope you can see it.

Scenario:

Staff member arrives to work, goes to iPad and searches for their name. Then selects their name, then ticks the In box.

Staff member leaves, selects their name, then ticks the Out box.

Just need a status of which staff names are In and which are Out.

Any assistance greatly appreciated. Thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
Your question seems in wronog category.

Your selected category is VB.Net and you are asking for an app to be run on ipad.

Either you have to use Xamarin or Cordova for cross-platform development, or develop altogether for iOS only.
Lydia Russell9y ago
It's part of the solution. It doesn't matter what it is for. The main issue I am trying to get across here is to create a front end.
If Xamarine is what you recommend, I will focus on learning that. This is a first project working in Visual.net so I was hoping for some feedback. No questioning why I am doing it.
Nitin Sontakke9y ago
Are you saying this will be used ONLY when there is fire in the building?
Lydia Russell9y ago
The purpose of this is due to Safety, if there is a fire in the building, no one knows who is in and who is out.
This type of setup would work for our organisation. Currently staff manually sign a form in hard copy to say they are in.
Nitin Sontakke9y ago
When you mention iPad, the front-end got to be the one which runs on it. Which means you will need to look into Xamarine, assuming you are from the Microsoft clan.

Personally, I believe that, howevermuch modern this may sound, this approach (of attendance) is quite convulted.

Can you not just use do something where by tracking the location of the phone in a particular zone or something. I think your app should tell the employee that he has been signed in and signed out. Otherwise, what's the point? Emplyees have been searching, picking and punching their respective cards for a long time now.