I have a problem with updating records in a database table. Background: The user can fetch data that belongs with an image. The
data is displayed in a form. In this form the user can add/change data and then save this to the database. This part works fine.
My next step is to let the user click a checkbox in the form to choose one image. The chosen image gets the value "1" in column Publish. This also works fine.
Here's my problem: I also want to let the user choose another image, this image does get a "1" in column Publish. But as the change is saved I want to update the column Publish so that the rest of the images gets a "0" in column Publish (there can be only one). This does not work for me. I'm not sure if the error lies in the sql UPDATE or somewhere else. Thankful for help!
protected void ButtonImgTextToDB_Click(object sender, EventArgs e)
string BildID = TextBoxStartPictID.Text;
string Rubrik = TextBoxHeadLineStart.Text;<
View Complete Post