C#

YearReg                 RegNo
  1950                    112
  1950                    102
  1951                    110
  1950                    114

string strQ = @"SELECT COUNT(RegNo) FROM tblRcvLet WHERE YearReg=@s1"
OleDbDataAdapter oda_Edited = new OleDbDataAdapter(strQ, ocn);
oda_Edited.SelectCommand.Parameters.Clear();
oda_Edited.SelectCommand.Parameters.AddWithValue("  @s1", txtYearReg.Text);
DataTable dt_Edited = new DataTable();
dt_Edited.Clear();
oda_Edited.Fill(dt_Edited);
if (dt_Edited.Rows.Count > 0)
   {
      MessageBox.Show("Already Exists!! ");
      txtRegNo.Focus();
    }
   else
   {
   OleDbCommand ocmd_Edited02 = new OleDbCommand();
    ocmd_Edited02.CommandText = @"UPDATE ....

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();
}