AaronDickey

I'm having some issues with this code: [CODE] Imports System.Data.SqlClient Public Class loginForm Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '--Connection string to POS database Dim loginFormConnection As New SqlConnection("SERVER = localhost\SQLExpress; DATABASE = POS; INTEGRATED SECURITY = true;") '--Check to see if Windows Point …

MarkGia, The easiest way I've found to do a login form with a database is using SQL Server 2008 Express with Management Studio and creating a table called users and then using a datareader to see if the table contains rows that match what a user is trying to use. …

[CODE]newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"[/CODE] I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;