I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005.
In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is retrieved by selecting his/her ID(Primary Key in Student table) from a combo box list. Data is saved by calling a Sub called "Save()". When it's called it checks if the entered student ID is already in the student table. If yes then an update command is executed on the row with the matching key. Else an Insert command is executed to add the new values in a new row.
Student IDs are loaded to the StudentID selection combo box when the form loads. When clicked on one of the existing IDs in the combo box's list then all the other text boxes and components fills up with relevant data.
So, I need to know how I can implement a system as in the above description. Answers with coding example would be great.