@好处多多
1.文件路径
strFileFrom="\\172.16.20.12\e$\CCL_Development\ProExcelTest\Engg_Index_DFS\Report"
这种形式的在C#中会报错.
解决方法:
strFileFrom="\\\\172.16.20.12\\\e$\\\CCL_Development\\\ProExcelTest\\\Engg_Index_DFS\\\Report"
strFileFrom=@"\\172.16.20.12\e$\CCL_Development\ProExcelTest\Engg_Index_DFS\Report"
2.程序中写SQL语句
一般方法:
string strSQL = "SELECT id,title,note,stime FROM tabnews ";
strSQL += "WHERE title like '%abc%' ";
修改后:
string strSQL = @"SELECT id,title,note,stime FROM tabnews
WHERE title like '%abc%' ";