16,722
社区成员




sqltxt = String.Format("INSERT INTO mc_user (userid, Name, Password, power, Enabled) VALUES('{0}','{1}','{2}',{3},{4})", dwEnrollNumber, name, dwPassword, dwPrivilege, dwEnabled)
Debug.Print(sqltxt)
Debug.Print(dwEnrollNumber)
Debug.Print(dwName)
Debug.Print(dwPassword)
Debug.Print(dwPrivilege)
Debug.Print(dwEnabled)
var i= dwName.IndexOf('\x0');
if(i!=-1)
dwName=dwName.Substring(0,i);
If dwName = "" Then
dwName = ""
Else
dwName = dwName.Substring(0, Len(dwName) - dwName.IndexOf(Chr(0)))
End If
问题终于解决了,附上解决方案,谢谢大家都帮助