[VB.NET]Fill:SelectCommand.Connection property has not been
发布时间：2020-12-16 23:37:25 所属栏目：大数据 来源：网络整理
导读：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|/homeaut
|
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 __________________________________________________________________________ （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |