C#

electriac wrote:

listBox1.Items.Add(f);

private void button1_Click(object sender, System.EventArgs e)
{
  DirSearch(@"c:\");
  MessageBox.Show(icount.ToString());
}

private ArrayList arrText = new ArrayList();
private int icount = 0;
private void DirSearch(string dir)
{
  if (++icount >= 19000)
    return;
  foreach (string d in Directory.GetDirectories(dir))
  {
    foreach (string f in Directory.GetFiles(d, "*.*"))
    {
      listBox1.Items.Add(f);
      arrText.Add(f);
      if (++icount >= 19000)
        return;
    }
    DirSearch(d);
  }
}

<br />
void DirSearch(string sDir)<br />
        {<br />
            try<br />
            {<br />
                foreach (string d in Directory.GetDirectories(sDir))<br />
                {<br />
                    foreach (string f in Directory.GetFiles(d, "*.mp3"))<br />
                    {<br />
                        //listBox1.Items.Add(f);<br />
                        arrText.Add(f);<br />
                        countFiles++;<br />
                    }<br />
                    DirSearch(d);<br />
                }<br />
            }<br />
            catch (System.Exception excpt)<br />
            {<br />
                Console.WriteLine(excpt.Message);<br />
            }<br />
        }<br />

Red_Wizard_Shot_The_Food wrote:

I want to assign the results of an SQL ExecuteScalar to an int. Which is fine when the ExecuteScalar returns a value (i.e the paramater sent to the stored procedure caused the SELECT function to find a valid record).
BUT if the paramater does not pass the SELECT procedure a value that is already in the table the assignment to an int causes an exception (as no record was returned).
Can i do this without using a try/catch block?

Sarafian wrote:

you can't do it without using try catch or an if statement which in this case is the same.

Sarafian wrote:

assuming your id in base are not zero-valued i have implemented a function that executed the command and return zero if not found or the desired value.