This is my first attempt to connect to an SQL database and make some changes. I need to find row, then change a value. I have my project setup to make the SQL connection and I can see the data. This is a console app that will run and make changes to the database.
So my row will look like
Serial number | Info | Available
So I need to find the row by finding the serial number, and then make a change to the available column. How would I set that up?