title: Update SQL only on selected columns
body: <p>I building edit menu in C# to edit SQL rows in the database but I want the user to be able to choose which column in the particular row to update  to update  if they left the box empty I don't want to update that column. for example </p>
  
  <p>the user sees three boxes he can enter something into one box that would reflect updating only one column in the row, rest of the columns would stay as they were. I started implementing something like this</p>
  
  <pre><code>string RowUpdate ="";
  if(Title !="" &amp;&amp; Author =="" &amp;&amp; Pages==""){
  RowUpdate = "Update BookTable set Title=@Title where BookID=@ID";
  }
  else if (Title =="" &amp;&amp; Author !="" &amp;&amp; Pages ==""){
  RowUpdate = "Update BookTable set Author=@Author where BookID=@ID";
  }
  </code></pre>
  
  <p>when logic is completed the Correct SQL will be picked,
  as you can see this type of logic for only 3 text boxes take 9 different outcomes and it scales exponentially as edit rows would grow. </p>
  
  <p>I don't know if that even possible but is there a way to update an only particular column if there was no value entered so I don't have to write huge logic to update only particular column?</p>
  
  <p>something like </p>
  
  <pre><code> RowUpdate = "Update BookTable set (IF null Skip Title=@Title),(If null Skip   Author=@Author), (If null Skip Pages=@Pages) where BookID=@ID
  </code></pre>
  
  <p>or any other way to do this simpler and quicker?
  thank you for answers</p>