void FillProfile()
{
MySqlCommand cmd = new MySqlCommand(connect_to_DB.Return_All_Mezun_Query(), connection);
MySqlDataReader dbr = cmd.ExecuteReader();
while (dbr.Read())
{
if (dbr[0].ToString() == id)
{
textBox1.Text = dbr[1].ToString();
textBox2.Text = dbr[2].ToString();
textBox3.Text = dbr[3].ToString();
textBox4.Text = dbr[7].ToString();
textBox5.Text = dbr[5].ToString();
textBox6.Text = dbr[6].ToString();
textBox10.Text = dbr[12].ToString();
textBox11.Text = dbr[13].ToString();
textBox13.Text = dbr[8].ToString();
comboBox1.Text = dbr[9].ToString();
comboBox2.Text = dbr[11].ToString();
comboBox3.Text = dbr[10].ToString();
}
}
dbr.Close();
Liststo_ComboBOX();
}
void UpdateCVForm()
{
MySqlCommand cmd = new MySqlCommand(connect_to_DB.Return_All_Mezun_Query(), connection);
MySqlDataReader dbr = cmd.ExecuteReader();
while (dbr.Read())
{
if ((int)dbr[0] == userid)
{
cv_list.name = dbr[1].ToString();
cv_list.surname = dbr[2].ToString();
cv_list.phone_no = dbr[8].ToString();
cv_list.email = dbr[5].ToString();
cv_list.work = dbr[9].ToString();
cv_list.work_area = dbr[11].ToString();
cv_list.work_pos = dbr[10].ToString();
break;
}
}
dbr.Close();
textBox1.Text = cv_list.name;
textBox2.Text = cv_list.surname;
textBox3.Text = cv_list.phone_no;
textBox4.Text = cv_list.email;
comboBox1.Text = cv_list.work_area;
comboBox2.Text = cv_list.work_pos;
comboBox3.Text = cv_list.work;
dbr.Close();
}