VB.net访问查询错误需要帮助 [英] VB.net Access Query Error Need help

问题描述

你好，

我是vb.net的新手.

开始了一个小型测试项目.

我的代码如下.这是一个MS Access插入查询，向我显示错误插入到语句中的语法错误".如果我从调试器复制此语句并直接插入到MS Access中，则它起作用.找不到错误.请帮忙.

strCreateUser = "Insert into tbl_users (Operator,UserName,Password,Active,Status)  
values(''" TxtOperatorName.Text.ToString()  "'',
''"  TxtUser.Text.ToString  "'', 
''" EncryptedPass "'', 
" ActiveStatus ",
" UserLevel " )"

Try
            CreateUserConn = New OleDb.OleDbConnection(GlobalConn)
            CreateUserAdpt = New OleDb.OleDbDataAdapter(strCreateUser, GlobalConn)
            If CreateUserConn.State = ConnectionState.Open Then CreateUserConn.Close()
            CreateUserConn.Open()
            CreateUserCmd = New OleDb.OleDbCommand(strCreateUser, CreateUserConn)
            CreateUserCmd.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try

提前谢谢.
Ram.

解决方案

请确保ActiveStatus 和UserLevel 值的格式符合其数据库类型(例如，它们是布尔值或字符串).

Hello,

I am new to vb.net.

Started a small testing project.

My code is below. It is an MS Access insert query which is showing me error "Syntax Error in Insert Into Statement", If i copied this from debugger and directly inserting to MS access it is working. Unable to find the error. Please Help.

strCreateUser = "Insert into tbl_users (Operator,UserName,Password,Active,Status)  
values(''" TxtOperatorName.Text.ToString()  "'',
''"  TxtUser.Text.ToString  "'', 
''" EncryptedPass "'', 
" ActiveStatus ",
" UserLevel " )"

Try
            CreateUserConn = New OleDb.OleDbConnection(GlobalConn)
            CreateUserAdpt = New OleDb.OleDbDataAdapter(strCreateUser, GlobalConn)
            If CreateUserConn.State = ConnectionState.Open Then CreateUserConn.Close()
            CreateUserConn.Open()
            CreateUserCmd = New OleDb.OleDbCommand(strCreateUser, CreateUserConn)
            CreateUserCmd.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message.ToString())
        End Try

Thanks in advance.
Ram.

解决方案

Make sure ActiveStatus and UserLevel values are formatted as per their database type (as in, they are boolean or strings).

这篇关于VB.net访问查询错误需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！