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