datagrid

[katli]

Hi all

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)

cnn.Open()
Dim rs As SqlClient.SqlDataReader = command.ExecuteReader
rs = Command.ExecuteReader()
grdDetails.DataSource = rs
grdDetails.DataBind()
cnn.Close()

>

i've tried about everything but i can't seem to get it right.
please help:confused:

[skalyanaraman]

add the folling code: in web.config file
<appSettings>
<add key="ConnectionString" value="Server=servername;uid=user;pwd=password;Initial Catalog=databasename;Connect Timeout=200"></add>
</appSettings>

<Private Sub GetAssetDetails()
dim myconn As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim cnn AsSqlClient.SqlConnection
cnn= New SqlConnection(myconn)

then your code..it will work

Hi all

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)

cnn.Open()
Dim rs As SqlClient.SqlDataReader = command.ExecuteReader
rs = Command.ExecuteReader()
grdDetails.DataSource = rs
grdDetails.DataBind()
cnn.Close()

>

i've tried about everything but i can't seem to get it right.
please help:confused:

[katli]

[thanks, i've tried it but get the following error when executing

Parser Error Message: Unrecognized configuration section 'appSettings'

this would be an error from the configuration form

[skalyanaraman]

add that tag inside the tag named <configuration> it will work

[thanks, i've tried it but get the following error when executing

Parser Error Message: Unrecognized configuration section 'appSettings'

this would be an error from the configuration form

[khanayub_chand]

Hi all

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)

cnn.Open()
Dim rs As SqlClient.SqlDataReader = command.ExecuteReader
rs = Command.ExecuteReader()
grdDetails.DataSource = rs
grdDetails.DataBind()
cnn.Close()

>

i've tried about everything but i can't seem to get it right.
please help:confused:

Kalti,you have not specified the connection string like
cnn.connectionString="your sqlConnection" then you
open your connection.
Insha Allah this will Work and if the problem persist then mail me
[e-mail]