M_id, M_name两个字段数据相同的DataRow必须是连续的,不能被分隔
string sql = string.Format("select M_id, M_name from dbo.BusinessWaitTable order by M_id, M_name");
DataTable dt = GetDataTable(sql);
//得出datatable中所有行放入数组
DataRow[] drs = dt.Select();
//存放过滤后DataRow的可变长度数组
ArrayList al = new ArrayList();
//源数组不为空,开始过滤
if (drs.Length != 0)
{
//先加入源数组第一个元素
al.Add(drs[0]);
/*遍历源数组元素,
* 将与目标数组最后一个元素不同的源数组元素加入到目标数组*/
for (int i = 0; i < drs.Length; i++)
{
if (drs[i]["M_id"].ToString() != ((DataRow)al[al.Count - 1])["M_id"].ToString()
&& drs[i]["M_name"].ToString() != ((DataRow)al[al.Count - 1])["M_name"].ToString())
{
al.Add(drs[i]);
}
}
}