How to Install and Configure MySQL 5.6 Server on Windows PC-Step by Step...

Install and configure Generally available GA MySQL 5.6 Server on Windows PC.
MySQL is Open Source Database Management Software under General Purpose License.
This video tells:
How to download ,install and configure MySQL.
How to use MySQL Server command line for executing SQL Queries.Some examples of SQL queries are executed after the installation for demonstration purpose..





Please subscribe.. :-)

Advanced Login System using Visual Basic 6.0 and MS Access-Quick and easy

Create An Advanced Login System in Visual Basic 6.0 and Ms Access.

Features of this application are

Splash screen with progress bar,Welcome form asking for login or register,Registration form for new users to get register,Multi-User Login form for existing users as well new users registered.As you login successfully,you will be able to use the system.

In this video tutorial,you will able to create a splash screen having a progress bar indicating % complted status,as loading completes,A new form i.2 Welcome form will appeared on screen asking for Login or Register as a User.You can either register as new user or login into the system.For registration,A form Registration is available to create new username and password.Simultaneously,after the registration,you will be able to login with your current username and password.
In the tutorial,There are five VB forms:
1.Splash Screen having Progress Bar.
2.Welcome Form asking for Login (Existing User )or Register (New User).
3.Registration form for creating new users to use the sytem.
4.Multi-User Login form where all the users registered with the system ,can login into the system and Use the system.
5.Application form,As you login with your correct credentials,then you will be able to use the system.
Database connectivity or other programming stuff are explained step by step with written caption.
After watching this video,you wll be create the same login application for your own use.
for more information ,click on the Link:
Please leave a comment for any query.if you like my video,hit like button.
for more informative videos on technologies ,please subscribe to my channel.




Source Code: Splash Screen
_________________________________
Private Sub Form_Load()
Timer1.Enabled = True
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
End Sub
Private Sub Timer1_Timer()
ProgressBar1.Value = ProgressBar1.Value + 5
lblstatus.Caption = "Loading..Plz Wait.."
lblstat.Caption = ProgressBar1.Value & "%"
If ProgressBar1.Value = ProgressBar1.Max Then
Timer1.Enabled = False
Unload Me
welcome.Show
End If
End Sub

Welcome
__________________________________________
Private Sub Form_Load()
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
End Sub
Private Sub logbtn_Click()
login.Show
welcome.Hide
register.Hide
End Sub
Private Sub regbtn_Click()
register.Show
login.Hide
welcome.Hide
End Sub
Registration form
________________________________________________

Login Form using Visual Basic 6.0 Adodc and Ms Access Database- Step by ...

Create a simple login form in visual basic 6.0 using ADODC control and Microsoft Access 2003 database-Step by Step demonstration.

After watching this video,you will be able to create a login form where multiple users can logged in and use the system.

In this Video tutorial,following points are discussed:

1.How to create a database and store the login credentials of different Users using access for VB login app.



2.How to Create a login form and do database connectivity with access .


3.How to do the authentication of users using some SQL commands and a piece of VB code.



Tutorial is only for Beginners,No validations rules are applied or followed while developing this login form.

No step is skipped while demonstration.All steps are explained with written text.

Source Code:



LOGIN BUTTON
Private Sub loginbtn_Click()

loginado.RecordSource = "select * from Logintab where Username='" + txtuser.Text + "' and Password='" + txtpass.Text + "'"

loginado.Refresh

If loginado.Recordset.EOF Then

MsgBox "Login failed,Try Again..!!!", vbCritical, "Please Enter correct Username and Password"

Else

MsgBox "Login Successful.", vbInformation, "Successful Attempt"

welcome.Show

End If

End Sub

CANCEL BUTTON

Private Sub cancelbtn_Click()

End

End Sub




Please Leave a comment and Subscribe to my channel :-)