请教一个vb.net的问题
在以下代码中:
Private Function GetPsw(ByVal PassWord As String)
Dim connstr As New String( "provider=SQLOLEDB.1;User ID=sa;PassWord=110;Persist Security Info=false;Initial Catalog=wage;Data Source=.; ")
Dim Cn As New OleDbConnection
Dim searchSql As String
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
searchSql = "select * from 用户信息表 where 用户名= ' " & PassWord & " ' "
Try
Cn.ConnectionString = connstr
Cn.Open()
cmd = New OleDbCommand(searchSql, Cn)
dr = cmd.ExecuteReader()
Do While dr.Read()
Return Trim(dr.GetString(1))
Loop
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function
dr.getstring(1)是什么意思 是不是取找到数据的第二列信息啊
如果想取得找到了某一列的内容该怎么写啊
例如有一列名为 admin 想取他是数据应该怎么写啊
谢谢了 !!!
[解决办法]
dr.item( "admin ")