No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
hi im making a database for my project is it possible to have multiple foreign keys shown at the picture? i tried to alter the tables and add foreign keys but i always get a #105 error, so i deleted all of my tables and will make a new set … |
|
Public Sub login() SQLConnection.ConnectionString = ServerString cmd.Connection = SQLConnection SQLConnection.Open() cmd.CommandText = "SELECT employee_id, password FROM employees_list WHERE employee_id='" & Form1.EMPLOYEE_ID_txt.Text & "' and password='" & Form1.PASSWORD_txt.Text & "'" dr = cmd.ExecuteReader() If dr.HasRows Then Form1.PASSWORD_txt.Text = "" dr.Close() Form1.Hide() MessageBox.Show("Signed in", "", MessageBoxButtons.OK, MessageBoxIcon.Information) 'get firstname and lastname" label4="firstname … |