public int ADOGetArray(SqlConnection oConn,string sSQL, ArrayList sRS)
{
int nRetVal = 0;
string [] sTmpRec=null;
try
{
SqlCommand oCmd = new SqlCommand(sSQL,oConn);
SqlDataReader oReader = oCmd.ExecuteReader();
int nCols = oReader.FieldCount;
while (oReader.Read())
{
nRetVal = 1;
sTmpRec = new string[nCols];
for (int nCol=0;nCol<nCols;nCol++)
{ sTmpRec[nCol] = oReader.GetValue(nCol).ToString(); }
sRS.Add(sTmpRec);
}
oReader.Close();
}
catch (Exception e) { nRetVal = 2; Response.Write(e.Message);}
return nRetVal;
}