<div>
Hi friend<br />
You have to use Query like this;<br />
<br />
UPDATE &lt;TBL_NAME &gt;<br />
&nbsp; SET &nbsp;&lt;FieldName&gt; = 1<br />
&nbsp; &nbsp; WHERE &lt;FieldName&gt; = Text1.Text<br />
<br />
I HOPE THIS IS HELPFUL FOR YOU<br />
REGARDS,<br />
SATYADEV SINGH
</div>


<div>
Thanks, I'll try that out this morning and get back to you.
</div>


<div>
<div class="content wysiwyg-content">
I am using a datagrid (datagrid1) to display records from my sql database on a windows form. &nbsp;One of the fields is a bit datatype (field name = Disabled). &nbsp;This field displays as a check box.<br />
I have a button that filters records based on a criteria that a user enters into a text box. &nbsp;Now I have another button that when clicked, I want to set the disabled field to true for all of the records showing....I am guessing I need to use a foreach statement but I don't know how to do it. &nbsp;Any help?
</div>
</div>


I am using a datagrid (datagrid1) to display records from my sql database on a windows form.  One of the fields is a bit datatype (field name = Disabled).  This field displays as a check box.
I have a button that filters records based on a criteria that a user enters into a text box.  Now I have another button that when clicked, I want to set the disabled field to true for all of the records showing....I am guessing I need to use a foreach statement but I don't know how to do it.  Any help?

Hi friend
You have to use Query like this;

UPDATE &lt;TBL_NAME &gt;
  SET  &lt;FieldName&gt; = 1
    WHERE &lt;FieldName&gt; = Text1.Text

I HOPE THIS IS HELPFUL FOR YOU
REGARDS,
SATYADEV SINGH

Thanks, I&#39;ll try that out this morning and get back to you.

Set field to true for all displayed records.

I am using a datagrid (datagrid1) to display records from my sql database on a windows form.  One of the fields is a bit datatype (field name = Disabled).  This field displays as a check box.
I have a button that filters records based on a criteria that a user enters into a text box.  Now I have another button that when clicked, I want to set the disabled field to true for all of the records showing....I am guessing I need to use a foreach statement but I don&#39;t know how to do it.  Any help?

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.