C#

            string sql = @"SELECT * FROM datbase where bus_received_time_stamp between @startDate AND @endDate";

            //Making use of a Postgresql Connection helper
            NpgsqlConnection conn = new NpgsqlConnection(conns);

            //Here we format the dateTimePicker dates to be used with the database
            string fromDate = dtStartDate.Text;
            string toDate = dtEndDate.Text;

            //Instanciate a SqlCommand and connect to the DB and fill a Dataset
            NpgsqlCommand cmd = new NpgsqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = sql;
            cmd.Parameters.AddWithValue("@startDate", fromDate + " 00:00:01");
            cmd.Parameters.AddWithValue("@endDate", toDate + " 23:59:59");

            #endregion

            conversionRate = txtConversionRate.Text;
            double conRate = Convert.ToDouble(conversionRate);

            try
            {
                //Open the DB Connection
                conn.Open();
                setText(this, "Connection Established");
                NpgsqlDataAdapter da = new NpgsqlDataAdapter(cmd);
                setText(this, "Collecting Data for Processing!");
                da.Fill(dts);
//Time between the two "setText statements takes a good 4 to 5 minutes
                setText(this, "Define Data To be Used");

namespace joaninne
{
    public partial class Form1 : Form
    {

        //static bool _continue;
        static SerialPort _SerialPort1;
        byte[] buffer;
        FileStream file;


        public Form1()
        {
            InitializeComponent();

            file = File.Open(@"D:\speechtestfiles.wav", FileMode.Create);
            //buffer = new byte[60 * 1024];
            //Create a new modem port instance with the required settings
            _SerialPort1 = new SerialPort("COM31", 9600, Parity.None, 8, StopBits.One);
            _SerialPort1.DtrEnable = true;
            _SerialPort1.RtsEnable = true;
 
            _SerialPort1.ReadTimeout = SerialPort.InfiniteTimeout;

           
              
          
            //open the serial port
            _SerialPort1.Open();

           // _SerialPort1.Write("AT\r");          

           // Thread.Sleep(1000);

            _SerialPort1.Write("ATS0=1\r");
            buffer = new byte[100 * 1024];
            _SerialPort1.DataReceived += new SerialDataReceivedEventHandler(sp_DataReceived);
            Thread.Sleep(1000);
              
         
            //close the modem port
             _SerialPort1.Close();
            file.Close();
            file.Dispose();
            
            // Create a SpeechRecognitionEngine object for the default recognizer in the en-US locale since we have chosen
            // american english as our language 
            using (SpeechRecognitionEngine recognizer = new SpeechRecognitionEngine(new CultureInfo("en-US")))
            {

                // Create a grammar.
                Choices appliances = new Choices(new string[] { "fan", "lights" });
                Choices Commands = new Choices(new string[] { "on", "off" });

                GrammarBuilder gb = new GrammarBuilder();
                gb.Append("Please turn the");
                gb.Append(appliances);
                gb.Append(Commands);

                // Create a Grammar object and load it to the recognizer.
                Grammar g = new Grammar(gb);
                recognizer.LoadGrammarAsync(g);

                // Attach event handlers.
                recognizer.SpeechRecognized += new EventHandler<SpeechRecognizedEventArgs>(recognizer_SpeechRecognized);
                recognizer.SpeechRecognitionRejected +=
                new EventHandler<SpeechRecognitionRejectedEventArgs>(recognizer_SpeechRecognitionRejected);

                var isReady = false;
                while (!isReady)
                {
                    isReady = IsFileReady(@"D:\speechtestfiles.wav");
                }
                    // Set the input to the recognizer i.e to the audio file that was stored
                    recognizer.SetInputToWaveFile(@"D:\speechtestfiles.wav");



                    // Start asynchronous, continuous recognition.
                    recognizer.RecognizeAsync(RecognizeMode.Multiple);

                
                    // Keep the console window open.
                   // Console.ReadLine();
              
               
            }
            //close the port
            //_SerialPort1.Close();
        }

        private void sp_DataReceived(object Sender, SerialDataReceivedEventArgs e)
        {
          
           
            int x = _SerialPort1.BytesToRead;
            _SerialPort1.Read(buffer, 0, x);
            file.Write(buffer, 0, x);
           
        }

        public static bool IsFileReady(String file)
        {
            //if the file can be opened for exclusive access, it means the file is nolonger locked by another process
            try
            {
                using (FileStream inputStream=File.Open(file,FileMode.Open,FileAccess.Read,FileShare.None))
                {
                    if (inputStream.Length>0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
            }
            catch (Exception)
            {
                return false;
            }
        }

        // Handle the SpeechRecognitionRejected event.
        public static void recognizer_SpeechRecognitionRejected(object sender, SpeechRecognitionRejectedEventArgs e)
        {
            foreach (RecognizedPhrase phrase in e.Result.Alternates)
            {
                Console.WriteLine("  Rejected phrase: " + phrase.Text);

            }
        }

        // Handle the SpeechRecognized event.
        public static void recognizer_SpeechRecognized(object sender, SpeechRecognizedEventArgs e)
        {
            string _detected = (e.Result.Text);

            //shows the list of possible phrases
            string _recognised1 = " Please turn the lights on";
            //string _recognised2 = " Please turn the fan on";
            //string _recognised3 = " Please turn the lights off";
            //string _recognised4 = " Please turn the fan off";

            //sends the "turn the light on" command to the appliances
            if (String.Compare(_recognised1, _detected) == 0)
            {
                //string fileLightsOn = @"D:\\wep\WAVE\Lights on.wav";

                PortAccess.Output(888, 1);

                //also sends the confirmation command to the user


            }
            else
            {
                //send voice message to user notifying them that an invalid command was sent


            }
        }
    }

}