vb.net中dataset问题
来源:百度知道 编辑:UC知道 时间:2024/05/22 14:20:25
希望各位高手给予指点,在线等,讲的清楚的追加分数。
单纯用代码连接ACCESS数据库代码如下
Dim Objconn As OleDbConnection
Dim Objcmd As OleDbCommand
Dim ObjDr As OleDbDataReader
Dim Tsql$, Dsn$
Tsql = "select * from 表"
Dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""D:\aaa.mdb"""
Objconn = New OleDbConnection(Dsn)
Objconn.Open()
Objcmd = New OleDbCommand(Tsql, Objconn)
ObjDr = Objcmd.ExecuteReader()
ObjDr.Read()
'要做的写这里
ObjDr.Close()
Objcmd.Dispose()
Objconn.Dispose()
写一个这样的函数也可以的!~
Public Function SqlRefQuery(ByRef SqlDs As DataSet, _
ByVal StrSQL As String, _
ByVal TableName As String, _
Optional ByVal IsClear As Boolean = False _
) As Integer<