【asp】asp.net连接数据库 增加,修改,删除,查询代码-net-数据库

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net连接数据库 增加，修改，删除，查询代码】，下面是详细的讲解！

asp.net连接数据库 增加，修改，删除，查询代码

'数据库连接
Public Sub connectionDB()
Try

serverUrl=readFromIni(My.Application.Info.DirectoryPath & "\config.dll", "Service Information", "IPAddress")

serverID=readFromIni(My.Application.Info.DirectoryPath & "\config.dll", "Service Information", "Password")
serverName=readFromIni(My.Application.Info.DirectoryPath & "\config.dll", "Service Information", "userID")
serverDataBase=readFromIni(My.Application.Info.DirectoryPath & "\config.dll", "Service Information", "DataBaseName")
If serverID <> "" Then
connectionSqlString="server=" + serverUrl + ";Database=" + serverDataBase + ";uid=" + serverName + ";pwd=" + serverID + ";max pool size=500"
Else
connectionSqlString="server=" & serverUrl & ";integrated security=SSPI ;database=" & serverDataBase & ""
End If
conSql=New SqlConnection(connectionSqlString)
objCommand.Connection=conSql
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub


'数据操作执行
Public Sub getConn(ByVal SqlStr As String, ByVal TableName As String)
Try
objCommand.CommandText=SqlStr
objDataSet.Clear()
objDataAdapter.SelectCommand=objCommand
objDataAdapter.Fill(objDataSet, TableName)
Catch ex As Exception
errNo=1
MsgBox(ex.Message)
End Try
End Sub
'数据更新
Public Sub updateTable(ByVal StrSql As String)
objCommand.CommandText=StrSql
Try
conSql.Open()
Trans=conSql.BeginTransaction
objCommand.Transaction=Trans
objCommand.ExecuteNonQuery()
Trans.Commit()
Catch ese As Exception
MsgBox(ese.Message)
Trans.Rollback() '如果更新异常则取消所有更新
Finally
conSql.Close() '关闭连接
End Try
End Sub

关于asp.net连接数据库 增加，修改，删除，查询代码的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细