473,387 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Getting user input to go to Access Database

JT
I have a web page with 5 text boxes. I have an access database with 5
fields that correspond to the text boxes.

I need to put the information that the user inputs to the text boxes in my
database.

I have created the DataConnection, DataAdapter, and generated the dataset.
I have also went to the databinding properties of each text box and pointed
them to the corresponding fields in my database.

I need to know how to put the data that the user inputs into the database.

Any help would be greatly appreciated.
The code is in VB.
Nov 19 '05 #1
7 1552
JT..
Go to :-http://samples.gotdotnet.com/quickstart/aspplus/
and under ASP.NET Web Forms> click Server-Side Data Access
Hope this helps.
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #2
JT
This is SQL.. is it the same as doing this in Access Database?
"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
JT..
Go to :-http://samples.gotdotnet.com/quickstart/aspplus/
and under ASP.NET Web Forms> click Server-Side Data Access
Hope this helps.
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 19 '05 #3
Yes !
Just change ur connectionstring to connect to your :-
MS ACCESSS database
for example:-"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.mdb;User Id=admin;Password=;"

Hope this helps!
Patrick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #4
> JTwrote:
I need to put the information that the user inputs to the text boxes in my database.

I have created the DataConnection, DataAdapter, and generated the dataset. I have also went to the databinding properties of each text box and pointed them to the corresponding fields in my database.

I need to know how to put the data that the user inputs into the database.


hmm.... can you be a little more specific??

are you saying that you already created a complete code that doesnt
input on the ms access database or you dont know how to input data on
a ms access database????
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
Nov 19 '05 #5
JT
I don't know how to input the data.

"bmongtangco" <bm*********@yahoo-dot-com.no-spam.invalid> wrote in message
news:42********@127.0.0.1...
JTwrote:

I need to put the information that the user inputs to the text boxes

in my
database.

I have created the DataConnection, DataAdapter, and generated the

dataset.
I have also went to the databinding properties of each text box and

pointed
them to the corresponding fields in my database.

I need to know how to put the data that the user inputs into the

database.


hmm.... can you be a little more specific??

are you saying that you already created a complete code that doesnt
input on the ms access database or you dont know how to input data on
a ms access database????
*---------------------------------*
Posted at: http://www.GroupSrv.com
*---------------------------------*

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Nov 19 '05 #6
JT
I just need to link text boxes.. not a datagrid.... this is so simple.. yet
there is no documentation on it.. this sucks

"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:ut**************@TK2MSFTNGP14.phx.gbl...
Yes !
Just change ur connectionstring to connect to your :-
MS ACCESSS database
for example:-"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.mdb;User Id=admin;Password=;"

Hope this helps!
Patrick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 19 '05 #7
"JT" <jt@prostartech.com> confessed in news:eeBzzAwDFHA.392
@TK2MSFTNGP14.phx.gbl:
I just need to link text boxes.. not a datagrid.... this is so simple.. yet there is no documentation on it.. this sucks

"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:ut**************@TK2MSFTNGP14.phx.gbl...
Yes !
Just change ur connectionstring to connect to your :-
MS ACCESSS database
for example:-"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.mdb;User Id=admin;Password=;"

Hope this helps!
Patrick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Look, you have to understanad a little about SQL, ASP.NET and ADO.NET.

1. You read the data from the user with ASP.NET
2. You connect to a database using ADO.NET
3. You place data in a table using the sql INSERT command.

Everything is well documented. There are *many* examples in the ASP.NET
quickstart.

Take a look at either gotodotnet.com or the asp.net sites for many
examples. If you have the full version of visual studio .net, then you have
these examples on your machine if you loaded the MSDN disks. Also, there
are examples available in the ASP.NET resource kit ( a great resource for
noobs, btw). There is also a set of sources on MSDN that are called 101
tips for VB.NET / C# that contain examples for doing everything with
ADO.NET.

Then there are at least 2 dozen other sites full of .net examples and
plenty of helpful people who have posted questions and answers including
tutorials about how to do this kind of simple stuff.

There's documentation all over the place--probably right on your machine.
Quit whining and go educate yourself like all the other folks here who have
done.

If computer programming was easy, then everybody could do it, right?

-- ipgrunt
Nov 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Mike Turco | last post by:
(This was also posted to comp.database.ms-access before I realized this was the hep group.) Lets say that my WinXP computer has two users: Michael and Kathryn. One or the other logs into the...
15
by: sara | last post by:
Hi I'm pretty new to Access here (using Access 2000), and appreciate the help and instruction. I gave myself 2.5 hours to research online and help and try to get this one, and I am not getting...
3
by: Patrick Olurotimi Ige | last post by:
How can i send LOGON_USER or User.Identity.Name to the Database? I'm working on a survey which is intranet based with Windows Authentication. I can get the current user by calling LOGON_USER or...
6
by: Brett | last post by:
Not sure what the problem is here... Trying to update from a datagrid to an access database using vb.net... Its not updating the database but Im not getting any errors... Here is my code... ...
6
by: Br | last post by:
Hi everyone, Another newbie-type question, Here's what I'd like to do: 1) Have a user type something into an input-field 2) Transfer that information into a database 3) Extract that...
2
by: PHP_Paul | last post by:
Ok, I'm trying to poineer into the wonderful area of PHP/MySQL programming, but I'm having some difficulties. http://www.paulhq.com/php/freepage.html should register, but when anyone fills something...
2
by: wertqt | last post by:
hi there, im having a slight problem in matching the user input(textbox's text) with the values in one of the columns from a MS Access database. Im using C#.NET. The situation is this : My...
5
by: olaamussah | last post by:
Hi, i just started learning perl which i would use for my uni. project unfortunately. Well, this is a simple user login page i tried to create but i cant get it to work. Can someone please check this...
4
by: gaya12 | last post by:
In ASP and using Ms access. I have a form which asks users to input some details. The details entered by the user will stored in a access database and also there is a calculation based on the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.