Click here to Skip to main content
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

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? Pinmemberindyan_guy26-Sep-08 21:18 
GeneralHelp me: ASp Source code to generate ecard system in our website Pinmemberanuj vohra30-Sep-05 20:32 
GeneralASP Databases PinmemberAdeelAnsari2-Mar-04 0:16 
Generalasp PinsussAnonymous24-Oct-03 13:51 
GeneralMan old school stuff... PinsussAnonymous18-Nov-02 22:59 
GeneralOkay, but what if... PinmemberMarc Merritt18-Nov-02 4:44 
GeneralRe: Okay, but what if... PinmemberJediBaron18-Nov-02 7:51 
GeneralRe: Okay, but what if... PinmemberAmol Rajmane18-Nov-02 8:04 
GeneralHorrible article PinmemberMark Janveaux14-Nov-02 15:38 
GeneralRe: Horrible article PinmemberVictor Vogelpoel14-Nov-02 20:23 
GeneralInteresting approach ... PinmemberDejan Petrovic14-Nov-02 12:30 
Generalummmmm Pinmemberdclark14-Nov-02 6:21 
GeneralRe: ummmmm PinmemberAmol Rajmane14-Nov-02 6:49 
Generalpune "WebDezigner" before 4 years PinsussAnonymous31-Jan-05 22: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 | Mobile
Web03 | 2.8.140709.1 | Last Updated 14 Nov 2002
Article Copyright 2002 by Amol Rajmane
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid