[VB.NET]Fill:SelectCommand.Connection property has not been initialized

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
Fill:SelectCommand.Connection property has not been initialized
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand


Connection.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/homeautosys.mdb
Connection.Open()
DataTab_LightOff.Clear()

Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand

Dim DataAdapter_LighOff As System.Data.DataSet = New System.Data.DataSet

command_LightOff = update [Lights] set [Off_On]= Off Where ( [Lights].[Room_Name]= Bedroom One )

DataAdapter_LightOff = New Data.OleDb.OleDbDataAdapter(command_LightOff, Connection)


dataAdapter.Fill(DataTab_LightOff)

这是源代码，编译的时候出现错误：Fill:SelectCommand.Connection property has not been initialized
这是什么原因？该怎么改？
是在移动页面上做的
目的是实现点ＣＯＭＭＡＮＤ的控件，然后数据库中中ＢＥＤＲＯＯＭ　ＯＮＥ的那行的ＯＦＦ＿ＯＮ列对应的值变为ＯＦＦ
如果上面的方法不对，最完写完整的另外的代码！
__________________________________________________________________________
dbCommand.CommandText = select *.... ;
需要指定。
__________________________________________________________________________

Connection.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/homeautosys.mdb
Connection.Open()

Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand( update [Lights] set [Off_On]= Off Where ( [Lights].[Room_Name]= Bedroom One ) )
dbCommand.Connection=Connection

dbCommand.ExecuteNonQuery
__________________________________________________________________________