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;
}