title: C#- Updating just updated column(s)
body: <p>I have a web form. There are 20 fields that correspond to the columns in a database table. Let's say there's one record that has a BIRTHDATE column and I change its value from 13-July-2000 to 12-FEB-1985. But I don't touch the rest of the columns. Is there a way in C# to run an update statement like this:</p>
  
  <pre><code>UPDATE TABLE1 SET BIRHDATE=NEWVALUE WHERE ID=1111
  </code></pre>
  
  <p>instead of updating all the columns of the row like this:</p>
  
  <pre><code>UPDATE TABLE1 SET COLUMN1=NEWVALUE1, COLUMN2=NEWVALUE2,......,BIRTHDATE=NEWVALU
  </code></pre>
  
  <p>I think it would be a waste of resource. Am I wrong? I think DataAdapters are for this purpose but I'm not sure.</p>