Click here to Skip to main content
11,437,978 members (52,513 online)
Click here to Skip to main content

Get data from database without refreshing the page

, 13 Nov 2002
Rate this:
Please Sign up or sign in to vote.
works in all browsers

Introduction

The flow of the application is interrupted by page reloads whenever the client communicates with the server. Here is the simple solution to this problem, you can get data from a database without refreshing page. I tested this application with all browsers and it worked fine.

Zip file contains:

  • Default.asp (HTML interface)
  • getAllMembers.asp (gets all data from database)
  • db.mdb (User information database)

Following function calls another page to get information (data) from the database. Pass "First name" and "Last Name" to getAllMembers.asp page.

function getAllMembers()
{
    var FirstName;
    var LastName;
    var memberName;
    FirstName = document.frmUsers.txtFirstName.value;
    LastName =  document.frmUsers.txtLastName.value;
    memberName = "firstName="+ FirstName +"&lastName="+ LastName;
    window.open("getAllMembers.asp?"+ memberName,"lstNames",
        "width=200,height=100,left=200,top=300")
}

In getAllMembers.asp page, use window.opener.document.frm. This method is used to pass all values to the list box on main page.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Amol Rajmane
Web Developer
United States United States

  • A Software Professional with five years of experience as Software Engineer in Analysis, Design and Development of software applications using ASP/JavaScript/SQL Server 2000.
  • Rich development experience in Internet/Intranet based applications using ASP, MS SQL Server, JavaScript and tools like Visual InterDev 6.0.
  • Expertise in ASP, VBScript, JavaScript, HTML, XML, COM, and SQL Server.
  • Experience in analyzing and handling complex Database Design.
  • He holds BS in Electronics Engineering.

Comments and Discussions

 
QuestionHow to retrieve all results from a site? Pin
indyan_guy26-Sep-08 22:18
memberindyan_guy26-Sep-08 22:18 
GeneralHelp me: ASp Source code to generate ecard system in our website Pin
anuj vohra30-Sep-05 21:32
memberanuj vohra30-Sep-05 21:32 
GeneralASP Databases Pin
AdeelAnsari2-Mar-04 1:16
memberAdeelAnsari2-Mar-04 1:16 
Generalasp Pin
Anonymous24-Oct-03 14:51
sussAnonymous24-Oct-03 14:51 
GeneralMan old school stuff... Pin
Anonymous18-Nov-02 23:59
sussAnonymous18-Nov-02 23:59 
GeneralOkay, but what if... Pin
Marc Merritt18-Nov-02 5:44
memberMarc Merritt18-Nov-02 5:44 
GeneralRe: Okay, but what if... Pin
JediBaron18-Nov-02 8:51
memberJediBaron18-Nov-02 8:51 
GeneralRe: Okay, but what if... Pin
Amol Rajmane18-Nov-02 9:04
memberAmol Rajmane18-Nov-02 9:04 
GeneralHorrible article Pin
Mark Janveaux14-Nov-02 16:38
memberMark Janveaux14-Nov-02 16:38 
GeneralRe: Horrible article Pin
Victor Vogelpoel14-Nov-02 21:23
memberVictor Vogelpoel14-Nov-02 21:23 
GeneralInteresting approach ... Pin
Dejan Petrovic14-Nov-02 13:30
memberDejan Petrovic14-Nov-02 13:30 
Generalummmmm Pin
dclark14-Nov-02 7:21
memberdclark14-Nov-02 7:21 
GeneralRe: ummmmm Pin
Amol Rajmane14-Nov-02 7:49
memberAmol Rajmane14-Nov-02 7:49 
Generalpune "WebDezigner" before 4 years Pin
Anonymous31-Jan-05 23:59
sussAnonymous31-Jan-05 23:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.150506.1 | Last Updated 14 Nov 2002
Article Copyright 2002 by Amol Rajmane
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid