private void taidalist() { if (dataGridViewCountry.SelectedCells.Count == 1) { // otsime valitud rea riigi nimetus int selectedrowindex = dataGridViewCountry.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dataGridViewCountry.Rows[selectedrowindex]; label1.Text = Convert.ToString(selectedRow.Cells[0].Value); List <City> city = new List <City>(); city = CountryDB.GetAllCitiesbyCountryName(label1.Text); DataTable table = new DataTable(); DataColumn idColumn = table.Columns.Add("Name", typeof(string)); table.Columns.Add("District", typeof(string)); table.Columns.Add("Population", typeof(long)); table.PrimaryKey = new DataColumn[] { idColumn }; foreach (City c in city) { table.Rows.Add(new object[] { c.Name, c.District, c.Population }); } table.AcceptChanges(); dataGridViewCity.DataSource = table; } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { List <City> city = new List <City>(); city = CountryDB.GetAllCitiesbyCountryName(comboBox1.Text); DataTable table = new DataTable(); //DataColumn idColumn = table.Columns.Add("Name", typeof(string)); table.Columns.Add("Name", typeof(string)); table.Columns.Add("District", typeof(string)); table.Columns.Add("Population", typeof(long)); //table.PrimaryKey = new DataColumn[] { idColumn }; foreach (City c in city) { table.Rows.Add(new object[] { c.Name, c.District, c.Population }); } table.AcceptChanges(); dataGridView1.DataSource = table; }