C#

public void showRequill()
        {
            DataSet dsRequill = new DataSet();
            BindingSource bsRequill = new BindingSource();
            SqlDataAdapter daRequill = new SqlDataAdapter();
            DataTable dtRequill = new DataTable();

            int cnt = 0;

            try
            {
                daRequill.SelectCommand = new SqlCommand("select * from RD1 where UserNumber='" + cbWorkerNr.Text + "'", CN);
                daRequill.Fill(dsRequill);
                daRequill.Fill(dtRequill);
                bsRequill.DataSource = dsRequill.Tables[0];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

            foreach (DataColumn column in dtRequill.Columns)
            {
                newLabel = new Label();
                newCombo = new ComboBox();
                
                newLabel.Text = column.ColumnName;
                newLabel.AutoSize = true;
                newLabel.Visible = true;

                newCombo.Size = new Size(35, 21);
                newCombo.Items.AddRange(new object[] { "U", "S", "E", "B", "L" });
                newCombo.Name = "cbRequill_" + cnt.ToString();
                newCombo.Visible = true;
                newCombo.DataBindings.Clear();
                newCombo.DataBindings.Add(new Binding("Text", bsRequill, column.ColumnName));
                newCombo.TextChanged += new EventHandler(newCombo_TextChanged);

                flpRequill.Controls.Add(newLabel);
                flpRequill.Controls.Add(newCombo);
                cnt++;
            }
        }

public frmAdjustments()
        {
            InitializeComponent();

 line2           _data = BuildDataSet  ("AdjustmentTypes.txt","AdjustmentsTable","|");

 line3           dataGridView1.DataSource = _data;

            //dataGridView1.Refresh();

            //GetAdjustmentsTypesDb();
        }


private void button1_Click(object sender, EventArgs e)
        {
line1       frmAdjustments frmA = new frmAdjustments();
line4       frmA.ShowDialog();

        }   

        public override List<ColumnNames> GetColumnNames()
        {
            List<ColumnNames> list = base.GetColumnNames();
            list.Add(ColumnNames.filed1);
            list.Add(ColumnNames.field2);
            return list;
        }
       
        public override List<RuleError> ValidateData(DateTime receivedDate)
        {
           
            base.ValidateData(receivedDate);
            DataTable excelData = ExcelDataTable;          
            string colName = ColumnNames.field2.ToString();
            string field2ColName = colMap[colName].ToString();
            colName = ColumnNames.filed1.ToString();
            string field1ColName = colMap[colName].ToString();      

            int iEnd = excelData.Rows.Count;
            for (int i = DataRowNumber - 1; i < iEnd; i++)
            {
                //First validate all common fields from ColumnMap
                DataRow dr = excelData.Rows[i];

                          
                {
                    //Call Base class function to validate common fields
                    List<RuleError> list = Validate(dr, receivedDate, didc);
                    if (list == null)
                        list = new List<RuleError>();

                    string field1 = dr[field1ColName].ToString();
                    re = Validatefield1ible(field1);
                    if (re != null)
                    {
                        list.Add(re);
                    }

                    string colVal = dr[field2ColName].ToString();
                    re = Validatefield2(colVal);
                    if (re != null)
                    {
                        list.Add(re);
                    }
             
            }
            excelData.AcceptChanges();
            didc.Dispose();

            return masterList;
        }

        public override List<RuleError> LoadData(ImportWkbk wb, string destDocLoc)
        {
           

            string colName = ColumnNames.field2.ToString();
            string field2ColName = colMap[colName].ToString();
            colName = ColumnNames.filed1.ToString();
            string field1ColName = colMap[colName].ToString();
           
            Hashtable htSubs = new Hashtable();

            Int64 submissionID = 0;
            VCust firstCust = null;
            int iEnd = ExcelDataTable.Rows.Count;
            for (int i = DataRowNumber - 1; i < iEnd; i++)
            {
                DataRow dr = ExcelDataTable.Rows[i];
                                 try
                    {
                                        
                        string field1 = dr[field1ColName].ToString().Trim().ToUpper();
                        lis.filed1 = field1.Length > 0 ? field1 : null;
                        string field2 = dr[field2ColName].ToString().Trim().ToUpper();
                        lis.field2 = field2.Length > 0 ? field2 : null;

            didc.SubmitChanges();
            didc.Dispose();
            return null;
        }

       
                   

      
        public RuleError Validatefield1ible(string field1)
        {
            RuleError re = null;
            if (field1 == null || field1.Trim().Length < 1)
                return null;

            if (field1.Trim().ToUpper().Equals (field1ibleStatus.PART) ||
                field1.Trim().ToUpper().Equals (field1ibleStatus.aLL)
               )
            {
                return null;
            }

            re = new RuleError(RuleErrorCodes.OTHER, RuleErrorTypes.ERROR, "error 1");
            return re;
        }

       
        public RuleError Validatefield2(string field2us)
        {
            RuleError re = null;
            if (field2us == null || field2us.Trim().Length < 1)
                return null;

            if(field2us.Trim().ToUpper().Equals(field2.NO) ||
               field2us.Trim().ToUpper().Equals(field2.YES) ||
               field2us.Trim().ToUpper().Equals(field2.maybe)
               )
            {
                return null;
            }

            re = new RuleError(RuleErrorCodes.OTHER, RuleErrorTypes.ERROR, "error 2.");
            return re;
        }
       
}

int[] copyselection = (int[])selec.ToArray(typeof(int[]));