C#

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

private void CreateAttachments(MailMessage mailMessage, List<string> filesToAdd)
        {
            foreach (string fileToAdd in filesToAdd)
            {
                SafeFileHandle fileHandle = null;
                try
                {
                    fileHandle = Common.CreateFile(Common.prefixPath(fileToAdd), Common.GENERIC_READ, FileShare.Read, IntPtr.Zero, FileMode.Open, 0, IntPtr.Zero);
                    if (!fileHandle.IsInvalid)
                    {
                        using (FileStream fs = new FileStream(fileHandle, FileAccess.Read))
                        {
                            Attachment data = new Attachment(fs, fileToAdd);
                            mailMessage.Attachments.Add(data);
                        }
                    }
                }
                finally
                {
                    if ((fileHandle != null) || fileHandle.IsInvalid)
                        fileHandle.Dispose();
                }
            }
        }

namespace Whatever
{
    public class OuterClass
    {
        private DateTime DateTm { set; get; }

        public OuterClass()
        {
            DateTm = DateTime.Now;
        }

        public class InnerClass
        {
            public OuterClass InnerOuter { set; get; }

            public InnerClass(OuterClass outer = null)
            {
                InnerOuter = outer;
            }
        }
    }
}

using System.Collections.Generic;

namespace Whatever
{
    public class OuterClass
    {
        public List<InnerClass> AllInners { set; get; }

        public OuterClass()
        {
            AllInners = new InnerCollection();
        }
    }

    public class InnerCollection : List<InnerClass>
    {
        // functionality/usage to be defined

        public new void Add(InnerClass inner)
        {
            if (inner.MyOuter != null) inner.MyOuter.AllInners.Add(inner);
            base.Add(inner);
        }
    }

    public class InnerClass
    {
        public OuterClass MyOuter { set; get; }

        public InnerClass Parent { set; get; }

        private InnerCollection _childInners;
        public InnerCollection ChildInners
        {
            // replace with Lazy in the future ?
            // or, somehow get the lazy instantiation done in the InnerCollection Class ?
            get
            {
                if(_childInners == null) _childInners = new InnerCollection();
                return _childInners;
            }
        }

        public string Text { set; get; }

        public int Level { set; get; }

        public InnerClass(string text = "", InnerCollection inners = null, InnerClass parent = null, int level = -1)
        {
            Text = text;
            if (inners != null) _childInners = inners;
            Parent = parent;
            Level = level;
        }
    }
}

Whatever.InnerClass testInner = new WhateEver.InnerClass("test1");

// note using 'object Extension not shown here to handle 'null to 'string conversion

Console.WriteLine("inner: {0} parent: {1} tree: {2} innercollection: {3}", 
    testInner.Text, 
    testInner.Parent.NullToString(),
    testInner.MyOuter.NullToString(), 
    testInner.ChildInners.NullToString());

// console output: 
// inner: test1 parent: null tree: null innercollection: Whatever.InnerCollection