title: How do I add a record in my database when it is coming from a checklist box control from?
body: <p>I'm having trouble on how to code this. First I need to assign a value for every item in the list (<code>1</code> for the first item, <code>2</code> for the 2nd and so on). Does this control have a separate field for the value aside from text?</p>
  
  <p>Second, I need to insert this into my database (MSSQL 2008) in this format:</p>
  
  <p><code>insert into table values(ID,</code><em><code>selectedvaluegoeshere</code></em><code>)</code></p>
  
  <p>Can someone guide me on how to achieve this.</p>