private void cmdAdd_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(txtCountryName.Text)) { DataOperations ops = new DataOperations(); int id = 0; string message = ""; if (ops.InsertCountry1(txtCountryName.Text, ref id, ref message)) { ((DataTable)dataGridView1.DataSource).Rows.Add(id, txtCountryName.Text); } else { MessageBox.Show(message); } } else { MessageBox.Show("Please add a country name"); } }
private void Form1_Shown(object sender, EventArgs e) { var ops = new DataOperations(); var countries = ops.Countries(); var index = countries .Select((item, pos) => new { Name = item.CountryName, Index = item.Id }) .FirstOrDefault(item => item.Name == "Venezuela").Index - 1; countriesComboBox.DataSource = countries; countriesComboBox.SelectedIndex = index; var contacts = ops.ContactTypes(); index = contacts .Select((item, pos) => new { Name = item.ContactTitle, Index = item.ContactTypeIdentifier }) .FirstOrDefault(item => item.Name == "Owner").Index - 1; contactTypeComboBox.DataSource = ops.ContactTypes(); contactTypeComboBox.SelectedIndex = index; dataGridView1.AutoGenerateColumns = false; }