Mark a row containing a bool value as conditional

Mehmet Fatih

2y764C#

I have 3 rickboxes in the form. I fill them at different times. When the last rickbox is filled, I want the column named “tamamlandi” that contains the bool value to mark as checked. But I couldn't succeed. I need your help on this matter.

This is my code.

string kayit = "update mytablename set tamamlandi=@tamamlandi

if (txt_gorusme1.Text != string.Empty && txt_gorusme2.Text != string.Empty && txt_gorusme3.Text != string.Empty)
{
komut.Parameters.AddWithValue("@tamamlandi", true);
}
else
{
komut.Parameters.AddWithValue("@tamamlandi", DBNull.Value);
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar2y ago

Accepted answer

Hello,

You need to write code on txt_gorusme3_TextChanged event for your 3rd txt_gorusme3 as below,


protected void txt_gorusme3_TextChanged(object sender, EventArgs e)
{
   string kayit = "update mytablename set  tamamlandi=@tamamlandi";

 if ( !string.IsNullOrEmpty(txt_gorusme1.Text) && !string.IsNullOrEmpty(txt_gorusme2.Text) && !string.IsNullOrEmpty(txt_gorusme3.Text))
 {
     komut.Parameters.AddWithValue("@tamamlandi", true);
 }
 else
 {
     komut.Parameters.AddWithValue("@tamamlandi", DBNull.Value);
 }
}