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.

private void Form1_Load(object sender, EventArgs e)
       {
           readThread = new Thread(new ThreadStart(Read));
           port = new SerialPort();

           port.BaudRate = 921600;
           port.PortName = "COM16";
           port.Parity = Parity.None;
           port.DataBits = 8;
           port.StopBits = StopBits.One;
           port.ReadTimeout = 30000;
           port.WriteTimeout = 30000;
         //  port.Handshake = Handshake.XOnXOff;
           port.DtrEnable = true;
           port.RtsEnable = true;
              port.DataReceived += new SerialDataReceivedEventHandler(port_DataReceived);
           port.Open();


       }

       private void buttonSend_Click(object sender, EventArgs e)
       {
           port.Write("AT+CUSD=1,\"*140*1#\",15" + System.Environment.NewLine);

       }


       private void port_DataReceived(object sender, SerialDataReceivedEventArgs e)
       {


               SerialPort spL = (SerialPort)sender;
               byte[] buf = new byte[spL.BytesToRead];
               spL.Read(buf, 0, buf.Length);
               foreach (Byte b in buf)
               {
                   message += b.ToString();
               }
               textBoxSMS.BeginInvoke((MethodInvoker)delegate()
               {
                   textBoxSMS.Text += Encoding.ASCII.GetString(buf);
               });

       }