检索Table的某一字段是否存在某个条件的数据

DataSet datawarehouse

DataRow[] mat;

 

if (DaWaitWork.Tables[0].Rows.Count > 0)
{
    mat = DaWaitWork.Tables[0].Select("(SWMunitid='" + strWID + "')");

    if (mat.Length > 0)

   {

           if ((mat[0]["SWMunitid"].ToString().Trim() != null) && (mat[0]["SWMunitid"].ToString().Trim().Length > 0))
           {
                dgv.Rows[i].Cells[k].Style.BackColor = WaitWorkStyleBackColor;
            }

   }
}

 

if (datawarehouse.Tables[2].Rows.Count > 0)
{
   mat = datawarehouse.Tables[2].Select(" ( ckbmid='" + StrWMID.Substring(0, 2) + "') and  (ChannelsID='" +      StrWMID.Substring(2, 2) + "') and  (WHlistNo ='" + StrWMID.Substring(4, 2) + "') and (LayerNo='" + dgv.Rows[i].Cells[0].Value.ToString().Trim() + "') and (ColumnNo='" + dgv.Columns[k].HeaderText.Trim() + "') and (DqkclPercent<" + MyClass.UseRatio + " )");

    if (mat.Length > 0)

{
   if ((mat[0]["ckbmid"].ToString().Trim() != null) && (mat[0]["ckbmid"].ToString().Trim().Length > 0))
                                {
                                    dgv.Rows[i].Cells[k].Style.BackColor = WaitWorkStyleBackColor;
                                }

}
                            }