private void Add() { //Add row DTO.DataRow row = new DTO.DataRow(); row.ColumnStructure = this.table.ColumnStructure; foreach (Control ctrl in this.pnlValues.Controls) { ColumnStructure cs = (ColumnStructure)ctrl.Tag; if (ctrl is TextBox) { row.Attributes.Add(new Flag(cs.ColumnName, ctrl.Text, cs.DataType)); } else if (ctrl is ComboBox) { string value = string.Empty; if (!string.IsNullOrEmpty(ctrl.Text)) { value = ctrl.Text.Split(';')[0]; } row.Attributes.Add(new Flag(cs.ColumnName, value, cs.DataType)); } } this.table.DataRows.Add(row); //Clear fields if (this.ctrlToIncrement != null) { Int32.TryParse(this.ctrlToIncrement.Text, out int id); this.ClearFields(); this.ctrlToIncrement.Text = (id + 1).ToString(); } else { this.ClearFields(); } //Generate query this.txtQuery.Text = InsertStatement.GetQuery(table); }