I just realized that I'm going to need to create a table on my MS Access database inside my application. I have already been inserting and selecting from it successfully for weeks now, but I'm running into a problem when creating the table. Not to say that I can't create one at all, I can...
Would I need to use SQL queries against a MS Access database in VB.NET. Right now I'm using
Driver={Microsoft Access Driver (*.mdb)};DBQ=..\cfss.mdb
Which connects fine, and also I was able to successfully run a SELECT query on it, however I need to run INSERT statements, and mine just isn't...
So far I have a login and sign up section for this project I'm working on. I wanted to use a method that would pevent the user from opening multiple instances of the sign up and login forms. At first, I was thinking of loading the forms normally, and just running a check to see what MDI...
I'm using the Jet OLE components for making a database connection and adapter. After adding them, I successfully made a dataset from the "Data" menu. Then I bound my textboxes to the individual data columns. Now, my question is, I have a back and forward button, when I click on them, what do...
What is the best way to work with an MS Access database? So far I am using data adapters and data tables, but it doesn't seem efficient. There are a lot of times where I am comparing many tables, and even though everything is working smoothly, I just feel I could do better.
That, and what is...
Okay, I'm using VB.NET and SQL. Now, the accessing and updating of the database works fine. Now I'm trying to retrieve the data. So far I have:
sql_command.CommandText = "SELECT uid FROM userlist WHERE uname = ' " & txtUName.Text & " ' AND pword = ' " & txtPWord.Text & " '"...
I have this project so far that is taking on the form of an MDI application. The first thing I want to tackle is signing up for access to the program. I want to do this over two forms. The first form has personal info, and when you hit next, if everything is successful, a userinfo table on my...
Hey guys, new here, been trying to get help across various forums, no one is answering. I bought VB.net awhile ago, and I just now started getting into it. I'm making this application that needs to connect to a database, but I'm having a hard time doing it. I have MS SQL, but when I install...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.