Hi everyone,
I need some help here, I'm new with visual basic express. How to I create a login form with visual basic express editions and mysql. Anyone can help me
For example :
After I submit my Login ID and Password at "Form1". How to I connect it to mysql and pass the posted value into the mysql query to checked whether is a valid member or not.
If is a valid member how to I create a SESSION to store the member details like "username" and "user ID" Then these values I able to use in Form2 or another.
Someone can help me please ... !!!
THANKS A LOT
How to I create a login form with visual basic express editions and mysql
zephyr_at_hades
Thanks for your respond.
Can you write some code to me, so I can take it as a reference.
The project have to used mysql. So I didn't have any option. Can you help me
JakobH
"2 - This is not a web app, there is no such thing as a session. Instead, you should pass values from form1 to form2 as you create it."
I'd disagree with this a bit.
Logins that I've done, did all of the validation and if necessary evasion in that form. What was passed between forms was whether a user had successfully logged in or not.
anandkuppa
Boris Meltser
The express products are configured so that that IDE data features work for Access and SQL Express but for other databases like MySQL / Oracle etc. there is no IDE support.
You can develop for these databases in code but you just wont get the IDE support for additional databases unless you buy one of the products.
Hey you cant have everything for free.
Matthieu_M
You might find that you are going to have problems connecting to MySQL with the wizards in the express products...
For the logon system, I have just about finished intergrating the asp.net membership system into a Windows forms application. You might want to have a look down that line.
dva
1 - www.vbmysql.com/ is dedicated to connecting VB to MySQL, but if you can, using SQL Server Express is a far better option.
2 - This is not a web app, there is no such thing as a session. Instead, you should pass values from form1 to form2 as you create it.
jaackov
Yeah, I agree with what you're saying broadly, but I didn't go beyond answering the question specifically, because there was a deeper misunderstaning there.
wjholtjr
That's a pity, seeing as MySQL is underpowered, and not free for commercial apps. I've never used it, I looked into it once, and quickly decided it was not good enough. I'm sure that the site I referenced, being dedicated to connecting VB to MySQL, will have lots of examples you can use.