读书人

请问一个vb.net的有关问题

发布时间: 2012-02-21 16:26:23 作者: rapoo

请教一个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 ")

读书人网 >VB Dotnet

热点推荐