Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











METHOD:  DataControl::Refresh
datacontrolobject.Refresh

The Refresh method updates (refreshes) the results you obtained from a query by resubmitting the query to the data source. This can be very useful when working with a data source that can be updated at any time by other users. This method ensures that you have the latest possible results.

The previous Recordset is released. Since all unsaved changes are discarded, you may wish to save all pending changes before calling Refresh. The current record becomes the first record of the new, returned Recordset.

You can create a form on a Web page to input values for the various DataControl properties and use Request.Form( ) to assign the values:

Code (VBScript):
objDC.ExecuteOptions = Request.Form("ExecuteOptions")
objDC.FetchOptions = Request.Form("FetchOptions")
objDC.InternetTimeout = Request.Form("InternetTimeout")
objDC.Server = Request.Form("Server.Value")
objDC.SourceRecordset = Request.Form("SourceRecordset")
objDC.SQL = Request.Form("SQL")
objDC.URL = Request.Form("URL")
objDC.Connect = Request.Form("Connect")
objDC.Refresh

  


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information