C#

Luc Pattyn wrote:

if they have to return everything at once, get it in a real collection (say a List) rather than an
array, so we can operate on them (mostly remove some!).

DirectoryInfo dir = new DirectoryInfo(@"C:\DATABASES\");<br />
    <br />
    FileInfo[] files = dir.GetFiles();<br />
 <br />
    foreach (FileInfo file in files)<br />
    {<br />
      <br />
        if (file.Extension != ".mdf" && file.Extension != ".ldf")<br />
        {<br />
       <br />
                cmbrestore.Items.Add(Convert.ToString(file.Name));<br />
        }<br />
     }

private static void RemoveDuplicateItems(DropDownList ddl)
{

    for (int i = 0; i < ddl.Items.Count; i++)
    {
        ddl.SelectedIndex = i;
        string str = ddl.SelectedItem.ToString();
        for (int counter = i + 1; counter < ddl.Items.Count; counter++)
        {
            ddl.SelectedIndex = counter;
            string compareStr = ddl.SelectedItem.ToString();
            if (str == compareStr)
            {
                ddl.Items.RemoveAt(counter);
                counter = counter - 1;
            }
        }
    }
}

rpt.datasource=datatable

rpt.SetDataSource(datatable)

int iColumnCount = aListOfArrays[0].length;

for(int iCurColumn = 0; iCurColumn < iColumnCount; iCurColumn++) {
   for(int iCurArray = 0; iCurArray < aListOfArrays.Count; iCurArray++) {
     System.out.print(" " + aListOfArrays[iCurArray][iCurColumn].ToString());
   }
  System.out.println();
}