ArrayList to Array

[psrinivasan]

Iam having trouble casting ArrayList to Array of type string[]. Can anybody help !!
sResultArray = (string[])sResult.ToArray(typeof(string));[u]


Code sample is shown below:-------------------------------------------------------


static string[] GetInsDocumentsFromSource( )
{
//string[] doclist = new string[200] ;
string connectionString = "MultipleActiveResultSets=True;Data Source=cvmstgsrv1.sd.net;Integrated Security=false;Initial Catalog=SBC;User ID=cvmsa;Password=$cvmadmin$01!!";
SqlConnection conn = new SqlConnection(connectionString);

SqlCommand select_command = new SqlCommand("sp_GetDocumentsForCOI", conn);
select_command.CommandType = CommandType.StoredProcedure;

conn.Open();


SqlDataReader reader = select_command.ExecuteReader();
int cnt = 0;
int iReaderLength = reader.FieldCount;

ArrayList sResult = new ArrayList();

string[] sResultArray = new string[iReaderLength];

//loop thru data reader
while (reader.Read() && (cnt < iReaderLength))
{
string[] sRow = new String[iReaderLength];
sRow[cnt] = reader["document_name"].ToString();

cnt++;
sResult.Add(sRow);



}
sResultArray = (string[])sResult.ToArray(typeof(string));[u]




conn.Close();
return sResultArray;

}

----------------------------------------------------------------------------------

[SammyB]

LOL, you did all of the hard stuff, but you defined the array inside of the data reader loop. Just get rid of the

string[] sResultArray = new string[iReaderLength];

in the loop and at the end:

string[] sResultArray = (string[])sResult.ToArray(typeof(string));