Hi, I need help to create a basic login form for a Windows application. It needs to check the username and password against a SQL database, the details of the project are below:

Project Name: stockVB
Login Form name: loginfrm
Login Username textbox: usertxtbox
Login Password textbox: passtxtbox
Login Button: loginbtn
Form to open upon successful login: mainmenu
SQL database Dataset name: stockds
SQL database Connection string name: stockcs
User details table: users
Username column: Username
Password column: Password

I hope this is all the infomation you need, I am quite new at this so i need it quite basic.

Thanks

Andrew

....I assume you are looking for someone to create this for you? You are not going to have any luck with that here, however, if you have a piece of problematic code or something such as that i would be happy to help you with it, i just wont do your work for you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

homework?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

Hi, as I said I am new at this and unfortunatly I have got no where with it. All I need is some help to know how to verify a textbox against a SQL database column, I just need somewhere to start really because at the moment I am just going no where.

Thanks

Andrew

Basically, you would do something like this:

SQL String:
"SELECT * FROM users where Username='" & txtUsername.Text &"' AND password='" & txtPassword.Text &"'"

If the above query returns 0 results, the username or password is invalid, if it returns a row (It should always only return 1 row) then the username and password are correct.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429