Results 1 to 37 of 37

Thread: VB.NET - Login Screen using ADO.NET Class

  1. #1

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    VB.NET - Login Screen using ADO.NET Class

    A login window demo .
    Attached Files Attached Files

  2. #2
    Lively Member
    Join Date
    Jan 2003
    Posts
    69
    Thanks Pirate

  3. #3

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086
    To try the demo and verify it's working , here is the info :

    UserName : abc
    Password : 123

  4. #4
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    a question to addon, can I lock *.mdb file using Microsoft Access or other program so no one can access it unless with a password?
    The Power Of Sharing Knowledge!

  5. #5

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by private1337
    a question to addon, can I lock *.mdb file using Microsoft Access or other program so no one can access it unless with a password?
    You mean password-protect it with code or right from MS Access ??

  6. #6
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by Pirate
    You mean password-protect it with code or right from MS Access ??
    anyone will do, it will be better if MS Access can.
    The Power Of Sharing Knowledge!

  7. #7

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by private1337
    anyone will do, it will be better if MS Access can.
    Open your database in MS Access , go to Tools menu , then Security menuitem , then Set Database Password , follow instructions .

  8. #8
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    very cool.. Thanks btw this login screen is damn cool. Is it suitable for creating code for trials to enter user name and registered code or you have alternative choices?
    The Power Of Sharing Knowledge!

  9. #9

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    Don't expect much . It's just quick demo I knocked up while practising .NET . Anyway , for copyrighting your app , you better use license component or other copy-right protection tools . The demo shows how to prevent a user who has no right to log in the program . It's easy to hack it though .

  10. #10
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    so do you have those copy-right protection tools? I also think this can be easily be hack though? is there any more security way for improve?
    The Power Of Sharing Knowledge!

  11. #11

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    There's no way to stop crackers but it can be very difficult for them to crack these tools . Just do search on protecting software , you'll find a lot of tools and techneques .

  12. #12
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    oh.. Thanks for your information but do you have any protection tool that can recommend?
    The Power Of Sharing Knowledge!

  13. #13

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    You can use this ActiveX . It's free . There are many other ways to protect your program from crackers .Can you be more creative and invent your own way !
    http://www.activelock.com/about.html

  14. #14
    Lively Member
    Join Date
    Oct 2004
    Posts
    123

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by Pirate
    You can use this ActiveX . It's free . There are many other ways to protect your program from crackers .Can you be more creative and invent your own way !
    http://www.activelock.com/about.html
    ok thanks
    The Power Of Sharing Knowledge!

  15. #15
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: VB.NET - Login Screen using ADO.NET Class

    Pirate,

    I am developing my first project that generates an access database which will be on a server. Can I do something more secure than the Loginscreen. At the moment I have something similar to Loginscreen and I wish I could make it more secure. Do you have any suggestion. Thanks

  16. #16

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086
    SQL Server db uses mix mode authentication (Windows login & SQL Server userinfo) .I'm not sure if this applies also to MS Access db but if you're really worried about securing your db , then go for something support more security features (like SQL,Mysql...) . I don't think you can much with access .

  17. #17
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: VB.NET - Login Screen using ADO.NET Class

    Pirate,

    Thanks for your time to help me. As I said this is my first project and the only database I've ever used is Access. Now knowing that it is not that secure and my project need good security now I am really considering doing it with something else like SQL Server. How can I get to know more about the SQL Server and when you said to go for more more security features (like SQL,Mysql...) what do you mean exactly. Can you be more specific cos I need all the information I can get. I've already desinged my database with Access but its better if I switch to something better now before I go into more work. Thanks a loads for your help and time.

  18. #18

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086
    Well, databases and security is a hot issue and can't be covered or summed up in a post and maybe you should open a new thread on this topic .

    You may start from here : http://www.microsoft.com/sql/default.mspx

  19. #19
    New Member
    Join Date
    Feb 2005
    Posts
    4

    Thumbs up Re: VB.NET - Login Screen using ADO.NET Class

    Sir,

    Hands up to people like you ! ! ! Im juz a newbie in vb .net and i found it very useful ! ! ! Im developing my 1st .net prog...Its an housing loan evaluation sheet...I think I can apply it there...

    More power to you ! ! !

  20. #20
    Lively Member zen_master's Avatar
    Join Date
    Apr 2005
    Location
    Buffalo, NY
    Posts
    114

    Re: VB.NET - Login Screen using ADO.NET Class

    awesome!

    gonna need this to study...

  21. #21
    New Member
    Join Date
    May 2005
    Posts
    5

    Re: VB.NET - Login Screen using ADO.NET Class

    I downloaded your login program and works according to your coding. I tried to implement to one of my program and it crashes. Is there a way where i can use the login retrieving access database password and open the implemented program?

  22. #22
    New Member
    Join Date
    May 2005
    Posts
    5

    Re: VB.NET - Login Screen using ADO.NET Class

    I forgot to tell you that when an exception fires, it points to the sql connection.

  23. #23

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    You should've posted your problem in one of these forums (C# or VB.NET) NOT in the CODEBANK Forum . If it's not connecting , it means something wrong with the connection string . Double check the db name , the server name ...etc . Show some code (not here ofcourse )

  24. #24
    New Member
    Join Date
    May 2005
    Posts
    5

    Re: VB.NET - Login Screen using ADO.NET Class

    Hi, I already fixed the login screen and works perfectly.

    How can i change the password with a "change password button"?

  25. #25
    Lively Member zen_master's Avatar
    Join Date
    Apr 2005
    Location
    Buffalo, NY
    Posts
    114

    Re: VB.NET - Login Screen using ADO.NET Class

    pirate, is there any way to connect to access database w/o ADO class?

    may need some explanation here =)

  26. #26
    Member digioz's Avatar
    Join Date
    Oct 2005
    Location
    Chicago, IL
    Posts
    33

    Re: VB.NET - Login Screen using ADO.NET Class

    Hey Pirate,

    I hope you don't mind. I made a few changes to your login screen:

    1- The actual password textbox is now masked by a " * " when you are entering it.

    2- I password protected the access datebase and changed the connection string in the code.

    3- Added a login icon and change background color and login button color and text.

    4- Changed the border to fixed single so it looks more like a login.

    Great beginner example. Certainly has a lot of potential.
    Attached Files Attached Files
    DigiOz Multimedia
    http://www.digioz.com

  27. #27
    Member digioz's Avatar
    Join Date
    Oct 2005
    Location
    Chicago, IL
    Posts
    33

    Re: VB.NET - Login Screen using ADO.NET Class

    I just want to post a WARNING to anyone that intends to use the code in its current condition, as it is vulnerable to SQL injection in its current state.

    To demonstrate what I mean, try entering the following in the Username and Password fields:

    For Username Enter: ' OR ''='
    For Password Enter: ' OR ''='

    Notice that the system is easily fooled into allowing access to whatever you are trying protect. This is because we are both NOT validating user input, and also using a full SQL string to query the database (instead of setting parameters).

    SQL injection does NOT only work on Microsoft Access Database. It also works on ALL other database types including Microsoft SQL Server, Oracle, and MySQL to name a few.

    SO PLEASE DO NOT USE THE CODE AS IS!
    DigiOz Multimedia
    http://www.digioz.com

  28. #28
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: VB.NET - Login Screen using ADO.NET Class

    hi,

    Ive tried it but it doesnt open the Ms Access. I have a program that needs a username and password and the code is similar.

    what exactly is the username and password, I mean are the ' ....' included?

  29. #29
    Member digioz's Avatar
    Join Date
    Oct 2005
    Location
    Chicago, IL
    Posts
    33

    Re: VB.NET - Login Screen using ADO.NET Class

    Yes, you would have to type it exactly as show bellow including the single quotes:

    Username: ' OR ''='
    Password: ' OR ''='

    What this will do is to alter the SQL query string by "injecting" the ' OR ''='
    portion into where the username and password would normally go, which basically allows a hacker to bypass the login check. This is a very common method many hackers use to bypass login screens.
    DigiOz Multimedia
    http://www.digioz.com

  30. #30
    Lively Member rguifarro's Avatar
    Join Date
    Aug 2006
    Location
    Central America
    Posts
    73

    Re: VB.NET - Login Screen using ADO.NET Class

    hey!

    how can I use this example but with a sql database, instead of OleDbConnection what should be my connection string to lo into a sql database and is it posible the make a option so that the user can change his password as many times he wants?

    thanx, really need this to work.

  31. #31
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: VB.NET - Login Screen using ADO.NET Class

    yes, you need to substitute the OLEDBconnection to SQLConnection.

    As to having the user change this password you have to have a table having a USERID, Username, Password fields where the user will log in with the old password and on logging h e can use the new data and have an UPDATE command to change the old password.

    If you search the forum with an update + password search Im sure you will come up with someting similar.

  32. #32
    Junior Member
    Join Date
    Jan 2007
    Posts
    28

    Re: VB.NET - Login Screen using ADO.NET Class

    Hi guys I was looking thought this and it looks interesting, however I am building a program that has many other program in it so it's accually like a menu to access other program when you hit a button that program opens up. I plan to put that program on a DVD but I wanted to know if there is any way where people can't view the files on the DVD like go into the drive right click and go to explore CD, because I don't want anyone the view the contects of the CD. If anyone can help me out please I would really appreciated.

  33. #33

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086
    One way is to pack all the files in one compressed file (using your own algorithm or format) and making an index file so u would be able to know where each file starts and ends .I did something like this (for personal use) but I was fraustrated by the slowness of unpacking the files if the file exceeded 700mb.

  34. #34
    New Member
    Join Date
    Apr 2007
    Posts
    5

    Thumbs up Re: VB.NET - Login Screen using ADO.NET Class

    Thanks alot MATE i having looking for this Login Screen 1 week beacues my graduation i ask my teacher i guess he has broplem with it i dont know any way thanks agina to help me out sorry my English too bad if you don't mind i want use your Example with SQL and do some change on it ...
    Have nice day ty ....

  35. #35
    New Member
    Join Date
    Mar 2011
    Posts
    1

    Re: VB.NET - Login Screen using ADO.NET Class

    im new to the whole programming concept on VB I just wondered how i need to use these files to create the login i serious need a reply asap thanks alot im using version 6.5 and am doing an IT project

  36. #36

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by vip_scarface_vip View Post
    Thanks alot MATE i having looking for this Login Screen 1 week beacues my graduation i ask my teacher i guess he has broplem with it i dont know any way thanks agina to help me out sorry my English too bad if you don't mind i want use your Example with SQL and do some change on it ...
    Have nice day ty ....
    This example was created in framework 1.1 (i think) , VS.NET 2003.I'm not sure if it doesn't work but it was when i create it.Sure you can do whatever you want to do with it .

  37. #37

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,086

    Re: VB.NET - Login Screen using ADO.NET Class

    Quote Originally Posted by lukie123456 View Post
    im new to the whole programming concept on VB I just wondered how i need to use these files to create the login i serious need a reply asap thanks alot im using version 6.5 and am doing an IT project
    Sorry man..i could only help u if you're programmer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width