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

querying database to update list box on client side through java

P: n/a
I am attempting to develop a form that lists available speakers for a meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly appreciated.

Thanks in advance
Jun 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can use xmlhttp object in the client side.

"Eli Silverman" <El**********@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...
I am attempting to develop a form that lists available speakers for a
meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get
the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of
ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly
appreciated.

Thanks in advance

Jun 16 '06 #2

P: n/a
Thanks. That was the impression I was getting but I am having difficulty
finding an example to guide me. do you know of any that might be helpful?
Again I want to be able to send a text string or numeric value and receive
an object (dataset , recordset, datareader ... that I can parse through to
clear and repopulate a list box with.
Thanks again
"Balasubramanian Ramanathan" wrote:
You can use xmlhttp object in the client side.

"Eli Silverman" <El**********@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...
I am attempting to develop a form that lists available speakers for a
meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get
the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of
ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly
appreciated.

Thanks in advance


Jun 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.