asp.net (vb.net) connection module (module) for SQL Server 2000 database

asp.net|server| Data | database Module Mdlcommon
Public txtsql as String ' holds SQL statements
Public dbset as DataSet ' query-obtained recordset
Public errormsg as String ' holds error message

Public Function ExecuteSQL (ByVal strSQL As String, ByRef errmsg as String) as DataSet
Dim CNN as Sqlclient.sqlconnection
Dim cmd as New sqlclient.sqlcommand ()
Dim ADPT as Sqlclient.sqldataadapter
Dim rst as New DataSet ()
Dim Splitsql () as String
ErrMsg = ""
Try
Splitsql = Split (strSQL)
CNN = New Sqlclient.sqlconnection ("Data source= (local); initial catalog=urp;user id=sa;pwd=1234")

If InStr ("Insert,delete,update", ucase$ (splitsql (0)) Then
Cmd. Connection = CNN
Cmd. Connection.Open ()
Cmd.commandtext = strSQL
Cmd. ExecuteNonQuery ()
Else
ADPT = New Sqlclient.sqldataadapter (strSQL, CNN)
Adpt. Fill (RST)
ExecuteSQL = rst
End If
Catch ex as Exception
ErrMsg = ex. Message
Finally
rst = Nothing
CNN = Nothing
End Try
End Function End Module
When called, write the txtsql= "SELECT" in the asp.net background. From ... ";
Dbset=executesql (TXTSQL,ERRORMSG)