110,533
社区成员
发帖
与我相关
我的任务
分享
int i = 1;
foreach (DataRow dr in dt.Rows)
{
gkxx = new Proj_cfxfgkxx();
gkxx.lxdh = dr["联系电话"].ToString();
}
List<string> temp_list = dt.AsEnumerable().Select(a => a.Field<string>("lxdh")).ToList();
bool flag=dt.Select("lxdh='" + gkss.lxdh+"'").Count()>0;
foreach (DataRow dr in dt.Rows)
{
gkxx = new Proj_cfxfgkxx();
//填加到List里
gkxx.lxdh.Add(dr["联系电话"].ToString());
}
//转成string加","
string s = string.Join("','",gkxx.lxdh.ToArray());
//写你的SQL
select * from ---- where lxdh in ('" + s + "')"
判断就行了。