Oki first of all, consider reading up on sql injection, because you REALLY don't want to use variables directly from a user interface in a query.
Update Estado in a specific numseries
string estado = CheckMyUiValues(comoBox1.Text);
string nums = CheckMyUiValues(comoBox1.Text);
var sql = "UPDATE dbo.testenumserie SET ESTADO = '{0}' WHERE NUMSERIE = '{1}'";
using(var cn = new GetOpenConnection()){
using(var cmd = new SqlCommand(cn, string.format(sql, estado, nums)){
cmd.ExecuteNonQuery();
}
}
or in a somewhat more crude way
string estado = comoBox1.Text;
string nums = comoBox1.Text;
var sql = "UPDATE dbo.testenumserie SET ESTADO = '{0}' WHERE NUMSERIE = '{1}'";
string conn = "put your connection string details in here";
using(var cn = new SqlConnection(conn)){
using(var cmd = new SqlCommand(cn, string.Format(sql, estado, nums)){
cmd.ExecuteNonQuery();
}
}