未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
我在调试到OleDbDataAdapter1.InsertCommand.ExecuteNonQuery()这条指令的时候碰到（未处理“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。）
还有在OleDbDataAdapter1.DeleteCommand.CommandText = delstr中出现
（未处理的“System.NullReferenceException”类型的异常出现在 学生基本资料.exe 中。
其他信息: 未将对象引用设置到对象的实例。）的错误信息
在 OleDbDataAdapter1.UpdateCommand.CommandText = updatestr时出现
（未处理的“System.NullReferenceException”类型的异常出现在 学生基本资料.exe 中。
其他信息: 未将对象引用设置到对象的实例。）
这些错误我研究了半天不知道如何解决 希望那位高手能帮我回答一下 谢谢
问题点数：0、回复次数：6Top
1 楼gOODiDEA（无语）回复于 2003-12-03 05:54:38 得分 0
可能是您的SQL语句有错误，你贴上来看看Top
2 楼zheng8312（神仙）回复于 2003-12-03 09:44:53 得分 0
Dim addstr As String = "insert into 学生详细资料 (学号,姓名,性别,民族,学院,专业,班级,出生日期,身份证号码,银行帐号,家庭地址,家庭邮编,家庭电话,宿舍地址,宿舍电话,务农,孤儿、烈属,父母重疾、残疾,农村户口,人均月收入,父母下岗、退休,备注) values ("
addstr = addstr & sstuid & "," & sname & ","
addstr = addstr & ssex & "," & snation & ","
addstr = addstr & ssy & "," & szy & ","
addstr = addstr & sclass & "," & sbirth & ","
addstr = addstr & spersonid & "," & saccounts & ","
addstr = addstr & saddress & "," & shomecode & ","
addstr = addstr & shomephone & "," & sqsh & ","
addstr = addstr & sphone & "," & swn & ","
addstr = addstr & sgrhcs & "," & sfmzchcj & ","
addstr = addstr & shklb & "," & srjysr & ","
addstr = addstr & sfmxghtx & "," & sbz & ")"Top
3 楼zheng8312（神仙）回复于 2003-12-03 09:48:39 得分 0
我的学生详细资料是个视图并不是表 没有设主键是不是这个原因啊 视图可以设主键吗？Top
4 楼zheng8312（神仙）回复于 2003-12-03 09:53:54 得分 0
'定义更新SQL语句
Dim updatestr As String = "update 学生详细资料 set "
updatestr = updatestr & " name=" & sname
updatestr = updatestr & ", birth=" & sbirth
updatestr = updatestr & ", sex=" & ssex
updatestr = updatestr & ", phone=" & sphone
updatestr = updatestr & ", studi=" & sstudi
updatestr = updatestr & ", accounts=" & saccounts
updatestr = updatestr & ", Address=" & saddress
updatestr = updatestr & ", personid=" & spersonid
updatestr = updatestr & ", nation=" & snation
updatestr = updatestr & ", jg=" & sjg
updatestr = updatestr & ", zzmm=" & szzmm
updatestr = updatestr & ", qsh=" & sqsh
updatestr = updatestr & ", job=" & sjob
updatestr = updatestr & ", xy=" & sxy
updatestr = updatestr & ", zy=" & szy
updatestr = updatestr & ", class=" & sclass
updatestr = updatestr & ", sy=" & ssy
updatestr = updatestr & ", qsh=" & sqsh
updatestr = updatestr & ", homephone=" & shomephone
updatestr = updatestr & ", homecode=" & shomecode
updatestr = updatestr & ", bz=" & sbz
updatestr = updatestr & ", wn=" & swn
updatestr = updatestr & ", grhcs=" & sgrhcs
updatestr = updatestr & ", fmzchcj=" & sfmzchcj
updatestr = updatestr & ", fmxghtx=" & sfmxghtx
updatestr = updatestr & ", hklb=" & shklb
updatestr = updatestr & ", rjysr=" & srjysr
updatestr = updatestr & " where id=" & currentid
'打开连接并执行更新操作
OleDbConnection1.Open()
OleDbDataAdapter1.UpdateCommand.CommandText = updatestr
OleDbDataAdapter1.UpdateCommand.ExecuteNonQuery()Top
5 楼gOODiDEA（无语）回复于 2003-12-03 10:14:06 得分 0
Dim addstr As String = "insert into 学生详细资料 (学号,姓名,性别,民族,学院,专业,班级,出生日期,身份证号码,银行帐号,家庭地址,家庭邮编,家庭电话,宿舍地址,宿舍电话,务农,孤儿、烈属,父母重疾、残疾,农村户口,人均月收入,父母下岗、退休,备注) values ("'
addstr = addstr & sstuid & "', '" & sname & "','"
addstr = addstr & ssex & '","' & snation & "','"
对字符串的SQL操作需要在他两边加上''Top
6 楼gOODiDEA（无语）回复于 2003-12-03 10:16:12 得分 0
比如:
string xx = "Test";
INSERT INTO T_XXX ( F_YYY ) VALUES ( '"+ xx +"' )Top
