|
-
Nov 25th, 2013, 01:01 PM
#1
Thread Starter
Junior Member
VB and SQL
Okay, I've got some other college work I might need some help with. I have a major project coming up in class next Wednesday that has to do with me creating a Windows Form-based application that connects to a database through SQL to allow for a user to connect using a login and password, also stored on a table within the database, and can allow for said user to edit, update, and change entries on another table.
Reason I'm asking for help is for one of four main things: For starters, when I installed SQL, after installing Visual Studio, I'm getting a connection issue when trying to add a data connection in the Server Explorer. Can anyone help me understand what exactly I'm doing wrong?
Second, once I have the tables created, the Windows forms must display said table and allow for editing. Is there anything I should know about allowing a user to do so?
Third, I do understand that, to get the form's variables and such to be recognized by SQL, a @ is needed before each variable entry in the SQL coding, if that makes any sense. This in mind, how do I get the user's input from another form I've made for the user to input their user name and password to the main form to be used in SQL? I've got an idea behind that, but I figured I'd ask.
Lastly, there is a requirement to allow for a user to switch tables within the database, however the project doesn't mention if it's required to keep it in the same form. Assuming it is required, how would I do that?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|