Creating A Logon System To Check Users In SQL2008 Express?
Jun 21, 2010
I am currently creating an application to track timekeeping (a clock in/out system) and I am trying to work out the best way to do this.
I have a Main Form which contains buttons to ;
- Log in
- Out for Break
- In from Break
- Log out
When a user presses the "log in" button the logon form appears, the user then enters their username and password. What happens next is where I would like the help.
Process is as follows:Click Logon Enter Username/Password Check Logon Form for errors (eg no password etc) Check User is in Database (using SQL query) If user is in DB and username and pass are ok then refer back to the main form to perform Stored Procedure for what the user wants to do (eg logon or or out for break etc). Set label on main form to show user as logged on My question is should I be using a public variable and calling the main form again or in the user logon form having 4 options and using an IF ELSE to select the appropriate Stored Procedure?
View 3 Replies
ADVERTISEMENT
Jan 14, 2009
I haven't been doing a programming for awhile now. But, I was a VB programmer before. I will be creating a tool to log issues encountered by the users of our system. It will be a web based. I'm planning to create it in VB.Net. Any resources that you could share is greatly appreciated. I'm looking for a ready program that I could start with to speed up my programming.
View 1 Replies
Jun 10, 2012
i have a program where the high scores will be saved in a txt file. of course, if the file is already in use, saving the text file won't work. is there an if statement i can do to check if it is in use? or could i check the last access time, and the last modify time and if the modify time happened after the access, i know its closed, and if the access time happened after the last modify time it is still in use?
View 4 Replies
Dec 10, 2009
I need a way to find out which options of ExitWindowsEx are supported by the users system (in Form1_Load).How can I do this?
View 7 Replies
Oct 27, 2009
I use ExitWindowsEx to shut down/reboot computers, or log off users.
View 3 Replies
Jun 30, 2010
I'm using VS2010 and SQLServer 2008. I'm trying to test for DBNull in datafields, but every formulation of a test I have imagined (or found) throws an error. Specifically,"The value for column 'ColumnName' in table 'TableName' is DBNull." (system.data.strongTypingException).Well, not too helpful. I know it's DBNull, and I want VB to recognize this.Here is what I've tried so far (all with the same result).
[code]...
View 7 Replies
Jun 30, 2010
Is there a way to programmaticly get the failed logon count for local Windows users in XP and later? Alternatively, is there a way for my service to get a message when a failed logon occurs? Currently coding in VB.NET, but will take any suggestions in any language.
View 2 Replies
Sep 24, 2009
I would like to pull a set of records in a SQL sproc by passing in a list of system.guid and also by passing in a list of integer keys.I can put the guids ihto a string, of course, but the question is - how do I quote the test values so they are recognized as UIDs by SQLIn essence I was to DECLARE @pklist AS VARCHAR(1000)-- This would look like "'45F4AE2A-D27C-D711-83FD-0008C7FA9683','EC824D02-D37C-D711-83FD-0008C7FA9683','BA8E4D02-D37C-D711-83FD-0008C7FA9683'" coming out of the execsql from vb .net - I think :-) but it seems it needs to look likeSET @pklist = '45F4AE2A-D27C-D711-83FD-0008C7FA9683,EC824D02-D37C-D711-83FD-0008C7FA9683,BA8E4D02-D37C-D711-83FD-0008C7FA9683'SELECT * from dbo.members WHERE members.cpk IN (@pklist)This only returns the record matching the first UID in the string. Is there something I can wrap a t-sql VARCHAR string with so each guid will be seen distinctly?In trying to do this with a list of integer keys, the problem is the value is seen as part of a string and is not cast to an integerIt would seem creating a table from a parsed version of the string passed in and then doing a JOIN would accomplish what I need as well, but struggling with the T-SQL syntax for that.
View 1 Replies
Mar 13, 2009
I am trying to make a basic ATM system, iv got all the interface done and I have made the link to my SQL database etc. the part i'm stuck on is how I can run a check to see if a bank card number matches up to the users PIN number. To simulate the user putting a card into the machine I've used a combo box, and that lists all the cards, that haven't been flagged as confiscated (there's a column in my ATMCards table that I can set to true or false) then after the user has selected a relevant card there's another text box where they can enter in their PIN number.
Now what I want to do is, if they chose the card number 1234567890123456 in the combo box and they enter in the PIN 1234 into the text box, then, after clicking the check PIN Button if the pin is correct they need to be taken to another from where they can check their balance etc., and if its wrong they got three attempts after which point i want to flag that card as confiscated.
View 4 Replies
Jun 6, 2010
I have coded up a service, and I would like it to monitor when a user logon to the system fails. Is there an event I can handle for this? Or, a message that is broadcast? Or, is it possible to get the failed logon counter for the local system?
View 4 Replies
Jun 19, 2010
is there a code for showing my system login/logon password?i am using visual basic express 2008 /Forms.
View 8 Replies
Jun 16, 2011
I am writting a program to sendout email by reading from SQL database and get the data out for the email information: To, From, subject, body and attachment. I am importing system.net.mail. But My email will send without any attachment but it will not send with the attachment. It give me this error: Logon Failure: Unknow UserName or bad password. However if I send the email with the attachment that is not get from the sql database. It will send just fine.
[code]...
View 2 Replies
Aug 20, 2011
I am wanting to create a logon similar to the Windows Live logon, so in other words. user has frmLogon and is located in Australia. The user enters his/her details and then the program connects to a server in the United States and checks the Username and Password to make sure it is correct if it is correct it allows the user to logon and move to the next stage, if it is wrong it will give him an error message. I am wondering if anyone has a tutorial or source code laying around that I can rip apart and see how it works. I want to put the database on my server and connect to it from my desktop using the logon form.
View 3 Replies
Apr 25, 2010
I am not capable of creating different users that have different authorization using vb.net.
View 5 Replies
Jan 26, 2011
I am having trouble creating inactive users in VB. I watched the tutorial [URL]but it is for C# and the code behind won't work in VB. I need the users to be inactive when they register and send the administrator an email saying someone has registered to be approved.
View 3 Replies
Jun 4, 2012
My project is to create a windows application for communicating between users on our LAN, to both send and receive short text messages. I am attaching a rough draft of my Form in Basic, with notes about what I want in the different parts. I am only trying to find out if my goals are possible in VB-2010, before I invest a lot of time searching for and experimenting with the code... so here are my initial questions:
1) Is it possible to build such an application in Visual Basic 2010, and would I be able to use the free "Express" version I have downloaded, or would I need to purchase the full version?
2) Basically, each user would run the EXE program which is the main window (like the attached), and would see all users connected to the LAN (and listening on the specified port) in the ListBox... would receive incoming messages in the top window (output from a console module I have already got working), and be able to send to anyone on the LAN using the bottom window... Is all of this possible in VB-2010?
3) Is there any complications making this application work well on both Windows XP and Windows 7 (64bit) user machines?
I don't expect this to be easy by any means, I just want to know if I'm embarking on something that is possible or not.
Attached image(s)
View 10 Replies
Jul 17, 2009
So I had a report I needed to create and needed to get the total users per job for a system that I was not (and still am not) very familiar with. I asked the developer for that system for the code and was told it was no easy task. He sent me a query that didn't look anything like a user count. I told him I needed something to get all the users for each and every job in order to put it in the report I was building for one of the clients. I was told that wouldn't really work. I looked at his code as it worked on a per job basis.
The following is an example of the "logic" used to get the user count per job in asp.net:
TRUNCATE TABLE1
INSERT username INTO TABLE1 FROM QUERY1 WHERE CRITERIA MET AND job = *passedinjob
INSERT username INTO TABLE1 FROM QUERY2 WHERE CRITERIA MET AND job = *passedinjob AND username NOT IN TABLE1
SELECT username FROM TABLE1 and put in a dataset
[Code] .....
There were no UNION statements in the query1 or query2, there was no select count(*) from table, there was no recordset.count..
View 1 Replies
Jun 28, 2011
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too. I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TextBox1.Text = My.Settings.TextBox1
[Code]....
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
View 4 Replies
Aug 29, 2009
I have created a multiuser application and at different user login i want to create different instances of the application.How to do this? Can somebody give the concept of how to approach this?
View 14 Replies
Jul 5, 2010
how can i tell if its the users first run of the application on there machine?
View 6 Replies
Jun 28, 2011
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too.I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TextBox1.Text = My.Settings.TextBox1
End Sub
[code]....
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
View 1 Replies
Oct 19, 2010
I am currently creating a tool that can manage local user accounts on Windows-PCs. I am using the functions described on
this MSDN page ; and after some struggling, I got most of them to work.
Unluckily, I haven't found a way to set the option "User must change password at next logon" while creating a new user account. I use the
NetUserAdd -Function to create the new user. I set the level to 1 and supply a
USER_INFO_1 -Structure . This structure accepts flags, and the flag UF_PASSWORD_EXPIRED seems to be exactly what I want - but when I set it, the user can log on without changing the password first...
I'm developing on Windows 7 Ultimate 64-Bit using Visual Studio 2010 Express.
Here's my code:
#Region "Constants"
Public Const UF_PASSWORD_EXPIRED As Integer = &H800000
Public Const USER_PRIV_USER As Integer = 1
[Code].....
View 7 Replies
Sep 11, 2011
I have been getting a lot of crash reports sent from my application that describe System.Web not being found.
I was able to reproduce the problem, and at first it seems that it would be caused by not running .NET 4.0, however, my test machine is running Windows 7 SP1 with .NET 4.0,
How would I go about fixing this problem? Was System.Web deprecated?
View 2 Replies
Mar 8, 2012
What i am trying to is create a function were by a user when he logs in, based on the rights given to them they can either use certain buttons . I no i have to use the enable and disable function.[code]if username is true and user_name is Sales then enable x y z buttons. i been trying looking around and reading and found the following which i cannot get to work with my system but they follow a similiar patten to what i want to achieve.[code]
View 1 Replies
Feb 7, 2012
I have an asp.net web forms application that uses asp.net membership and URL Routing.Because of the way Roles work, i cant put an "AND" or "OR", etc. in the allow/deny tags of the web.config file that resides in each folder.This is a business website that that is being ported from a vb.net win forms project that contianed many apps. (The win forms project have a custom authentication system.)The web app is structured in a way to mimic the desktop suites and a folder was created for each app.There are also common folders where any user of any app can generate a report.
View 1 Replies
Feb 6, 2012
I have a vb application sitting on sql 2005 database i want a scenario where the application can check the number of records inserted into a particular table(Users) , if the number of records inserted into that table after 1wk since the last insert is less than 100 records it should pop up a warning alert with the total number of records
View 3 Replies
Nov 16, 2011
i would like to auto check for new version system update when the system is closing. When there is the new version system update, will automatically rename the active exe to FileName.old then copy new version of exe into the folder.
View 1 Replies
Mar 15, 2011
This will be my first post on this site, so I thought I would make it a doozy. I have an web application on our site at work that allows users to login to the system, and submit filings for dockets that our state agency governs. Without getting to involve with what that means, they basically upload mostly .pdf files, but there are others that are acceptable to upload as well. The current system that is being used, uses a simple FileUpload and saving it to a folder on the d: drive of the webserver. I ran into a problem that with anyone outside the building/network, the upload is extremely slow and seems to be limited files no larger than about 1.4MB. There have been a few cases where larger file have made it through, but those ar few and far between. I've tried a couple different 3rd party components, but seem to run into the same limits. So, I install the FTP server on the box with the IIS and am trying to go the FTP route using ftpwebrequest.
Below is what I have put together so far:
Imports System.Net
Imports System.IO
Partial Class _Default
[CODE]...
This seems to work as it is at the moment, but I know it has a long way to go for catch exeptions, speeding it up...
1.) The first problem I have run into is if you try to upload to large a file, you get Out of memory error. I'm needing to change the buffer so that it is buffering chunks instead of the entire file. I've googled over and over again and seem to find several good options in C#, but can't seem to convert them to VB. So, could some one give me some idea how to take what I have and change the buffering to use smaller chunks.
2.) I need to catch an empty UploadFile field.
3.) I will eventually be changing this so that it handle multiple file uploads like my current system uses. (Did I mention that I'm new to the ASP.NET and have been programming in .ASP)
4.) As you will notice from my list of acceptable file types, I might have a problem with some needing to be upload as Binary and some not. So I'm going to have to come up with a way to test and change the Requested.UseBinary = False as needed.
I'm sure that I'll find other items as I progress or the big bosses will find other things that they want to add, but for now.... I know that given enough time, I will get all of these items worked out.
By the way, we have a network adminstrator that leave a lot to be desired and most IIS and now FTP I'm having to learn, implement and configure. I'm wondering if there is anything else that could be causing these limits in file size. Since I've tried 4 completely different forms of uploads and they all seem to run into the same limits, I thought there might be something in a router, firewall, server configuration.... that I might need to look into as well.
View 2 Replies
Dec 1, 2009
How to get the sign that is used to indicate decimal digits?
For example: in England a number would look like 4,000,000.04 In The Netherlands however the same number would be 4.000.000,04
How can I find out if the users system uses the . or the , to specify decimals?
View 2 Replies
Jan 3, 2012
I have written a program and everything works fine, but I want to make sure that only the administrator can add or edit users to the system. As I see it, I need to add an argument (if statement) to my login button code to disable the add / edit users button on the main form if the user is not Administrator. [Code] I have tried putting my If statement in but it doesn't happen the button is still active even when I login as admin.
View 6 Replies