sql = "SELECT * FROM tblContacts Where UserName='" & UserNameLoggedInLabel.Text & "'"
How do I write a sql to overwrite data in my database that is being displayed in a textbox on the same form that has the label above. And have it overwrite info for the correct user.
So my table is called tblContacts the column I want to update is called UserScore1. I just want to press
a button and have that textbox overwrite the data in my database.
sql = "INSERT INTO tblContacts (UserScore1) Where UserScore1='" & TextBox1.Text & "'"
Thanks very much.
Slight edit here
I understand that I am not referencing the label like I was to get the information. The problem I suppose is I do not know how to reference the label to get the details and at the same time update the TextBox. I am only assuming this has to be done in SQL or can I use some VB.NET code here to achieve this.