62,046
社区成员
发帖
与我相关
我的任务
分享
private string[] GetBM(string OraWhere)
{
DataRow[] foundRows;
//ora_tb是一张DATATABLE表
foundRows = ora_tb.Select(OraWhere, "USERNAME");
int i = 0;
string[] str = new string[Convert.ToInt32(foundRows.Length)];
foreach (DataRow dt in foundRows)
{
if (string.IsNullOrEmpty(dt["NAME1"].ToString())==string.IsNullOrEmpty(dt["NAME2"].ToString() & dt["NAME1"].ToString())!=dt["NAME2"].ToString()))
{
str[i] = dt["NAME2"].ToString();
i++;
}
}
return str;
}
select name2 from table1 where name1<>name2