SqlParameter[]超难问题．．．．

[fanglibang]

大哥们这个我实在无法解决了．．帮帮看看　userid是一个ArraryList里面有值．．

帮帮改改．
谢谢了．

　　　　　　　int i=userid.Count;
string StrSql="delete from NoteInfo where id in(这里面的参数怎么写)";
SqlParameter[] Param=new SqlParameter[i];
for(int n=0;n<i;n++)
{
Param[n]=new SqlParameter("@param"+n,SqlDbType.Int);
Param[n].Value=nuserid[n];
}

[nadoo]

@param

?

[fanglibang]

大哥这样等吗？？
里面有很多参数啊．．．
Param[n]=new SqlParameter("@param"+n,SqlDbType.Int);
不值一个啊．

[fanglibang]

贴子是不是沉海了

[真相重于对错]

直接用拼接不就完了

[bitliuyang]

int i=userid.Count;
string Id="";
string StrSql="delete from NoteInfo where id in(@param)";
SqlParameter Param=new SqlParameter[];
for(int n=0;n<i;n++)
{
Id +=userid[n]+",";
}
Id = Id.Substring(0,Id.Length-1);
Param =new SqlParameter("@param",SqlDbType.String);
Param.Value=Id;
没测试，你看看符合不。

[fanglibang]

谢谢了．

[fanglibang]

各位有没有好办法．．上楼讲的好像行不通啊．．．

[hainang1234]

string StrSql="delete from NoteInfo where id in({0})";
string strOut = "";
foreach (object obj in param)
{
if (strOut != "")
{
strOut += ","+obj.ToString();
}
else
{
strOut += obj.ToString();
}
}
StrSql = string.Format(StrSql,strOut);

[xxuu503]

int i=userid.Count;
string StrSql="delete from NoteInfo where id in(" SqlParameter[] Param=new SqlParameter[i];
for(int n=0;n<i;n++)
{
Param[n]=new SqlParameter("@param"+n,SqlDbType.Int);
Param[n].Value=nuserid[n];
if(n==0)
{
strsql = strsql & "@param" & n;
}
else
{
strsql = strsql & "," & "@param" & n; }
}
strsql= strsql & ")"


自己更改大小写！

[xxuu503]

int i=userid.Count;
string StrSql="delete from NoteInfo where id in("
SqlParameter[] Param=new SqlParameter[i];
for(int n=0;n<i;n++)
{
Param[n]=new SqlParameter("@param"+n,SqlDbType.Int);
Param[n].Value=nuserid[n];
if(n==0)
{
strsql = strsql & "@param" & n;
}
else
{
strsql = strsql & "," & "@param" & n;
}
}


自己更改大小写！

[qu882618520]

补加一点：
int i=userid.Count;
string StrSql="delete from NoteInfo where id in(";
SqlParameter[] Param=new SqlParameter[i];
for(int n=0;n<i;n++)
{
Param[n]=new SqlParameter("@param"+n,SqlDbType.Int);
Param[n].Value=nuserid[n];
if(n==0)
{
strsql = strsql & "@param" & n;
}
else
{
strsql = strsql & "," & "@param" & n;
}

}
strsql =strsql +")";