How to retrieve, add and update data manually using VB.NET 2005

95 pts.
Tags:
Data Junction
Extract Transform Load
INSERT statement
SELECT statement
SQL Server 2005
SQL Server connectivity
VB.NET
VB.NET 2005
Visual Basic 2005
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!!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have a look at the following page. You will find information and code samples on some of the topics you mentioned in your question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ToddN2000
    You have lots of options. What type of data connection are you planning to use. Will you create stored procedures? What version of SQL Server? In your description it sounds like you have an example in front of you. This project would be to large to post sample code and not knowing your specifics there are to many variables. Show us what you have tried and we can help with your issues.
    11,820 pointsBadges:
    report
  • philpl1jb

    Todd, I wouldn't hold my breath for a response. 

    This question was asked 4 years ago.

    50,205 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following