怎么样处理OleDbCommand执行查询无效问题？
今日连接数据库，写下以下代码
DimconnAsNewOleDbConnectionDimcmdAsNewOleDbCommand()conn.ConnectionString=ConfigurationManager.ConnectionStrings("AccessConn").ConnectionStringcmd.Connection=connconn.Open()cmd.CommandText=SQLstrDimpreviousConnectionStateAsConnectionState=conn.StateTryIfconn.State=ConnectionState.ClosedThenconn.Open()EndIfcmd.ExecuteNonQuery()conn.Close()showph(PlaceHolder3)CatchexAsExceptionl_e.Text="出现错误"&ex.MessageFinallyIfpreviousConnectionState=ConnectionState.ClosedThenconn.Close()EndIfEndTry发现无效，于是百端调试，未见其果
最后终于于偶然发现结症所在，上面代码conn.open过早，前半部分调整为
DimconnAsNewOleDbConnectionDimcmdAsNewOleDbCommand()conn.ConnectionString=ConfigurationManager.ConnectionStrings("AccessConn").ConnectionStringconn.Open()cmd.CommandText=SQLstrDimpreviousConnectionStateAsConnectionState=conn.Statecmd.Connection=conn即可
本文地址：http://www.45fan.com/dnjc/72326.html