public void search()
    {

        try
        {

            DataTable _searchResult = ddy.Select("[PRODUCT NO] LIKE '" + metroTextBox2.Text + "%'").CopyToDataTable();

            if (metroGrid2.InvokeRequired)
            {
                metroGrid2.BeginInvoke((MethodInvoker)delegate()
                {
                    metroGrid2.DataSource = _searchResult;

                    metroGrid2.Columns[0].Width = 180;
                    metroGrid2.Columns[1].Width = 300;
                    metroGrid2.Columns[1].Width = 280;
                    metroGrid2.Show();
                });

                Thread.Sleep(100);
            }
        }
        catch (Exception )
        {

        }

    }