Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Adding Data To Data Base

Reply
Thread Tools

Adding Data To Data Base

 
 
Paul Smith
Guest
Posts: n/a
 
      08-26-2005
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


 
Reply With Quote
 
 
 
 
John Rivers
Guest
Posts: n/a
 
      08-26-2005


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/
***
***
***

 
Reply With Quote
 
 
 
 
Paul W Smith
Guest
Posts: n/a
 
      08-27-2005
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" <> wrote in message
news: 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/
> ***
> ***
> ***
>



 
Reply With Quote
 
Bob Lehmann
Guest
Posts: n/a
 
      08-28-2005
I bet that your real name is Dick.

Bob Lehmann

"John Rivers" <> wrote in message
news: 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/
> ***
> ***
> ***
>



 
Reply With Quote
 
John Rivers
Guest
Posts: n/a
 
      08-29-2005
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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sizeof(EmptyStruct) in C and C++ (was: Base {}; sizeof(Base) == 1?) Alex Vinokur C Programming 7 08-14-2006 04:57 PM
Access of base class' private base class: qualification required, why Alf P. Steinbach C++ 6 09-03-2005 04:03 PM
Format of compiler generated derived destructor when base has 'virtual ~base() throw():" qazmlp C++ 1 04-10-2005 03:09 PM
Virtual function 'BasicMidReader::~BasicMidReader()' conflicts with base class 'base 'TMemoryStream' tomek C++ 2 12-01-2003 06:31 AM
Virtual function 'BasicMidReader::~BasicMidReader()' conflicts with base class 'base 'TMemoryStream' tomek C++ 3 11-30-2003 12:18 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57