Tossing My Computer Out Window.. (DATA Help)

[Anjari]

sigh ok,,,,

my MS SQl DB is sitting on my web server... I have created a connection and such and can get it to display data if I "Preview Data" from inside the editor...

I placed this on my formload but I keep getting the following error... any suggestions?


My Code:


SqlCommand1.CommandText = "SELECT * FROM Employees"
SqlDataAdapter1.SelectCommand = SqlCommand1
Me.DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)

----------------------------------

Error:

An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll

Additional information: Fill: SelectCommand.Connection property has not been initialized.

and it will heighlight the line:

SqlDataAdapter1.Fill(DataSet11)

???

any help?

Anjari

[bilko73]

you need to open your connection before you fill your dataset

sqlconnection1.open

then close it when done

sqlconnection1.close

[pvb]

you don't need to open and close a connection with the dataadapter(the Fill method takes care of that for you). But you need to make sure your command has a connection associated with it. mycommand.connection = yourconnectionobject

[bilko73]

yeah, it doesn't need to be opened...sorry thought it did because the dataform wizard puts that code in there for you...why?, i have no idea

[Anjari]

mycommand.connection = yourconnectionobject

Elaborate on the "yourconnectionobject" part please...

Anjari

[Lunatic3]

yourconnectionobject is simply the name of connection you use to connect to your sql server.