private void btnEdit_Click(object sender, EventArgs e) { int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) return; EditForm frmEdit = new EditForm(); NpgsqlDataReader npgSqlDataReader; using (NpgsqlConnection conn = new NpgsqlConnection(connStr)) using (NpgsqlCommand cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandText = @"SELECT * FROM friends WHERE id=@id;"; cmd.Parameters.Add(new NpgsqlParameter("@id", id)); npgSqlDataReader = cmd.ExecuteReader(); foreach (DbDataRecord dbDataRecord in npgSqlDataReader) { frmEdit.textBoxLastName.Text = dbDataRecord["lastname"].ToString(); frmEdit.textBoxFirstName.Text = dbDataRecord["firstname"].ToString(); frmEdit.dtpBirthDate.Value = DateTime.Parse(npgSqlDataReader["birth"].ToString()); } } DialogResult result = frmEdit.ShowDialog(this); if (result == DialogResult.Cancel) return; using (NpgsqlConnection conn = new NpgsqlConnection(connStr)) using (NpgsqlCommand cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandText = "UPDATE friends SET lastname=@lastname, firstname=@firstname, birth=@date WHERE id=@id"; cmd.Parameters.Add(new NpgsqlParameter("@lastname", frmEdit.textBoxLastName.Text)); cmd.Parameters.Add(new NpgsqlParameter("@firstname", frmEdit.textBoxFirstName.Text)); cmd.Parameters.Add(new NpgsqlParameter("@date", frmEdit.dtpBirthDate.Value.ToString("yyyy-MM-dd"))); cmd.Parameters.Add(new NpgsqlParameter("@id", id)); cmd.ExecuteNonQuery(); } SelectData(); }
private void btnAdd_Click(object sender, EventArgs e) { EditForm frmEdit = new EditForm(); DialogResult result = frmEdit.ShowDialog(this); if (result == DialogResult.Cancel) return; using (NpgsqlConnection conn = new NpgsqlConnection(connStr)) using (NpgsqlCommand cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandText = @"INSERT INTO friends (lastname, firstname, birth) VALUES(@lastname, @firstname, @birth);"; cmd.Parameters.Add(new NpgsqlParameter("@lastname", frmEdit.textBoxLastName.Text)); cmd.Parameters.Add(new NpgsqlParameter("@firstname", frmEdit.textBoxFirstName.Text)); cmd.Parameters.Add(new NpgsqlParameter("@birth", frmEdit.dtpBirthDate.Value.ToString("yyyy-MM-dd"))); cmd.ExecuteScalar(); } SelectData(); }