Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 28th, 2007, 08:43 AM
Registered User
 
Join Date: Nov 2007
Location: Bangalore, Karnataka, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Connection to Access Database

I am having an access database "user.mdb", that has "User_Details" table with the following columns "Sl. No. (Primary Key)", "User Name", "Password", "First Name", "Last Name", "Contact No", "EMail ID" and "Postal Address".

I have a HTML Form to get these details from the users. What ASP.NET code I should use to get these details from HTML form and save them to "user.mdb" database. Since I am not a IT Professional, can you give me the code?. The code must do the following once the user clicks the "SUBMIT" button...

1. Once the user fills the form fields and clicks the "SUBMIT" button, it should display the data filled for confirmation with "CONFIRM" and "CANCEL" button.

2. On clicking the "CONFIRM" button.

3. Open "user.mdb" database and "User_Details" table.

4. Add the information filled by the user in HTML Form in case there is no data in the table.

5. Append the information filled by the user in HTML Form in case there is any data in the table.

6. Give a "Confirmation Page" stating that the data is received successfully and saved in the database and when the user clicks the "Close Window" text link available at the bottom of the "Confirmation Page", Return to the HTML Form Page with all the fields empty.

7. On clicking the "CANCEL" button, Return to the HTML Form Page with all the details entered by the user for modification.

Sevar K
  #2 (permalink)  
Old November 28th, 2007, 08:56 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Hi there.. I (personally) will not do the job for you, but I can point you out that in google there are a lot of info that you can use to do this...

even that.. what do you mean by append the info?? append the data to the same row?? because add data to a table is the same if there are no records or a lot of them...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a connection with access database arshad mahmood Classic ASP Professional 1 April 18th, 2006 03:53 AM
access database connection problem shaileshk ADO.NET 6 July 5th, 2005 03:30 AM
Access Database connection widad Classic ASP Databases 3 November 5th, 2004 05:24 AM
Connection to a Access database aadz5 ASP.NET 1.0 and 1.1 Basics 2 October 13th, 2003 06:35 AM
Access Database Connection Problems jdmeier Classic ASP Databases 1 August 13th, 2003 10:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.