Attaching multiple combo box with each other on d basis of sql 2005.

[Sachin.]

hello friends ,

i m facing some problem in attaching multiple combo box with each other with the sql 2005 database in servlets.
ok so this is my problem in deatil:-

i just want to take multiple combo box on 1 page nd want to join all the combo box with sql database for data. And on the execution time when ever any user select value in the 1st combo box the value in the 2nd combo box should be automatically comes from sql database on the basis of value of 1st combo box.

and after that on clicking the submit button on the same page , all the selected data from combo boxes should be store in the sql 2005 database.

so friends , i hope u wil understand my problem nd reply me soon.

thank u ........

sachin.

[RamyaSivakanth]

Hi,
Send ur code piece so that we can give suggestions.

-Regards
Ramya

[mtyoung]

// change of combobox1
make xmlhttprequest by javascript
check the content of page when response come back

// submit
just update the database by form values

[Sachin.]

hi,
actually i did'nt write the code about this topic , i just want to think 1st nd than apply the solution regarding this topic.

can you people tell me the way to solve this problem ?
i just want to know the methods which can solve this problem.

[mtyoung]

make xmlhttprequest, can access database wont reload the page,
so can use to change content of checkbox2, checkbox3

for update database,
after you submit your form, just update the database by post/get form value in the target servlet

[Sachin.]

dear mtyoung,
i dont know the javascript. i know little bit servlets and jsp.

so if u give suggestions in these lang. so it wil better for me to understand.

[mtyoung]

sorry, i am not teacher...
would you mind search ajax in google by yourself?