且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

删除Excel工作表数据

更新时间:2023-12-05 19:17:40

SET Geo = NULL WHERE Geo not NULL"; cmd.ExecuteNonQuery(); cmd.CommandText = "
SET Geo = NULL WHERE Geo IS NOT NULL"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE [Sheet3


SET Area = NULL WHERE Area IS NOT NULL" ; cmd.ExecuteNonQuery(); cmd.CommandText = "
SET Area = NULL WHERE Area IS NOT NULL"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE [Sheet3


SET Region = NULL WHERE Region IS NOT NULL" ; cmd.ExecuteNonQuery(); cmd.CommandText = "
SET Region = NULL WHERE Region IS NOT NULL"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE [Sheet3