| [SOLVED] How to write a program in Visual Basic to add, update, or delete records? Okay, I'm about stressed to the limits right now, I'm trying to finish some projects for my class, and all of a sudden we're getting thrown into using Visual Basic and Microsoft Access, both of which I have very limited knowledge of. We've never even had to use them in the class before, so I'm totally lost on this.
I'm supposed to be designing an interface with "control buttons that lead to students, instructors, courses, course schedules, and course rosters. Allow a user to add, update, or delete records in each area."
I can do the design just fine, that's not a problem, and I can add the new forms, and have them tied to buttons, etc, but I don't even know where to begin to allow adding, updating, and deleting of records. She provided an Access Database, but she doesn't want us to actually link to that DB, just to hard code the data into the project. If anyone could help or at least give me somewhere to start, that'd be awesome.
Sorry, that sounds like the right thing, but I've never written SQL code, where exactly am I supposed to put that code, and how do I insert a table?
I'm using Visual Studio.NET 2003 |