View User Profile

Comment: Re: Dynamically Creating DataGrid Columns
Hi Ryan,

My code is..... Im using the default datagrid of VB6.... Do I need to use the SLX ocx?where can I download it? Thanks

Dim col
Dim i

With DataGrid1
.SQL.Text = "SELECT header_id, order_no, ordered_date FROM so_header"

With .Columns
'remove any existing columns
If (.Count > 0) Then
For i = 0 To .Count - 1
.Item(0).Delete
Next
End If

'add column for header_id field
Set col = .Add(0)
col.FieldName = "header_id"
col.Caption = "Header ID"
col.ReadOnly = True

'add column for order_no field
Set col = .Add(0)
col.FieldName = "order_no"
col.Caption = "Order No"
col.ReadOnly = True
'add column for ordered_date field
Set col = .Add(0)
col.FieldName = "ordered_date"
col.Caption = "Order Date"
col.ReadOnly = True

End With
'now refresh the grid to see the new columns
.Refresh
End With

Author: Ferdi - 6/21/2007

Comment: Re: Dynamically Creating DataGrid Columns
Im trying to retrieve record during runtime using datagrid. Im getting a compile error method or data member not found.....How will I solve this problem? Am I missing something?Do I need to download the SLXSaleslogic.ocx? Thanks

Author: Ferdi - 6/20/2007

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/25/2024 4:36:26 AM