Imports System.Data.SqlClient Imports System.Data PublicClass clsExecuteSQLClass clsExecuteSQL SharedFunction ExecuteSQL()Function ExecuteSQL(ByVal SQL AsString) As DataTable Try Dim CONN AsString CONN ="data source=localhost;Database=HAWK;Integrated Security=SSPI;" Dim sqlConn AsNew SqlConnection(CONN) Dim cmd As SqlCommand =New SqlCommand(SQL, sqlConn) cmd.CommandType = CommandType.Text Dim sTokens() AsString sTokens = SQL.Split("") '执行数据库的插入、删除、更新等操作 If Strings.InStr("INSERT,DELETE,UPDATE", sTokens(0).ToUpper) Then If sqlConn.State <> ConnectionState.Open Then sqlConn.Open() '打开数据库连接 EndIf cmd.ExecuteNonQuery() '执行SQL语句 If sqlConn.State <> ConnectionState.Closed Then sqlConn.Close() '关闭数据库连接 EndIf ReturnNothing '执行数据库的查询操作 Else Dim ObjectdsDataSet AsNew DataSet() Dim adapter AsNew SqlDataAdapter() adapter.SelectCommand = cmd If sqlConn.State <> ConnectionState.Open Then sqlConn.Open() '打开数据库连接 EndIf cmd.ExecuteNonQuery() '执行SQL语句 If sqlConn.State <> ConnectionState.Closed Then sqlConn.Close() '关闭数据库连接 EndIf adapter.Fill(ObjectdsDataSet) '填充数据集 Return ObjectdsDataSet.Tables(0) EndIf Catch MsgBox(Err.Description) EndTry ReturnNothing End Function End Class
Imports System.Data.SqlClientImports System.DataPublic Class clsExecuteSQLClass clsExecuteSQL Shared Function ExecuteSQL()Function ExecuteSQL(ByVal SQL As String) As DataTable Try