郁闷了~~最简单的SQL执行不了~~~~

Question

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Configuration;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            System.Console.Write(string.Format("insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('{0}','{1}','{2}','{3}','{4}')","id","passWord","email","sex","imageurl"));
            OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            OleDbCommand com = new OleDbCommand();
            com.Connection = con;
            com.CommandText = "insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男','~/图片/A03183D45EHEJCF303[1].gif')";
            con.Open();
            int i=com.ExecuteNonQuery();
            System.Console.Write(i);
        }
    }
}
"insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男','~/图片/A03183D45EHEJCF303[1].gif')";
在access里执行都没有问题~~~~用在上面的代码里~~~控制态报错说“insert into 语句的语法错误”！！到底是怎么回事！！！

Answer 1

insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男','~//图片//A03183D45EHEJCF303[1].gif')

Answer 2

insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男','~//图片//A03183D45EHEJCF303[1].gif') 

Answer 3

insert into 注册(UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男',@'~/图/A03183D45EHEJCF303[1].gif') 

Answer 4

@'~/图片/A03183D45EHEJCF303[1].gif'没有用~~~我把@'~/图片/A03183D45EHEJCF303[1].gif'换成其他的字符窜都没用~~~~~~~~~`在ACCESS里我是用“文本”类型存放@'~/图片/A03183D45EHEJCF303[1].gif'

Answer 5

真的要暴走了~~我换了张表试了一下都没问题~~~~
com.CommandText = "insert into 好友(zhucID,friends) values(100,'uu')";//表换成“好友”用“注册”这表不知道怎么回事就是有问题~~
com.CommandText = "insert into 注册(UserID,PassWord) values('uu','999')"//换成这样还是抱错~~~
下面是UserID,PassWord的数据类型`~~
UserID,PassWord的常规定义都是一样的~~~~~如下
http://hiphotos.baidu.com/boss00000/pic/item/640bf6d9fed2c1f138012fc7.jpg

Answer 6

UserID,PassWord的常规定义都是一样的~~~~~如下

Answer 7

--try:"insert into [注册](UserID,PassWord,Email,Sex,ImageUrl) values('uu','uu','[email protected]','男','~/图片/A03183D45EHEJCF303[1].gif')"; 

Answer 8

还是错的，ACCESS报错~也不说错在什么地方~~~~~~`

Answer 9

raybvb09 ~~~~~~~~太帅了~~谢谢你~~我都要崩溃了，终于成功了~~~

Answer 10

估计你的问题是字段名password