C#的SqlCommand错误 [英] c# Sqlcommand error
本文介绍了C#的SqlCommand错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
foreach (string str in TestWords)
{
//spam
SqlCommand cmd6 = new SqlCommand("select count from keys,files,folders where keys.fileid=files.id and keys.kname='" + str + "' and files.spam=1 and folders.id<>" + FolIter + " and files.folderid<>" + FolIter + " and files.id='" + s[0].ToString + "'", cn);
int i6 = Convert.ToInt16(cmd6.ExecuteScalar());
double temp = Convert.ToDouble((i6 + 1) / (i7 + i8));
//non spam
**error**
SqlCommand cmd9 = new SqlCommand("select count from keys,files,folders where keys.fileid=files.id and keys.kname='"
+ str
+ "' and files.spam=0 and folders.id<>"
+ FolIter
+ " and files.folderid<>"
+ FolIter
+ " and files.id='"
+ s[0].ToString
+ "'", cn);
int i9 = Convert.ToInt16(cmd9.ExecuteScalar());
temp2 = Convert.ToDouble((i9 + 1) / (i7 + i8));
Sdoc = Convert.ToDouble(Sdoc * temp);
NsDoc = Convert.ToDouble(NsDoc * temp2);
}
错误IAM越来越是:运算符'+'不能应用于类型为串和方法组
推荐答案
您正使用方法的ToString()
为地产
变更 S [0]的ToString
- > S [0]的ToString()
记住C#不允许这样做。
Remember C# does not allow it.
这篇关于C#的SqlCommand错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文