About Syed Adeel Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include XML, Custom Controls + Computer Hardware and Windows Turboshooting...etc.
More Skills :
1 . PHP - > All Type Of CMS e.g. (Joomla,Drupul,PHPNuke...etc)
2 . ASP
3 . ASP.Net
4 . CMS
5 . MySql
6 . SQl Server 2000 & 2005
7 . Ms Access
8 . Web Designing
9 . Networking Turboshooting
10 . Windows Turboshooting
11 . Hardware Turboshooting
All Type Of Work Related To IT
I also Do Work as a Freelance as Application & Web Developer & Designer
Experience i have 3 years work experience in software house and 4 years work experience for computer hardware and Networking..
Expert: Syed Adeel Rizvi Date: 3/12/2008 Subject: vb.net and databases
Question hi,
i have database with usernames and passwords and would like to know how i can create a login page that connects to this?
i have a form with 2 txtboxes and a button.
i have tried using an sql select statement but not sure how u would use this to read from the textboxes to the database and back again in order to confirm the username and password?
any help would be greatly appreciated
thanks
Answer Hello Sir,
its so simple do this :
Dim Conn as new Data.OleDB.Connection
Dim Cmd as Data.OleDB.Command
Sub CheckLogin()
Conn.ConnectionString = "Your Database ConnectionString"
Conn.Open
Cmd = Conn.CreateCommand
Cmd.CommandText = "Select UserID From You_TableName Where Username='" & txtusername.text & "' AND Password='" & txtpassword.text & "'"
