回 帖 发 新 帖 刷新版面

主题:小弟急呀

运行一下代码,系统老提示:操作必须使用一个可更新的查询。 为什么?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim ConnString As String
        Dim strSql As String
        Dim Conn As New OleDbConnection
        ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
        ConnString += Server.MapPath("22.mdb")
        Conn.ConnectionString = ConnString
        Conn.Open()
        Dim cmd As New OleDbCommand
        Dim lngCount As Long
        strSql = " select * from mima where 学号='" & xuehao.Text & "'"
        cmd.Connection = Conn
        cmd.CommandText = strSql
        lngCount = cmd.ExecuteScalar()
        Try
            If lngCount = 0 Then

                strSql = " insert into mima values( '" & xuehao.Text & "','" & xingming.Text & "','" & mima.Text & "','" & dianhua.Text & "','" & youxiang.Text & "','" & dizhi.Text & " ') "

                cmd.Connection = Conn
                cmd.CommandText = strSql
                cmd.ExecuteNonQuery()
                Response.Write("恭喜")
            Else
                Response.Write("对不起,你的用户名已经有人使用")
                Response.Write("请更换其它名称再进行注册。")
            End If
        Catch Err As Exception
            Response.Write(Err.Message)
        End Try

        cmd.Dispose()
        Conn.Close()
    End Sub

End Class

回复列表 (共3个回复)

沙发

[url=http://bbs.dvbbs.net/dispbbs.asp?boardid=8&id=640124]http://bbs.dvbbs.net/dispbbs.asp?boardid=8&id=640124[/url]

板凳

我按照下列网址操作对吗?
http://www.code999.com/infoview/Article_193.html

3 楼

1、确定你的22.mdb文件没有在打开状态
2、把你的sql语句在access环境下执行一下,看是否sql语句本身有问题!

我来回复

您尚未登录,请登录后再回复。点此登录或注册