异常详细信息:
System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。
<asp:AccessDataSource ID= "AccessDataSource1 " runat= "server " DataFile= "~/DB/ESUN.mdb "
SelectCommand= "SELECT [CLIE_ID], [COMP_ID], [TYPE_ID], [CLIE_CHNAME], [CLIE_ENNAME], [CLIE_CHADD], [CLIE_ENADD],
[CLIE_TEL], [CLIE_LINKII], [CLIE_OTHERS], [ESUN_CHADD], [ESUN_ENADD] FROM [CLIENT_TBL] "
UpdateCommand= "Update [CLIENT_TBL] Set [CLIE_CHNAME]=@CLIE_CHNAME, [TYPE_ID]=@TYPE_ID,
[CLIE_ENNAME]=@CLIE_ENNAME, [CLIE_CHADD]=@CLIE_CHADD,[CLIE_ENADD]=@CLIE_ENADD,[CLIE_TEL]=@CLIE_TEL,
[CLIE_LINKII]=@CLIE_LINKII, [CLIE_OTHERS]=@CLIE_OTHERS,[ESUN_CHADD]=@ESUN_CHADD,
[ESUN_ENADD]=@ESUN_ENADD "
DeleteCommand= "delete from [CLIENT_TBL] where [CLIE_ID]=@CLIE_ID "
InsertCommand= "INSERT INTO [CLIENT_TBL]([CLIE_ID],[COMP_ID], [TYPE_ID], [CLIE_CHNAME], [CLIE_ENNAME], [CLIE_CHADD], [CLIE_ENADD],
[CLIE_TEL], [CLIE_LINKII], [CLIE_OTHERS], [ESUN_CHADD], [ESUN_ENADD]) Values
(@CLIE_ID,@COMP_ID, @TYPE_ID, @CLIE_CHNAME, @CLIE_ENNAME, @CLIE_CHADD, @CLIE_ENADD,
@CLIE_TEL, @CLIE_LINKII, @CLIE_OTHERS, @ESUN_CHADD, @ESUN_ENADD) "> </asp:AccessDataSource>
其他的都好用,就是insert除了问题。出现了标题上写的错误。
还有,我修改的话,不一定每个字段都要往里写值的,可以写其中几个,然后点击“更新”吗?
------解决方案--------------------必需