public static bool execSQL(string[] str,string ip)
{
SqlConnection con = zxpxDB.createcon();
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.Parameters.Add("@id", SqlDbType.Int);
com.Parameters.Add("@ip", SqlDbType.NVarChar,100);
com.Parameters.Add("@name", SqlDbType.NVarChar, 200);
try
{
com.CommandText = "pr_text";
com.CommandType=CommandType.StoredProcedure;
foreach (string s in str)
{
com.Parameters[0].Value = s;
com.Parameters[1].Value = ip;
com.Parameters[2].Value = str;
com.ExecuteNonQuery();
}
com.Dispose();
con.Close();
}
catch (Exception e)
{
con.Close();
return false;
}
return true;
}
{
SqlConnection con = zxpxDB.createcon();
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.Parameters.Add("@id", SqlDbType.Int);
com.Parameters.Add("@ip", SqlDbType.NVarChar,100);
com.Parameters.Add("@name", SqlDbType.NVarChar, 200);
try
{
com.CommandText = "pr_text";
com.CommandType=CommandType.StoredProcedure;
foreach (string s in str)
{
com.Parameters[0].Value = s;
com.Parameters[1].Value = ip;
com.Parameters[2].Value = str;
com.ExecuteNonQuery();
}
com.Dispose();
con.Close();
}
catch (Exception e)
{
con.Close();
return false;
}
return true;
}
你给的参数是字符串
com.Parameters[2].Value这个返回的是string 而str是数组 一个是原始数据类型 一个基本数据类型 肯定错啊
for(int i=0;i<str.lengthli++)
{
xxx=str[i];
}
com.Parameters[2].Value = str[下标];
foreach (string s in str)
{
com.Parameters[0].Value = s;
com.Parameters[1].Value = ip;
com.Parameters[2].Value = str;
com.ExecuteNonQuery();
}
改为
string strAll = "";
foreach (string s in str)
{
strAll += s;
}
foreach (string s in str)
{
com.Parameters[0].Value = s;
com.Parameters[1].Value = ip;
com.Parameters[2].Value = strAll;
com.ExecuteNonQuery();
}
改为:
com.Parameters[2].Value = str.Aggregate((a,b)=>a+b);