ArrayListArrayListArrayList

来源：互联网发布：手机淘宝抢购怎么刷新编辑：程序博客网时间：2024/05/18 06:39

原来为

public bool ExecQuery(string stringSelect,ArrayList ArrayListResult)
  {
   bool bSuccessed = true;
   try
   {
    ArrayListResult.Clear();
    DataSet DataSetInfo = new DataSet();
    if(!ExecQueryDataSet(stringSelect,DataSetInfo,"ExecQuery"))
    {
     throw new Exception();
    }
    foreach(DataTable DataTableInfo in DataSetInfo.Tables)
    {
     foreach(DataRow DataRowInfo in DataTableInfo.Rows)
     {
      ArrayList ArrayListRowInfo = new ArrayList();
      foreach(DataColumn DataColumnInfo in DataTableInfo.Columns)
      {
       ArrayListRowInfo.Add(DataRowInfo[DataColumnInfo]);
      }
      ArrayListResult.Add(ArrayListRowInfo);
     }
    }
   }
   catch(Exception /*ex*/)
   {
    bSuccessed = false;
   }
   finally
   {
    CloseConnection();
   }
   return bSuccessed;
  }

修改后没什么大的改动

    foreach(DataRow DataRowInfo in DataSetInfo.Tables[0].Rows)
    {
     ArrayList ArrayListRowInfo = new ArrayList();
     foreach(DataColumn DataColumnInfo in DataTableInfo.Columns)
     {
      ArrayListRowInfo.Add(DataRowInfo[DataColumnInfo]);
     }
     ArrayListResult.Add(ArrayListRowInfo);
    }

   }
   catch(Exception /*ex*/)
   {
    bSuccessed = false;
   }
   finally
   {
    CloseConnection();
   }
   return bSuccessed;
  }