private void frmPartNumberList_Load(object sender, EventArgs e)
        {
            PartnumberCollection pnc = new PartnumberCollection();
            DataTable            dt  = pnc.GeneratePartNumberCollection();

            //dt.Columns.Add("Filename");
            //dt.Columns.Add("Tuner");
            //dt.Columns.Add("Stage");
            //dt.Columns.Add("Info");

            LoadPartNumbersFromFiles();

            /*foreach (DataRow dr in dt.Rows)
             * {
             *  foreach (DataRow pdr in partnumbers.Rows)
             *  {
             *      if(dr["Partnumber"] != DBNull.Value && pdr["PARTNUMBER"] != DBNull.Value)
             *      {
             *          if (dr["Partnumber"].ToString() == pdr["PARTNUMBER"].ToString())
             *          {
             *              dr["Filename"] = pdr["FILENAME"];
             *              dr["Tuner"] = pdr["TUNER"];
             *              dr["Stage"] = pdr["STAGE"];
             *              dr["Info"] = pdr["INFO"];
             *          }
             *      }
             *  }
             * }*/


            gridControl1.DataSource = dt;
            gridView1.Columns["Carmodel"].Group();
            gridView1.Columns["Enginetype"].Group();
            gridView1.BestFitColumns();
        }
        private void frmPartNumberList_Load(object sender, EventArgs e)
        {
            PartnumberCollection pnc = new PartnumberCollection();
            DataTable dt = pnc.GeneratePartNumberCollection();
            //dt.Columns.Add("Filename");
            //dt.Columns.Add("Tuner");
            //dt.Columns.Add("Stage");
            //dt.Columns.Add("Info");

            LoadPartNumbersFromFiles();

            /*foreach (DataRow dr in dt.Rows)
            {
                foreach (DataRow pdr in partnumbers.Rows)
                {
                    if(dr["Partnumber"] != DBNull.Value && pdr["PARTNUMBER"] != DBNull.Value)
                    {
                        if (dr["Partnumber"].ToString() == pdr["PARTNUMBER"].ToString())
                        {
                            dr["Filename"] = pdr["FILENAME"];
                            dr["Tuner"] = pdr["TUNER"];
                            dr["Stage"] = pdr["STAGE"];
                            dr["Info"] = pdr["INFO"];
                        }
                    }
                }
            }*/

            gridControl1.DataSource = dt;
            gridView1.Columns["Carmodel"].Group();
            gridView1.Columns["Enginetype"].Group();
            gridView1.BestFitColumns();
        }