How Can I read File names from a server location

Question

Hi all,
       I am trying to create a web application that will read the file names form a server location and dynamically create a link for those file to download.But i am having problem reading the file names from server location.Any suggestion will help.

Answer 1

Thanks for your quick reply. This looks like it will get me going in the right direction..Ben

Answer 2

Suppose that you have a query which is capable to select all records that meet the specified criteria. Then use the same query (or at least its WHERE clause) to select IDs. Then pick three ID values at random and that would be the output.

Roughly, the code might look like this:

SqlCommand cmd = new SqlCommand("SELECT ValueID FROM Value WHERE ... ", conn);    // Fill in the WHERE clause
List<int> ids = new List<int>();
           
using (SqlDataReader reader = cmd.ExecuteReader())
{
    while (reader.Read())
        ids.Add(reader.GetInt32(0));
}

int valuesCount = 3;
List<int> selectedIDs = new List<int>();
Random rand = new Random();

for (int i = 0; i < valuesCount; i++)
    if (ids.Count > 0)
    {
        int index = rand.Next(ids.Count);   // Random vaule 0..count-1
        selectedIDs.Add(ids[index]);
        ids.RemoveAt(index);
    }
    else
    {
        break;  // There are less than 3 values selected in total
    }

// Now select rows with specified ids

StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM Value WHERE ValueID IN (");
bool first = true;

foreach (int id in selectedIDs)
{
    if (!first)
        sb.Append(", ");
    first = false;
    sb.Append(id);
}

sb.Append(")");

cmd = new SqlCommand(sb.ToString(), conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
    while (reader.Read())
    {
        // Do whatever needed to do with randomly selected rows
    }
}

Zoran