Click to See Complete Forum and Search --> : datagrid
smh
Nov 17th, 2000, 09:17 AM
I am new with using the datagrid, and would like some instruction on how to use it. I would like to only use code to fill the datagrid. Any good examples out there?
Thanks,
smh
barrk
Nov 17th, 2000, 10:55 AM
set objconn = createObject("ADODB.Connection")
objconn.open "driver={sql server};server=SQLSERVER;database=Logging;uid=administrator;Pwd=beer"
set mycommand = CreateObject("ADODB.Command")
Set mycommand.ActiveConnection = objconn
Set myrs = CreateObject("ADODB.Recordset")
mycommand.commandtext = "Select * from sometable"
myrs.open mycommand
set the datagrid.datasource = to myrs
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.