asp.net连接数据库 增加,修改,删除,查询代码
时间:2024-01-20 15:52:31
'数据库连接
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,数据库


猜你喜欢
全面阐述overflow:hidden属性
2008-08-18 13:30:00
Javascript removeChild()删除节点及删除子节点的方法
2023-07-02 05:30:22

段正淳的css笔记(6)-浅谈css框架开发
2008-01-13 22:42:00

潜谈产品设计中的可用性和可访问性
2009-01-18 12:47:00

MYSQL事务教程之Yii2.0商户提现功能
2024-01-21 10:05:46
Oracle 安装和卸载问题收集(集合篇)第1/6页
2009-07-02 12:20:00
与 Function 和 Object 相关的有趣代码
2010-05-07 12:29:00

Pycharm学习教程(1) 定制外观
2021-08-01 05:18:11

全面解析Python的While循环语句的使用方法
2023-12-21 04:41:11

mysql unix准换时间格式查找指定日期数据代码
2024-01-16 00:35:24
Python Pygame实战之实现经营类游戏梦想小镇代码版
2021-08-06 19:13:23

GoLand 2020.3 正式发布有不少新功能(支持泛型)
2024-04-25 15:27:40

golang中之strconv包的具体使用方法
2024-02-01 00:03:20
pymysql之cur.fetchall() 和cur.fetchone()用法详解
2024-01-15 14:31:50
浅谈Go语言中字符串和数组
2024-04-25 15:14:36
python Dataframe 合并与去重详情
2022-08-17 02:18:54
vscode 配置eslint和prettier正确方法
2022-12-31 04:54:44

python中dir函数用法分析
2023-09-05 10:23:09
浅谈javascript中onbeforeunload与onunload事件
2024-04-19 09:46:08
Mootools 1.2教程(10)——Fx.Tween的使用
2008-12-02 18:03:00