index | search | no replies | posting guidelines | help login | register
Index » Products » ASP DataGrid
search this forum:
:: ASP Report Wizard expiry message in an ASP page ::    show all messagesPost a New Message | Post a Reply
May 9 2005, 6:11 AM
 Re: ASP Report Wizard expiry message in an ASP ...Post a Reply

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

I'm not sure there is anything wrong with your code but just download and install the latest version.
Always make sure you create your set all your properties before creating your connection as shown below:

'declare variables
Dim objGrid
Dim  strConn
Dim  strSQL

strConn = "Provider=SQLOLEDB.1;Password="""";Persist Security Info=True;User ID=AAAA;Initial Catalog=bcsserv;Data Source=CCC-SRVBE017"

'Build an SQL command statement

strSQL = "Select auftragsnr,auftragsdatum,plz from STANDORT where SUBSTRING(plz,10,1) <> '  ' "

' Create an instance of DataGrid
Set objGrid = Server.CreateObject("AspWebSolution.DataGrid")

With objGrid
     '(optional) set your license key info
    .LicenseKey = "My license key "

    'Set your command statement
    .Command = strSQL
    .DefaultSortOrder = "plz"

   'Create a databse connection
    .CreateConnection (strConn)
    'Display the data grid
End With

'destroy objects
Set objGrid = Nothing

Pages: (1)   [1]

search this forum: