这样有问题吗?
SqlClientCommand DBInsert;
Integer I;
String NameArrag[],ValueArray[];
NameValueCollection VisitorSV;
NameArray = VisitorSV.AllKeys;
for(i=0;i<UBound(NameArray);i++)
{
DBInsert.CommandText = "Insert Into ServerVariables " _
+ "(VisitorID, KeyName, KeyValue) values (+ Session("VisitorID") + ", " _
+ "'" + NameArray(I) + "', + Left(Replace(VisitorSV.Item(I), "'", "''"), 255) _
+ "')"
}
DBInsert.EnxuteNonQuery()
Next
DBInsert.Connection.Close();
SqlClientCommand DBInsert;
Integer I;
String NameArrag[],ValueArray[];
NameValueCollection VisitorSV;
NameArray = VisitorSV.AllKeys;
for(i=0;i<UBound(NameArray);i++)
{
DBInsert.CommandText = "Insert Into ServerVariables " _
+ "(VisitorID, KeyName, KeyValue) values (+ Session("VisitorID") + ", " _
+ "'" + NameArray(I) + "', + Left(Replace(VisitorSV.Item(I), "'", "''"), 255) _
+ "')"
}
DBInsert.EnxuteNonQuery()
Next
DBInsert.Connection.Close();
String=>string;
Next不要,}放到DBInsert.EnxuteNonQuery();后,
我不明白
NameValueCollection
VisitorSV.AllKeys
可能是你自己定义的类或其它吧?
还有C#中每个语句后都要有“;”,上面的有几处漏了,其它应该没了吧?至少我看不出有了。