private void StudentsListForm_Load(object sender, EventArgs e) { //ladowanie danych MySqlCommand command = new MySqlCommand("SELECT * FROM `students`"); dataGridView1.ReadOnly = true; DataGridViewImageColumn gridViewImageColumn = new DataGridViewImageColumn(); dataGridView1.RowTemplate.Height = 80; dataGridView1.DataSource = studentClass.getStudents(command); gridViewImageColumn = (DataGridViewImageColumn)dataGridView1.Columns[7]; gridViewImageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch; dataGridView1.AllowUserToAddRows = false; }
public void loadData(MySqlCommand command) { dataGridView1.ReadOnly = true; DataGridViewImageColumn gridViewImageColumn = new DataGridViewImageColumn(); dataGridView1.RowTemplate.Height = 80; dataGridView1.DataSource = studentClass.getStudents(command); gridViewImageColumn = (DataGridViewImageColumn)dataGridView1.Columns[7]; gridViewImageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch; dataGridView1.AllowUserToAddRows = false; }
private void buttonFindStudent_Click(object sender, EventArgs e) { //przeszukiwanie try { int id = Convert.ToInt32(textBoxID.Text); MySqlCommand command = new MySqlCommand("SELECT `id`, `first_name`, `last_name`, `birthday`, `gender`, `phone`, `address`, `picture` FROM `students` WHERE `id` =" + id, db.getConnection); DataTable dataTable = studentClass.getStudents(command); if (dataTable.Rows.Count > 0) { textBoxName.Text = dataTable.Rows[0]["first_name"].ToString(); textBoxLastName.Text = dataTable.Rows[0]["last_name"].ToString(); textBoxPhone.Text = dataTable.Rows[0]["phone"].ToString(); textBoxAdres.Text = dataTable.Rows[0]["address"].ToString(); dateTimePickerNewStudent.Value = (DateTime)dataTable.Rows[0]["birthday"]; if (dataTable.Rows[0]["gender"].ToString() == "Kobieta") { radioButtonFemale.Checked = true; } else { radioButtonMale.Checked = true; } } byte[] picture = (byte[])dataTable.Rows[0]["picture"]; MemoryStream pic = new MemoryStream(picture); pictureBoxStudent.Image = Image.FromStream(pic); }catch { MessageBox.Show("Podaj poprawny numer ID", "Niepoprawny numer ID", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }