By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,916 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,916 IT Pros & Developers. It's quick & easy.

Adding Data To Data Base

P: n/a
I have a web form which collects user data. It is populated with options
stored in an access DB. I have successfully managed to bind my form
controls to the required sources.

My problem is now how do I update two other tables in the access DB with, 1.
data obtained from text boxes on the form and 2. their selections form
lists.

The reference book I am working from does not show an example of adding
records only updating records shown using a data grid!!!!!

I have the code below from a web search, but do not understand where to put
the following line of code:

Imports System.Data.OleDb

I actually do not understand the code which use 'New oleDbCommand', I would
like to do it using a dataset which at least I have some minor understanding
of.

If anyone has any web references which show me how to achieve my aims please
post them
Nov 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a


Please see my comments below ...
Paul Smith wrote:
I have a web form which collects user data. It is populated with options
stored in an access DB. I have successfully managed to bind my form
controls to the required sources.

My problem is now how do I update two other tables in the access DB with, 1.
data obtained from text boxes on the form and 2. their selections form
lists.

The reference book I am working from does not show an example of adding
records only updating records shown using a data grid!!!!!

I have the code below from a web search, but do not understand where to put
the following line of code:

Imports System.Data.OleDb
***
***
***
have you tried balancing it on your head?
***
***
***

I actually do not understand the code which use 'New oleDbCommand', I would
like to do it using a dataset which at least I have some minor understanding
of.

If anyone has any web references which show me how to achieve my aims please
post them


***
***
***
this might help:

http://www.rathergood.com/moon_song/
***
***
***

Nov 19 '05 #2

P: n/a
Thanks John,

At the risk of being accused of not being able to take a joke, what was the
point of your comments. maybe they would have been better appreciated at:

alt.smug_git.timewaster

I posted what was genuine problems, if it was too simle to be worthy of
decent consideration I apologise for not knowing this.

Paul Smith
"John Rivers" <fi*****@btinternet.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...


Please see my comments below ...
Paul Smith wrote:
I have a web form which collects user data. It is populated with options
stored in an access DB. I have successfully managed to bind my form
controls to the required sources.

My problem is now how do I update two other tables in the access DB with,
1.
data obtained from text boxes on the form and 2. their selections form
lists.

The reference book I am working from does not show an example of adding
records only updating records shown using a data grid!!!!!

I have the code below from a web search, but do not understand where to
put
the following line of code:

Imports System.Data.OleDb


***
***
***
have you tried balancing it on your head?
***
***
***

I actually do not understand the code which use 'New oleDbCommand', I
would
like to do it using a dataset which at least I have some minor
understanding
of.

If anyone has any web references which show me how to achieve my aims
please
post them


***
***
***
this might help:

http://www.rathergood.com/moon_song/
***
***
***

Nov 19 '05 #3

P: n/a
I bet that your real name is Dick.

Bob Lehmann

"John Rivers" <fi*****@btinternet.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...


Please see my comments below ...
Paul Smith wrote:
I have a web form which collects user data. It is populated with options stored in an access DB. I have successfully managed to bind my form
controls to the required sources.

My problem is now how do I update two other tables in the access DB with, 1. data obtained from text boxes on the form and 2. their selections form
lists.

The reference book I am working from does not show an example of adding
records only updating records shown using a data grid!!!!!

I have the code below from a web search, but do not understand where to put the following line of code:

Imports System.Data.OleDb


***
***
***
have you tried balancing it on your head?
***
***
***

I actually do not understand the code which use 'New oleDbCommand', I would like to do it using a dataset which at least I have some minor understanding of.

If anyone has any web references which show me how to achieve my aims please post them


***
***
***
this might help:

http://www.rathergood.com/moon_song/
***
***
***

Nov 19 '05 #4

P: n/a
It was only meant to playfully mocking,
i'm sorry if it came across as nasty,
did you enjoy the moonsong?

The real reason for my mockery - an attempt
to teach you that this job can be hell
if don't do your reading. Before you try
and write VB why not read about it first?

It will be much more enjoyable experience for you.

Furthermore you can answer the question yourself
just by typing "Imports" and hitting F1 and
reading what it says.

Its actually quicker and easier than using a newsgroup too.

Enjoy your coding :-|

Nov 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.