TableAdapter: How do I create one which inserts values from a form into two tables?

I am creating a simple booking system. The system requires the users
to provide information regarding themselves and also the booking
detail. I want to send the data into two tables. One, the personalinfo
table and another bookinginfo. The bookinginfo, also has a column for
personalID which links it to the personalInfo table. How can I do this
with eiter an ASP button control use a table adapter to do it.
Sorry if this sounds trivial but I am really new to ASP and SQL.
RegardsYou'd need to simply write the data out to the table. Have a look at the
connection objects in .NET there is actually a lot of code that already does
what you want posted all over the web.
Regards,
Alvin Bruney
---
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley
"Fendi Baba" <effendi@.epitome.com.sg> wrote in message
news:1171175411.943113.134530@.h3g2000cwc.googlegroups.com...
>I am creating a simple booking system. The system requires the users
> to provide information regarding themselves and also the booking
> detail. I want to send the data into two tables. One, the personalinfo
> table and another bookinginfo. The bookinginfo, also has a column for
> personalID which links it to the personalInfo table. How can I do this
> with eiter an ASP button control use a table adapter to do it.
> Sorry if this sounds trivial but I am really new to ASP and SQL.
> Regards
>

TableAdapter: How do I create one which inserts values from a form into two tables?

I am creating a simple booking system. The system requires the users
to provide information regarding themselves and also the booking
detail. I want to send the data into two tables. One, the personalinfo
table and another bookinginfo. The bookinginfo, also has a column for
personalID which links it to the personalInfo table. How can I do this
with eiter an ASP button control use a table adapter to do it.

Sorry if this sounds trivial but I am really new to ASP and SQL.

RegardsYou'd need to simply write the data out to the table. Have a look at the
connection objects in .NET there is actually a lot of code that already does
what you want posted all over the web.

--
Regards,
Alvin Bruney
----------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

"Fendi Baba" <effendi@.epitome.com.sgwrote in message
news:1171175411.943113.134530@.h3g2000cwc.googlegro ups.com...

Quote:

Originally Posted by

>I am creating a simple booking system. The system requires the users
to provide information regarding themselves and also the booking
detail. I want to send the data into two tables. One, the personalinfo
table and another bookinginfo. The bookinginfo, also has a column for
personalID which links it to the personalInfo table. How can I do this
with eiter an ASP button control use a table adapter to do it.
>
Sorry if this sounds trivial but I am really new to ASP and SQL.
>
Regards
>

Tcl and requesting info .

Hi all ,

I need to make an exercise that queries online flights booking webpages such as

http://wcorp.itn.net/cgi/get?itn/pl/amexconsumer/index
http://www.britishairways.com/travel/home/public/en_il
http://cms.lufthansa.com/pre/de/en/homepage_Noframes/0,4449,0-0-605242,00.html
http://www.klm.com/il_en/

by sending the departue and arriving fields , now i can't seem to find in the viewsource
the' Method=get action=url '
it must be in post method but still i can't seem to work it out , i've tried everything from following the value fields and tracking to submit button etc.. , i'm stuck .
i need to write it in tcl but that's not realy the problem , i know it's a big request but if someone can maybe just point me in the right direction i'll be gratefull .

thanks in advance .Hey,

Is this an ASP.NET application you are doing? You can access the fields from the forms directly by specifying the name of the control, such as you have a txtFlight textbox, access it's properties by doing:

txtFlight.Text

Brian
Nah mate ,

I think i didn't make my self clear enough , you know when u do a search in google.com it redirects you to another page ,for example if i search for "help needed" i'll be redirected to

http://www.google.com/search?hl=en&q=help+needed

that is known as a method get action=...
now i want to do the same for the flight booking by accesing the webpage with for example the flights from Amsterdam to paris on the 1/1/2005 , but they do not use 'get action' they use post action which hides the real url/script which gets the required data and redirects and i can't seem to find the url/script in the view-source .
Anyone ?
Hey,

Using ASP.NET, if you have a search box named txtSearch, you can construct the search string as:

Response.Redirect("search.aspx?hl=en&q=" & txtSearch.Text.Replace(" ", "+"), false)

Brian