index | search | no replies | posting guidelines | help login | register
Index » Products » ASP DataGrid
search this forum:
:: Hierachical grid bug or bad use ? ::    show all messagesPost a New Message | Post a Reply
Jan 11 2005, 2:43 AM
 Re: Hierachical grid bug or bad use ?Post a Reply
 ghost

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

from: Washington, DC

Try this:

Dim sConnString, objGrid
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Mysource.mdb;"
Set objGrid = Server.CreateObject("AspWebSolution.DataGrid")

With objGrid
    .Command = "SELECT Table1.NomUser, Table1.AdressUSER, Table2.Date, Table2.Operation FROM Table1, Table2 WHERE Table1.IdUSER=Table2.IdUSER"
    Call .ColumnCaption("Table1.NomUser","Name")
    Call .ColumnCaption("Table1.AdressUSER","Adress")
    
    .MasterTable = "Table1"
    .title = "Test"
    
    .GridStyle = "background-color:gray;"
    .HeaderStyle = "background-color:#666699;"
    .HeaderTextStyle = "color:white;font-family:verdana;font-size:8pt;"
    .ItemStyle = "background-color:#d2d1de;color:000000;font-family:verdana;font-size:8pt;"
    .AltItemStyle = "background-color:#f5f5f5;color:000000;font-family:verdana;font-size:8pt;"
    .FooterStyle = "font-family:verdana;font-size:8pt;"
    
    .AddRowNumbers = False
    .CanFilter = True
    
    'Create a databse connection
    Call .CreateConnection(sConnString)

    'Display the data grid
    .Display
End With
Set objGrid = Nothing

P/S: Read the online manual




-------------------------
Ghost
Pages: (1)   [1]

search this forum: