sqlCmd.CommandText = "select CrawlerID,DetectID from Tools_State where type = " + type+"";
sqlCmd.CommandText = "select CrawlerID,DetectID from Tools_State where type = " + type;
type的类型是整型。
这两者是完全一样的。。当时不理解的时,只有字符串之间才可以用+号连接,其实整型也可以。
string sql = "SELECT * FROM TaskInfo WHERE State<> 'delete'";//不等号的使用
string sql = "SELECT count(*) FROM TaskInfo WHERE State='executing'";//传入字符串是的写法
string sql = "UPDATE TaskInfo SET URL='" + IParas["URL"] + "' ,Depth=" + IParas["Depth"] + " WHERE ID= " + IID + " AND State='waiting'"; //传入字符串是的写法
这些例子摘自本项目源代码。。