C#

private int deadlineCount(DateTime Time, int LeagueID)
        {
            int total = 0;
            string league;
            if (LeagueID == 99)
            {
                league = "";
            }
            else
            {
                league = LeagueID.ToString();
            }



            BS.Filter = string.Format("LeagueID >= '{0}' and LeagueID <= '{0}'and [End] <#12/30/1899 {1}#", league, Time.ToString("h:mm tt"));
            total = BS.Count;
            BS.Filter = "";
            
            return total;
        
        }

private void CalPrice()
       {
           double price = 0.0;
           foreach (DataGridViewRow dgw in dataGridProduct.Rows)
           {
               DataGridViewCheckBoxCell datacell = dgw.Cells[0] as DataGridViewCheckBoxCell;

               try
               {
                   if ((bool)datacell.Value == true)
                   {
                       //MessageBox.Show("" + dgw.ToString());

                       price += Convert.ToDouble(dgw.Cells[6].Value.ToString());

                   }
                   lblTotalPrice.Text = "Total Price : $ " + price;
               }

               catch (Exception exc)
               {
               }
           }
       private void timer1_Tick(object sender, EventArgs e)
       {
           CalPrice();
       }
       }