how to automatically check a checkbox from a condition

Question

Good morning,

I have two tables, the first is called [dettaglioMateriale]

the second is called [fuoriUso]

in the first table I have a checkbox in the "Dismesso" column. I would like this Checkbox to be checked when this condition occurs:

this is the checkbox in the gridview:

<asp:TemplateField HeaderText="FU" SortExpression="Dismesso">  
    <ItemTemplate>  
       <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("Dismesso") %>' Enabled="false" />  
    </ItemTemplate>  
</asp:TemplateField>  

I use vb.net, thanks in advance to those who can advise me.

Answer 1

Hi @Tabboz ,
What' your data in your database? When you auto check the checkbox?
I have do a demo that your Dismesso are all false in the database. And when you bind the data to the gridview, the checkbox will auto checked according to the condition.
You could use these sql when binding the data.

UPDATE dettaglioMateriale  
SET dettaglioMateriale.Dismesso=1  
FROM  dettaglioMateriale INNER JOIN fuoriUso ON dettaglioMateriale.IDdettaglio=fuoriUso.CODdettaglio  

Best regards,
Yijing Sun

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.