i'm trying to populate a datagrid with a data from a sql database and i keep getting this error The ConnectionString property has not been initialized.
my code looks something like this:
<Private Sub GetAssetDetails()
Dim cnn As New SqlClient.SqlConnection
Dim sql1 As String = "SELECT DETAIL.[OFFICE LOCATION],USERS._RESOURCEGUID,OS.[OS NAME]AS PRODUCTS,PROD.KNOWNAS AS PRODUCTS, USERS.[LAST LOGON]FROM INV_AEX_EU_CONTACT_DETAIL DETAIL,INV_AEX_EU_LOGON_USERS USERS,INV_AEX_SW_MICROSOFT_OFFICE PROD, INV_AEX_OS_OPERATING_SYSTEM(OS)WHERE DETAIL._RESOURCEGUID = USERS._RESOURCEGUID AND USERS._RESOURCEGUID = OS._RESOURCEGUID AND OS._RESOURCEGUID=PROD._RESOURCEGUID"
Dim command As SqlClient.SqlCommand = New SqlClient.SqlCommand(sql1, cnn)
Dim rs As SqlClient.SqlDataReader = command.ExecuteReader
rs = Command.ExecuteReader()
grdDetails.DataSource = rs
i've tried about everything but i can't seem to get it right.