C#

Mycroft Holmes wrote:

You would need to trap the start and end events of the application part of the database,

jschell wrote:

Presumably you mean in the C# application

Sub ReturnUserRoster()
Dim cnn As New ADODB.Connection
Dim rst As ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=C:\Program Files\Microsoft " & _
    "Office\Office\Samples\Northwind.mdb;"
Set rst = cnn.OpenSchema(adSchemaProviderSpecific _
    ,   , JET_SCHEMA_USERROSTER)
Debug.Print rst.GetString
Set rst = Nothing
Set cnn = Nothing
End Sub

//Declarations required for audio out and the MP3 stream
IWavePlayer waveOutDevice;

WaveStream mainOutputStream;
WaveChannel32 volumeStream;

string fName = @"song.mp3";

private void Form1_Load(object sender, EventArgs e)
{
    try
    {

        waveOutDevice = new WaveOut();
        
       
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }
}
		
private void btnPlay_Click(object sender, EventArgs e)
{
    try
    {
        if (waveOutDevice.PlaybackState.ToString() == "Playing")
        {
            return;
        }
        
        mainOutputStream = CreateInputStream(fName);
        waveOutDevice.Init(mainOutputStream);
        waveOutDevice.PlaybackStopped += new EventHandler<StoppedEventArgs>(waveOutDevice_PlaybackStopped);
        waveOutDevice.Play();

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }

}

private void waveOutDevice_PlaybackStopped(object sender, EventArgs e)
{
    try
    {
       
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }
}
		
private void btnStop_Click(object sender, EventArgs e)
{
    try
    {
        if (waveOutDevice != null)
        {
            waveOutDevice.Stop();
        }
        if (mainOutputStream != null)
        {
            // this one really closes the file and ACM conversion
            volumeStream.Close();

            // this one does the metering stream
            mainOutputStream.Close();
        }
        if (timerPosition.Enabled)
        {
            timerPosition.Enabled = false;
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }
}

private WaveStream CreateInputStream(string fileName)
{
    try
    {
        WaveChannel32 inputStream;
        if (fileName.EndsWith(".mp3"))
        {
            WaveStream mp3Reader = new Mp3FileReader(fileName);
            inputStream = new WaveChannel32(mp3Reader);

        }
        else
        {
            throw new InvalidOperationException("Unsupported extension");
        }
        volumeStream = inputStream;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }
    return volumeStream;
}
private void CloseWaveOut()
{
    try
    {
        if (waveOutDevice != null)
        {
            waveOutDevice.Stop();
        }
        if (mainOutputStream != null)
        {
            // this one really closes the file and ACM conversion
            volumeStream.Close();
            volumeStream = null;

            // this one does the metering stream
            mainOutputStream.Close();
            mainOutputStream = null;
        }
        if (waveOutDevice != null)
        {
            waveOutDevice.Dispose();
            waveOutDevice = null;
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().ToString());
    }
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
    CloseWaveOut();
}

Vouksh wrote:

Problem with Task.WaitAll() is that it expects a fixed array (Task[]) of tasks,
whereas the array could be anything from a single task to a dozen of them, and
it's not known at run time.