Interfacing a micro controller to a PC is possible. There are many ways of doing that. You can use a wired link or a wireless link as you prefer. Connecting via the PC serial port to a UART of the MCU is the simplest way I think. And yes you can use .NET for this purpose. I don't have much experience with VB, but you definitely can using C#.
Obtaining the pin code from the microcontroller and looking up in the database will not be a heavy task and that depends on your VB skills..
On the event of a power interruption, your microcontroller program can get to know it and then it can save user inputs in its NVRAM and once the power is up it can send those info to the pc. This is just an idea, there might be different ways of achieving this task.
I just answered your questions.. Post YOUR design ideas here and I'll try to help you as much as I can.
Post YOUR design ideas here and I'll try to help you as much as I can.
Honestly speaking we still dont have the design as of now... we cant even come up on the schematic diagram of it... for nearly a month now i've been surfing the net for idea and possible schematic diagram of it, but until now NO accomplishment.
recently my group had decided about the power interruption situation. in cases it will occur, stand alone setup will be use. like administrator key will bypass door locking system, thus it will serve as login/logout of the users on the said room.
this video is somewhat near our project:
YouTube - Electronic Lock PIC16F877A
currently where trying to create a program on C using an MPLAB IDE program compiler/debugger
where hoping if someone can share a codes on C that we might study on it and get the idea how to create our own.
and also how to interface it on Vb.net using seril port(not sure of it).
i'm really a newbie on this.
on our MCU where going to use:
MCU parts:
3x4 keypad
serial cable (between PC and MCU)
solenoid magnet for door lock
solenoid magnet(buzzer) for alarm
VB.net:
manual override in cases of malfunction on MCU
monitor mode ( to check if room is lock/ unlock)
room scheduler ( to input new schedules)
thats all our idea for now.
thank you for the replies. where hoping for more