VB.NET连接上ACCESS数据库后,如何读取特定行列的数据并返回。
------解决方案--------------------
可通过select查询语句结合where 返回查询结果阿
------解决方案--------------------
如通过字段与id号就可取指定行了,
Dim con As New OleDbConnection
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\data.mdb"
con.Open()
cmd.Connection = con
cmd.CommandText = "select 字段1 from table1 where ID=id"
dr = cmd.ExecuteReader()
If dr.Read() Then
TextBox2.Text = dr(0)
End If
dr.Close()
con.Close()
------解决方案--------------------
myConn.Open()
Dim str As String = "SELECT*FROM 表 WHERE id=行号"
Dim myCommand As Command = NewCommand(str, myConn)
myCommand.ExecuteNonQuery()
myConn.Close()