//把的DataTable中某列转换成数组
private int[] Get_DT_Arr(DataTable myDT,int LieNum)
{
string[] aa = new string[myDT.Rows.Count];
for (int i = 0; i < myDT.Rows.Count; i++)
{
aa[i] =myDT.Rows[i][LieNum].Tostring();
}
return aa;
}
private int[] Get_DT_Arr(DataTable myDT,int LieNum)
{
string[] aa = new string[myDT.Rows.Count];
for (int i = 0; i < myDT.Rows.Count; i++)
{
aa[i] =myDT.Rows[i][LieNum].Tostring();
}
return aa;
}
DataTable dt = bus.GetDeptInfo();
for(int i = 0; i < dt.Rows.Count;i++){
dt.Add(dt.Rows[i]["DeptID "].ToString());
}
DeptID IN {'0','CM'}.
DataTable dt = bus.GetDeptInfo(); StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append( "'" + dt.Rows[i]["DeptID"].ToString() + "',");
}
但结果是{'0','CM',}
string []list;//存储DeptID
StringBuilder condition=new StringBuilder();//条件
condition.Append("{");
for(int i=0;i<dt.Rows.count;i++)
{
list[i]=dr["DeptID "].ToString();
condition.Append("'");
condition.Append(list[i]);
condition.Append("'");
if(i!=dt.Row.count-1)
{
condition.Append(",");
}
}
condition.Append("}");//拼凑出你的查询条件 {'0','CM'} 只需和你的sql语句拼接上就行了
string []list;//存储DeptID
StringBuilder condition=new StringBuilder();//条件
condition.Append("(");
for(int i=0;i <dt.Rows.count;i++)
{
list[i]=dr["DeptID "].ToString();
condition.Append("'");
condition.Append(list[i]);
condition.Append("'");
if(i!=dt.Row.count-1)
{
condition.Append(",");
}
}
condition.Append(")");//拼凑出你的查询条件 ('0','CM') 只需和你的sql语句拼接上就行了