注册 登录
编程论坛 ASP.NET技术论坛

会员管理系统之修改会员数据

谢宇 发布于 2012-06-16 21:52, 534 次点击
   Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs)
        Dim objConn As New OleDbConnection()
        objConn.ConnectionString = "Provider=Microsoft.Jet.OleDB.4.0;" & "Data Source=" & Server.MapPath("/作业/HTGL.mdb")
        objConn.Open()
        Dim objCmd As New OleDbCommand()
        objCmd.Connection = objConn
         = "Select * From 会员用户 Where 账号='" & User.Identity.Name & "'"
        Dim objReader As OleDbDataReader = objCmd.ExecuteReader()
        objReader.Read()
        showUserId.Text = objReader.Item("账号")     一直显示不存在此列/行的数据
        密码.Text = objReader.Item("密码")
        确认密码.Text = objReader.Item("密码")
        用户名.Text = objReader.Item("用户名")
        If objReader.Item("性别") = "男" Then
            性别.Items(0).Selected = True
        Else
            性别.Items(1).Selected = True
        End If
        Dim I As Integer
        For I = 1982 To 1994
            出生年.Items.Add(I)
            If objReader.Item("出生年") = I Then 出生年.Items(I - 1982).Selected = True
        Next
        For I = 1 To 12
            出生月.Items.Add(I)
            If objReader.Item("出生月") = I Then 出生月.Items(I - 1).Selected = True
        Next
        For I = 1 To 20
            出生日.Items.Add(I)
            If objReader.Item("出生日") = I Then 出生日.Items(I - 1).Selected = True
        Next
        电话.Text = objReader.Item("电话")
        objReader.Close()
        objConn.Close()
    End Sub
求解决方法,,急用,谢了
3 回复
#2
yms1232012-06-18 16:08
账号这个字段不存在,还有就是字段名一定不要使用中文,因为中文会出各种问题
#3
谢宇2012-06-18 20:00
回复 2楼 yms123
账号字段确定存在啊
#4
gjtxc2012-08-20 18:43
找不到 账号='" & User.Identity.Name & "'"的记录,查看user.identity这个类。

1