private void Search_Load(object sender, EventArgs e) { DataTable dt = DBConnection.SelectAllWorkers(); dataGridView1.DataSource = dt; DataSet dataSet = DBConnection.SelectAllPositions(); //Попълване на комбобокса за позиция if (dataSet.Tables[0].Rows.Count >= 1) { for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { Position.AddPositionToList(dataSet.Tables[0].Rows[i]["NamePos"].ToString()); schPosition.Items.Add(dataSet.Tables[0].Rows[i]["NamePos"].ToString()); } } FillDepartmentComboBox(); FillLanguageComboBox(); FillwIDComboBox(); }
private void button3_Click(object sender, EventArgs e) { DataTable dt = DBConnection.SelectAllWorkers(); dataGridView1.DataSource = dt; }