Try
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose() End Try
mycon.Close()
和 Try
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose()
mycon.Close()
End Try
有什么区别,为什么在使用时前面的对
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose() End Try
mycon.Close()
和 Try
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose()
mycon.Close()
End Try
有什么区别,为什么在使用时前面的对
end try //结束
finally// 关闭任何已经打开的链接。
Dim connstr As String = System.Configuration.ConfigurationManager.AppSettings("ConnString")
Dim mycon As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(connstr)
Dim mycmd As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand(mysql, mycon)
Dim myreader As Data.OleDb.OleDbDataReader
Try
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose() End Try
mycon.Close()
正确 Public Shared Function TheReader(ByVal mysql As String) As Data.OleDb.OleDbDataReader
Dim connstr As String = System.Configuration.ConfigurationManager.AppSettings("ConnString")
Dim mycon As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(connstr)
Dim mycmd As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand(mysql, mycon)
Dim myreader As Data.OleDb.OleDbDataReader
Try
mycon.Open()
myreader = mycmd.ExecuteReader
Return myreader
Catch e As Data.OleDb.OleDbException
Throw New Exception(e.Message)
Finally
mycmd.Dispose()
mycon.Close()
End Try
错误
都是要调要这个函数