Q:
How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
VB.NET 2005, SQL Server 2005, Data Junction, Visual Basic 2005, Visual Basic .NET, SQL Server connectivity, INSERT statement, SELECT statement, Extract Transform Load Hey guys!!!
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.
Thanks!!
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.
Thanks!!
ASKED:
Mar 7 2009 11:01 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Access and Manipulate SQL Server data - Using Ad Hoc Queries
