C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Diagnostics;


namespace StopWatch
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        // new instance of Stop Watch
        Stopwatch StopWatch = new Stopwatch();
        
        private void lblClock_Click(object sender, EventArgs e)
        {

        }

        private void btnStart_Click(object sender, EventArgs e)
        {
            // Button Start Checking if already started
            if (timer1.Enabled)
            {
                MessageBox.Show("Sorry you have already started the Timer");
            }

            else
                 timer1.Start();
                 this.StopWatch.Start();
        }

        private void btnStop_Click(object sender, EventArgs e)
        {
            // Button Stop Checking if already Stopped
            if (timer1.Enabled)
            {
                timer1.Stop();
                StopWatch.Stop();
            }
            else
                MessageBox.Show("Timer Already Stopped");
        }

        private void btnPause_Click(object sender, EventArgs e)
        {
            // button reset
            StopWatch.Reset();
            lblClock.Text = "00 HR :00 MIN :00 SEC ";
        }

        private void timer1_Tick(object sender, EventArgs e)
        {

            // Timer by hr min sec
             TimeSpan elapsed = this.StopWatch.Elapsed;
             lblClock.Text = string.Format("{0:00} HR :{1:00} MIN: {2:00} SEC", Math.Floor(elapsed.TotalHours), elapsed.Minutes, elapsed.Seconds);
 
        }
    }
}


Class1.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Diagnostics;

namespace StopWatch.BL
{
    public class Time 
    {
        Stopwatch stopwatch = new Stopwatch();

        public TimeSpan Elapsed // class elapsed
        {
            get { return stopwatch.Elapsed; }
        }

        public bool IsRunning // class is running
        {
            get { return stopwatch.IsRunning; }
        }


        public void Start() // start stop watch
        {
           DateTime start = DateTime.Now;
           TimeSpan duration = DateTime.Now - start;
        }

        public void Stop() // stop the stop watch
        {
            
            stopwatch.Stop();
        }

        public void Reset() // reset the stop watch
        {
            stopwatch.Reset();
        }

    }
}

hi all
 
I have a search button and datagrid in c#, I require perform a query in the database and load the data in me datagrid
 
it is my code

conexion.ConnectionString = @"Data Source = SHINIL-PC040\SQLEXPRESS; Initial Catalog = produccion; Integrated Security = True";  
            if(TXTORDEN_PRODUCCION.Text == "" || TXTTURNO.Text == "" || TXTMAQUINAS.Text == "" || TXTHORAINICIO.Text == "" || TXTHORAFIN.Text == "")  
            {  
                MessageBox.Show("Te falta campo");  
            }  
            else  
            {  
                 
                if (checkBox1.Checked == true)  
                {  
                    try  
                    {  
  
                        comando.Connection = conexion;  
                        conexion.Open();  
                        string SqlAction = "select orden, turno, operador, horainicio, horafin, articulo, totalpiezasok, totalcajas, piezascondefecto, maquina from conteo2 where CONVERT(varchar(10), horafin, 108) >= @horainicio and CONVERT(varchar(10), horafin, 108)<= @horafin and orden = @orden  and turno = @turno and maquina = @maquina ";  
                        // "SELECT MOLDE, PROYECTO, ITEMPARTE, COLOR, SNP FROM PARTE WHERE ITEMPARTE = @ITEMPARTE";  
                        SqlCommand cmd = new SqlCommand(SqlAction, conexion);  
                        cmd.Parameters.AddWithValue("@orden", TXTORDEN_PRODUCCION.Text);  
                        cmd.Parameters.AddWithValue("@turno", TXTTURNO.Text);  
                        cmd.Parameters.AddWithValue("@maquina", TXTMAQUINAS.Text);  
                        cmd.Parameters.AddWithValue("@horainicio", TXTHORAINICIO.Text);  
                        cmd.Parameters.AddWithValue("@horafin", TXTHORAFIN.Text);  
  
                         
                        }  
  
                        conexion.Close();  
                    }  
                    
                    catch (Exception Ex)  
                    {  
                        MessageBox.Show(Ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);  
                    }  
                }  
                MessageBox.Show("selecciono ok produccion");  
                }  
                if (checkBox2.Checked == true)  
                {  
                    MessageBox.Show("selecciono paros");  
                }  
                if (checkBox1.Checked == false & checkBox2.Checked == false)  
                {  
                    MessageBox.Show("tiene que seleccionar un reporte");  
                }  
            }