Hi,
the code that posted does nothing. do you have any other ideas that may help?
User Profile
Collapse
-
Parameterised queries
Hi,
I am getting an error message saying:
“No value given for one or more required parameters.” And it points to this line
command.Execute NonQuery()
I am not sure what this means. The code I used is below:
...Code:With command.Parameters .Add(New OleDbParameter("@Firstname", FirstName.Text)) .Add(New -
inputting information when there is a foreign key
Hi all,
In Ms Access, I have a Customer table and a Credit Card table. The CustomerID field is a primary key in the Credit Card table. Both tables already have sample data in it.
So, when a customer wants to purchase a product, they proceed to checkout and payment. They fill out the payment form where their credit card information is inputted.
When the customer submits the form , the system... -
VB.NET: Logging out a session after 30 mins inactivity
Hi all,
i am creating a website and i want to log out the user after 30 mins of inactivity. how do i do this using vb.net.
Also, if the user tries to login and not getting through. after 3 tries i want the system to lock the user out and after 10 mins the user can try again.
can any1 help me? -
information already on file problem - Reader.HasRows
Hi,
i created a register form on a website. The information from the form has to go in the customer table in a database in MS Access.
the information is going into the table perfectly. however, if i don't want a repeat of information and the system checks to see if the user is already in the database i get an error. it's either i get the error message "The user name you entered is already on file." all... -
i got the code to work by naming the columns in the INSERT INTO statement. Before, i had only named the VALUES fields and not the columns in the database. Also the autonumber field (CustomerID) had to be left out. So the query now would be:
Code:INSERT INTO Customer [B](FirstName, LastName, Address ect...) [/B] VALUES('"FirstName.Text + "','" + LastName.Text + "','" + Address.Text ect..)Leave a comment:
-
ashes started a topic Inserting records into MS Access where there is an autonumber for a primary keyin AccessInserting records into MS Access where there is an autonumber for a primary key
Hi,
I am creating an ecommerce website using Microsoft Visual Studio, VB.Net and MS Access 2003. I am new to VB.Net
When someone wants to register on the website, they fill out a form and the contents of the form is inserted into the MS Access database.
The Customer table in the database already has 30 records (with CustomerIDs 1 - 30) in it (from when the database was first created). The CustomerID...
No activity results to display
Show More
Leave a comment: