字段太小而不能接受所要添加的数据的数量。试着插入或粘贴较少的数据

Question

string OleDb = "INSERT INTO [User]([UserName],[UserLoginID],[UserLoginPassword],[Sex],[Organization],[Address],[Telphone],[Email],[Business],[Photo]) VALUES('@UserName','@UserLoginID','@UserLoginPassword','@Sex','@Organization','@Address','@Telphone','@Email','@Business','@Photo')";
   
   try
   {
    OleDbParameter[] para = new OleDbParameter[]
    {
                    new OleDbParameter("@UserName",user.UserName),
                    new OleDbParameter("@UserLoginID",user.UserLoginID),
                    new OleDbParameter("@UserLoginPassword",user.UserLoginPassword),
                    new OleDbParameter("@Sex",user.Sex),
                    new OleDbParameter("@Organization",user.Organization),
     new OleDbParameter("@Address",user.Address),
                    new OleDbParameter("@Telphone",user.Telphone),
                    new OleDbParameter("@Email",user.Email),
                    new OleDbParameter("@Business",user.Business),
     new OleDbParameter("@Photo",user.Photo),
                   
     
    };

    int i=DBHelper.ExecuteCommand(OleDb, para);

                return i == 1 ? true : false;
   }
   catch (Exception e)
   {
    Console.WriteLine(e.Message);
    throw e;
   }

System.Data.OleDb.OleDbException: 查询值的数目与目标字段中的数目不同。

Answer 1

表面上看少了photo，代码不完整，看不出来啊。