ASP.NET

There MUST be a simple way to get data from a webform into an Access Database ?? RSS

6 replies

Last post Dec 07, 2012 11:00 AM by geniusvishal

‹ Previous Thread|Next Thread ›

- Reply
janehollin

Member

1 Points

12 Posts
There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 09:58 AM|LINK
Hi

I have been looking (for days) on Google and seen so many weird and wonderfull methods described, I think there MUST be a simpler way of doing this.

I have a webform (see code below) and I have an Access Database (in the same folder as the form on the website).

My Access Database (called myDataBase.mdb) has a table (called myTable)

In MyTable I have fields
Field1
Field2
Field3
Field4
```
<body>
<form method="post" runat="server" >
<asp:TextBox runat="server" id="TextBox1"></asp:TextBox>
<asp:TextBox runat="server" id="TextBox2"></asp:TextBox>
<asp:TextBox runat="server" id="TextBox3"></asp:TextBox>
<asp:TextBox runat="server" id="TextBox4"></asp:TextBox>
</form>
</body>
```
Does anyone know of a SIMPLE method – or a link to a page with a SIMPLE tutourial, that describes a SIMPLE method of getting user input from the webfor into the Access DataBase

The contents of:
TextBox1   should end up in   MyTable/Field1
TextBox2   should end up in   MyTable/Field2
TextBox3   should end up in   MyTable/Field3
TextBox4   should end up in   MyTable/Field4

There MUST be a simple way of doing this

??
- Edited by janehollin on Dec 07, 2012 09:58 AM
- Reply
chandrasheka...

Star

10258 Points

1760 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 10:10 AM|LINK

Hi,

Refer the link http://www.setha.info/ict-vb2008/43-ict-vb2008-0011.html

YCS
Please try the answer for the post and finally Don't forget to click “Mark as Answer” on the post that helped you.
- Reply
geniusvishal

Star

14308 Points

2821 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 10:21 AM|LINK

Check This:

http://www.codeproject.com/Articles/417693/Insert-Update-Delete-in-ASP-NET-Gridview-DataSourc

Vishal Ranjan

My Website
www.dotnetvishal.com
- Reply
janehollin

Member

1 Points

12 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 10:41 AM|LINK

Hi

Thanks for that. I don't want to use gridview - just a simple asp webform
- Reply
janehollin

Member

1 Points

12 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 10:45 AM|LINK

The problems with using VB is that you need to declare the variables and this is just adding more complication

I am just looking for a simple method

Even the W3schools site is out of date (they still use Sett - which is not supported anymore)
- Reply
geniusvishal

Star

14308 Points

2821 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 10:53 AM|LINK

janehollin
just a simple asp webform

http://www.codefixer.com/tutorials/insert_into_database.asp

By the way .. Do you want it in classic asp or asp.net??

If you are looking for classic asp ... Ask the Question in the following forums:

Forum for Classic ASP:

http://forums.iis.net/1032.aspx

Forum for Access Database:

http://www.access-programmers.co.uk/forums/

Vishal Ranjan

My Website
www.dotnetvishal.com
- Reply
geniusvishal

Star

14308 Points

2821 Posts

Re: There MUST be a simple way to get data from a webform into an Access Database ??

Dec 07, 2012 11:00 AM|LINK

And If you are looking for Asp.Net Webforms.. Then follow these links:

http://www.dotnetspider.com/resources/30381-really-best-code.aspx

http://stackoverflow.com/questions/10941284/how-to-insert-a-record-into-a-access-table-using-oledb

http://www.codeproject.com/Articles/1155/Simple-ADO-NET-Database-Read-Insert-Update-and-Del

Vishal Ranjan

My Website
www.dotnetvishal.com
- Marked as answer by Catherine Shan - MSFT on Dec 14, 2012 12:59 AM

‹ Previous Thread|Next Thread ›

There MUST be a simple way to get data from a webform into an Access Database ?? RSS

6 replies

janehollin

There MUST be a simple way to get data from a webform into an Access Database ??

chandrasheka...

Re: There MUST be a simple way to get data from a webform into an Access Database ??

geniusvishal

Re: There MUST be a simple way to get data from a webform into an Access Database ??

janehollin

Re: There MUST be a simple way to get data from a webform into an Access Database ??

janehollin

Re: There MUST be a simple way to get data from a webform into an Access Database ??

geniusvishal

Re: There MUST be a simple way to get data from a webform into an Access Database ??

janehollin

geniusvishal

Re: There MUST be a simple way to get data from a webform into an Access Database ??

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft