C#

try
            {
                SQLiteConnection conn = new SQLiteConnection(Constants.ConnectionString);
                if (conn.State == ConnectionState.Closed)
                    conn.Open(); 

                string CommandText = "SELECT symbol FROM master;";
                SQLiteDataAdapter  dataAdapter = new SQLiteDataAdapter(CommandText, conn); 
                 
                DataTable dt = new DataTable();
                dataAdapter.Fill(dt);
                DataTable symdt = new DataTable(); 

                IMovingAverage ma20 = new SimpleMovingAverage(20);
                IMovingAverage ma50 = new SimpleMovingAverage(50);
                IMovingAverage ma200 = new SimpleMovingAverage(200); 

                //Sequencially process each symbol in the database.

                foreach (DataRow r in dt.Rows)
                {   
                    //Now get data associated with each symbol and process              
      
                    CommandText = "SELECT * FROM " + r["Symbol"].ToString() + ";";
                    SQLiteDataAdapter symdataAdapter = new SQLiteDataAdapter(CommandText, conn);
                    
                    symdataAdapter.Fill(symdt);
                    int count = 0;

                    //Sequencially process each row in the symbol table.

                    foreach (DataRow symr in symdt.Rows)
                    {  
                        //20 Period Simple Moving Average  
                        if (symdt.Rows.Count >= 20)
                        { 
                            ma20.AddSample(Convert.ToSingle(symdt.Rows[count]["Close"]));
                            symdt.Rows[count]["MA20"] = ma20.Average;  
                        }
                        //50 Period Simple Moving Average 
                        if (symdt.Rows.Count >= 50)
                        { 
                            ma50.AddSample(Convert.ToSingle(symdt.Rows[count]["Close"]));
                            symdt.Rows[count]["MA50"] = ma50.Average; 
                             
                        }
                        //200 Period Simple Moving Average 
                        if (symdt.Rows.Count >= 200)
                        { 
                            ma200.AddSample(Convert.ToSingle(symdt.Rows[count]["Close"]));
                            symdt.Rows[count]["MA200"] = ma200.Average; 
                        } 
                        ++count;
                    }
                   
                    SQLiteCommandBuilder mySqlCommandBuilder = new SQLiteCommandBuilder(symdataAdapter);
                    symdataAdapter.Update(symdt);
                    
                    symdt.Clear();
                    symdataAdapter.Dispose();

                    //Clear circular buffers
                    ma20.ClearSamples();
                    ma200.ClearSamples();
                    ma50.ClearSamples(); 
                }
                dt.Clear();
                dataAdapter.Dispose();
                
                conn.Close();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }