skyConnect1.SqlExecute("insert FSPTB_POINT values(" + "'" + DatarowKAEI["MEMBER_CODE"].ToString() + "'" + ",'" + DatarowKAEI["OLD_MEMBER_CODE"].ToString() + "'" + ",'" + DatarowKAEI["YUTAI_RANK"].ToString() + "'" + "," + NowPoint.ToString() + "," + DatarowKAEI["ADD_POINT"].ToString() + "," + OutruikeiPoint.ToString() + "," + AddruikeiPoint.ToString() + "," + "0,0,NULL,0" + "," + DatarowKAEI["TUKI_KAIAGE_M"].ToString() + ",0,0,0,0" + ",'" + "0" + "'" + ",'" + DatarowKAEI["UPD_YMDHMS"].ToString() + "'" + ",'" + DatarowKAEI["UPD_TANTOU"].ToString() + "'" + ",'" + DatarowKAEI["UPD_YMDHMS"].ToString() + "'" + ",'" + DatarowKAEI["UPD_TANTOU"].ToString() + "'" + ",'" + UpdYmdhms+"')");


skyConnect1.SqlExecute("update FSPTB_POINT set NOW_POINT=" + NowPoint.ToString() + ",RUIKEI_POINT=" + RuikeiPoint.ToString() + ",OUT_RUIKEI_POINT=" + OutruikeiPoint.ToString() + ",ADD_RUIKEI_POINR=" + AddruikeiPoint.ToString() + ",TUKI_KAIAGE_M=" + TukikaiageM.ToString() + ",SYSTEM_UPD_YMDHMS='" + UpdYmdhms.ToString() + "',BEFORE_TUKI_KAIAGE_M=" + DatarowKAEI["YDAY_TUKI_KAIAGE_M"].ToString() + ",UPD_YMDHMS=" +"'" +DatarowKAEI["UPD_YMDHMS"].ToString() + "',UPD_TANTOU='" + DatarowKAEI["UPD_TANTOU"].ToString() + "'where MEMBER_CODE=" + "'" + DatarowKAEI["MENBER_CODE"].ToString() + "'");

好长阿~~

对不对,放的环境里跟踪一下就OK了

就怕少打一个"'"或者","  是字符类型的怕少打一个"'"  是浮点类型的又怕多打一个"'" 有起他好办法写SQL语句吗 ?

虽然出去工作写的sql语句要比这长的多，但长了人看了就晕．

兄弟：告诉你一个方法，你可以设置断点，然后把值复制出来，粘贴到“查询分析器”中运行，就可以一目了然你的语句是否有错。

对于长的sql语句在程序中是不大好检查，我一直采用这种方法，很好用。

该换行的还是换一下嘛,这样你自己也不好看,别人也不想看...
还不好修改..
如果有错,可以加try..catch.. 或者设断点.

长不要紧,但是太乱了

有点乱```有点乱```