Hi, I am loading a datagrid with data from a database using Adodc, but how can I change the width of the columns? and the name of the columns?
Also can anyone post an example of how i can load a datagrid without using the adodc control? I want to click a command button and have it load.
I can open a connection but I dont know what to do from there. Thanks in advance!
Dim strConn
Dim objConn As ADODB.Connection
Set objConn = New ADODB.Connection
strConn = "Provider=MSDASQL;Persist Security Info=False;Extended Properties=;DSN=*;UID=*;SERVER=*;PWD=*"
objConn.ConnectionString = strConn
objConn.Open
After this I guess i need to select a recordset and then do a loop and load the grid..but I am not sure of the syntax.
Also can anyone post an example of how i can load a datagrid without using the adodc control? I want to click a command button and have it load.
I can open a connection but I dont know what to do from there. Thanks in advance!
Dim strConn
Dim objConn As ADODB.Connection
Set objConn = New ADODB.Connection
strConn = "Provider=MSDASQL;Persist Security Info=False;Extended Properties=;DSN=*;UID=*;SERVER=*;PWD=*"
objConn.ConnectionString = strConn
objConn.Open
After this I guess i need to select a recordset and then do a loop and load the grid..but I am not sure of the syntax.