private void rows_add_addRow_button_Click(object sender, EventArgs e) { var table = dash_tables_listBox.SelectedItem?.ToString(); if (string.IsNullOrWhiteSpace(table)) { HandleError("Must select table"); return; } if (dash_columns_listBox.Items.Count - 1 != rows_add_rowValues_listBox.Items.Count) { HandleError("Must provide a value for every column except ID"); return; } var columns = new List <ColumnDto>(); foreach (var col in dash_columns_listBox.Items) { var name = col.ToString().Split(' ')[0]; var type = col.ToString().Split(' ')[1].Trim(new char[] { '(', ')' }); columns.Add(new ColumnDto() { ColumnName = name, Value = type }); } var rows = new List <string>(); foreach (var row in rows_add_rowValues_listBox.Items) { rows.Add(row.ToString()); } var dto = new AddNewRowDto() { TableName = $"{dash_statusStrip_schema_value.Text}.{table}", Columns = columns, Rows = rows }; try { var id = _sql.AddRowToTable(dto, connDto); WriteToLog($"Successfully added values into row ID: {id}"); rows_add_rowValues_listBox.Items.Clear(); rows_add_rowValue_textBox.Text = string.Empty; } catch (Exception ex) { HandleError("Error adding values:", ex); return; } }