newbie: Can we do db access without reloading page 1

[MontrealSoft]

Hi, I am currently working daily on ASP, but willing to learn asp.net if it gets necessary.

I need to build a page that lets someone input an order. When they leave the "product code" field, I need the page to search a db on the server and show a list of corresponding items.
I would like it to appear in the same page without reloading the entire page everytime (performance issue).

Is there a way to make this with vb.net ?
I am not familiar with javascript but still succeded doing 75% of the work with javascript and an iframe, but I'd like a more powerful technology and I am concerned about visitors that don`t have javascript enabled.

MontrealSoft.com

http://www.montrealsoft.com

 

[Turkbear]

Hi,
You should be able in both classic asp and asp.net to create a subroutine that uses the Query Execute functions of a ADO data connection to populate a list of values without reloading the page - I am not near my references but try some of the examples here:

http://www.w3schools.com/asp/asp_ado.asp

and

http://www.w3schools.com/ado/ado_examples.asp

.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MontrealSoft]

According to my experience, I can query stuff quite easily and show it, but I want to know if I can have a subframe or iframe exchange be called, populate itself and send back the result to a field in the first frame... without ever reloading the first frame to prevent the user to loose focus while entering data.

MontrealSoft.com

http://www.montrealsoft.com

 

[Turkbear]

Hi,
since I do not use iframes in my asp or asp.net apps I do not know how that could be done, sorry.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ca8msm]

You can only do what you want by using javascript. An AJAX approach may be more suitable than an iframe, however it will obviously still rely on javascript. If you want a non-javascript approach, the user will have to click a button to initiate the search.

Mark,

Darlington Web Design
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks

 

[MontrealSoft]

Thank's guys. I now have to decide if I go the javascript/AJAX way on the first version of the site, or if I go with asp and search buttons and then plan an upgrade to ajax in version 2...

I hope I can do the javascript/AJAX without having to add software on the server (and having to learn those as well).

Luc

MontrealSoft.com

http://www.montrealsoft.com