<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除了问题。出现了标题上写的错误。
还有,我修改的话,不一定每个字段都要往里写值的,可以写其中几个,然后点击“更新”吗?
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除了问题。出现了标题上写的错误。
还有,我修改的话,不一定每个字段都要往里写值的,可以写其中几个,然后点击“更新”吗?
我原先用asp的。没用用asp.net的。搞不明白2者哪个更好一点。诶~~~~~~~~~现在觉得asp.net真的不简单啊。
反正我都是手写.
你那工具也不怎么规范,比如:一般SQL语句中的关键字大写.