❔ Help in sql client query Update
In the image as you see thats my datagridview and when i click on the button it will change all Acoes to "Validado", but i wanted just the row that the button is in , what and how can i do this?
This is the statment i have
This is the statment i have
private void dataGridViewAcoesPendentes_CellClick_2(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewAcoesPendentes.Columns[e.ColumnIndex].HeaderText == "BtnEditar")
{
int id;
id = Convert.ToInt32(dataGridViewAcoesPendentes.Rows[e.RowIndex].Cells["acaoID"].Value);
con.Open();
try
{
SqlCommand cmd = new SqlCommand("UPDATE tbl_acoes SET estado = 'Validado'", con);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Ação Validado");
SqlCommand cmd2 = new SqlCommand("SELECT * FROM tbl_acoes WHERE estado = 'pendente'", con);
DataTable dt = new DataTable();
dt.Load(cmd2.ExecuteReader());
dataGridViewAcoesPendentes.DataSource = dt;
con.Close();
}
else
{
MessageBox.Show("Ensaio nao validado!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
} private void dataGridViewAcoesPendentes_CellClick_2(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewAcoesPendentes.Columns[e.ColumnIndex].HeaderText == "BtnEditar")
{
int id;
id = Convert.ToInt32(dataGridViewAcoesPendentes.Rows[e.RowIndex].Cells["acaoID"].Value);
con.Open();
try
{
SqlCommand cmd = new SqlCommand("UPDATE tbl_acoes SET estado = 'Validado'", con);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Ação Validado");
SqlCommand cmd2 = new SqlCommand("SELECT * FROM tbl_acoes WHERE estado = 'pendente'", con);
DataTable dt = new DataTable();
dt.Load(cmd2.ExecuteReader());
dataGridViewAcoesPendentes.DataSource = dt;
con.Close();
}
else
{
MessageBox.Show("Ensaio nao validado!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
