我是个初学者,想问怎样才能访问数据库中某一条纪录中字段中的内容
我的登录代码
Dim Connstr Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码 'sql数据库连接参数:连接名(本地用local,外地用IP)、数据库名、用户名、用户密码
Dim SqlLocalName, SqlDatabaseName, SqlUsername, SqlPassword
SqlLocalName = "(local)"
SqlDatabaseName = "ScoreManager"
SqlUsername = "sa"
SqlPassword = ""
Connstr = "Provider=Sqloledb ; User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName
End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Request.Form("user_name") <> "" Then Dim Conn
Conn = Server.CreateObject("ADODB.Connection")
Conn.Open(Connstr)
Dim strSQL As String = "SELECT * FROM stu_info where stu_name='" & Request.Form("user_name") & "'"
Dim rs
rs = Server.CreateObject("adodb.recordset")
rs.Open(strSQL, Conn, 3, 1)
If Not rs.EOF Then
Dim a, b As String
a = Request.Form("pwd")
'Response.Write(a) b = rs.GetString(2)
'Response.Write(b) If a = b Then
Response.Write("成功登录!")
Else
Response.Write("密码错误!!")
End If
Else
Response.Write("无此用户!")
End If
Else
Response.Write("请输入用户名!")
End If
End Sub
End Class
其中rs.GetString(2)不知道是什么意思,希望得到解释
该代码比较垃圾,如果那位高手有这方面的代码,希望贴出来给小弟参考参考,不过希望简单的,易懂点
我的登录代码
Dim Connstr Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码 'sql数据库连接参数:连接名(本地用local,外地用IP)、数据库名、用户名、用户密码
Dim SqlLocalName, SqlDatabaseName, SqlUsername, SqlPassword
SqlLocalName = "(local)"
SqlDatabaseName = "ScoreManager"
SqlUsername = "sa"
SqlPassword = ""
Connstr = "Provider=Sqloledb ; User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName
End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Request.Form("user_name") <> "" Then Dim Conn
Conn = Server.CreateObject("ADODB.Connection")
Conn.Open(Connstr)
Dim strSQL As String = "SELECT * FROM stu_info where stu_name='" & Request.Form("user_name") & "'"
Dim rs
rs = Server.CreateObject("adodb.recordset")
rs.Open(strSQL, Conn, 3, 1)
If Not rs.EOF Then
Dim a, b As String
a = Request.Form("pwd")
'Response.Write(a) b = rs.GetString(2)
'Response.Write(b) If a = b Then
Response.Write("成功登录!")
Else
Response.Write("密码错误!!")
End If
Else
Response.Write("无此用户!")
End If
Else
Response.Write("请输入用户名!")
End If
End Sub
End Class
其中rs.GetString(2)不知道是什么意思,希望得到解释
该代码比较垃圾,如果那位高手有这方面的代码,希望贴出来给小弟参考参考,不过希望简单的,易懂点
解决方案 »
- 有人能提供asp.net中使用treeview控件加载无限级树以及利用树导航页面的教程吗?
- 两个int相除如何得到float
- (急)upload.cs中上传文件,怎么返回路径啊???
- 用ASP.NEYT向数据库插入数据的问题
- 奇怪Request.Form()不能取到Html传过来的值,请指教..急,在线等
- 不知道哪里错了,希望那个大家帮忙看一下
- 在VS2005GridView中怎么分页显示信息?那个帮忙讲解一下?
- 专业的Windows mobile google map api google earth api C#.net asp.net 开发资料站点
- 急聘asp.net高手!!!!!
- 求助,请大家帮忙:<asp:BoundColumn>绑定列显示太长,设置ItemStyle-Width后又折行,如何解决?
- about dropdownlist 中控件的問題
- 请求已超时。[HttpException (0x80004005): 请求已超时。]
该段代码是读取RecordSet中的当前记录的第二个字段的值。那段代码写得确实够垃圾的。