Loginform to SQL database

Question

I want to create simple login form and a followed all steps but is not connecting to SQL database, please help

Sanwar Ranwa · Answer

Hii abra man Please share your code or follow these links https://www.c-sharpcorner.com/article/how-to-create-login-page-in-asp-net-web-application-using-c-sharp-and-sql-server/ https://www.c-sharpcorner.com/UploadFile/009464/simple-login-form-in-Asp-Net-using-C-Sharp/

abra man · Answer

this is the code but I dont know where should the code go on the login button or on the form? ---------------------------------------------------------------------------------------------- Public Class frmLogin Dim con As New SqlClient.SqlConnection Dim da As New SqlClient.SqlDataAdapter Dim ds As New DataSet Dim sqlquery As String Private Sub frmLogin_Load(sender As Object, e As EventArgs) Handles MyBase.Load con.ConnectionString = "Data Source=ABRAM-PC\SQLEXPRESS;Initial Catalog=Login;Integrated Security=True" End Sub Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click Try 'checking if the username and password field is null If Len(Trim(txtUserName.Text)) = 0 Then MessageBox.Show("Enter the user name", "Input Error !", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Sub txtUserName.Focus() End If If Len(Trim(txtPass.Text)) = 0 Then MessageBox.Show("Enter the password", "Input Error !", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Sub txtPass.Focus() End If 'executing SQL Query for retrieving the username and password from the database table con.Open() sqlquery = "SELECT * FROM LoginTable WHERE user_name='" & txtUserName.Text & "' and password='" & txtPass.Text & "' " da = New SqlClient.SqlDataAdapter(sqlquery, con) da.Fill(ds, "LoginTable") If ds.Tables("LoginTable").Rows.Count 0 Then MessageBox.Show("Login succeed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information) Else MessageBox.Show("Invalid user name and password", "Access denied", MessageBoxButtons.OK, MessageBoxIcon.Error) End If con.Close() clear() 'calling clear method here Catch ex As Exception MessageBox.Show(ex.Message, "Exception generated", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End Sub ' declaring a method for clearing the controls Public Sub clear() txtPass.Clear() txtUserName.Clear() End Sub ' code for show password Private Sub chkshowpass_CheckedChanged(sender As Object, e As EventArgs) Handles chkshowpass.CheckedChanged If chkshowpass.Checked = True Then txtPass.UseSystemPasswordChar = False Else txtPass.UseSystemPasswordChar = True End If End Sub End Class

Sanwar Ranwa · Answer

Can you share your code

abra man · Answer

Thanks, but I want to create c# window login form application and I want that login form to connect to my SQL database and open the second form. I tried most tutorials but is failing to connect to my database. Please help

Loginform to SQL database

Answers (4)