title: Selected Data in CheckBoxList to Gridview
body: <p>I have a <code>CheckBoxList</code> like this. (There are customer name)</p>
  
  <p><img src="https://i.stack.imgur.com/TK4c6.png" alt="Checkboxlist"></p>
  
  <p>These are customer name and every customer has a customer number (<code>Unique</code> -- <code>Primary Key</code>)</p>
  
  <p>Table: <code>S_TEKLIF</code></p>
  
  <p><code>MUS_K_ISIM</code> represent Customer Name</p>
  
  <p><code>HESAP_NO</code> represent Customer Number</p>
  
  <p>I have a <code>Send Button</code> and <code>Gridview</code>.
  When i click the Send Button, </p>
  
  <p>In my <code>Gridview</code>, I just want run this <code>SQL</code>;</p>
  
  <pre><code>SELECT A.HESAP_NO, A.TEKLIF_NO1 || '/' || A.TEKLIF_NO2 AS TEKLIF, A.MUS_K_ISIM, 
  B.MARKA, C.SASI_NO, C.SASI_DURUM, D.TAS_MAR, RISK_SASI(A.TEKLIF_NO1, A.TEKLIF_NO2, C.SASI_NO) AS RISK,
  MV_SASI(A.TEKLIF_NO1, A.TEKLIF_NO2, C.SASI_NO, SYSDATE) AS MV
  FROM S_TEKLIF A,  S_URUN B, S_URUN_DETAY C, KOC_KTMAR_PR D
  WHERE A.TEKLIF_NO1 || A.TEKLIF_NO2 = B.TEKLIF_NO1 || B.TEKLIF_NO2
  AND A.TEKLIF_NO1 || A.TEKLIF_NO2 = C.TEKLIF_NO1 || C.TEKLIF_NO2
  AND B.SIRA_NO = C.URUN_SIRA_NO
  AND B.DISTRIBUTOR = D.DIST_KOD
  AND B.MARKA = D.MARKA_KOD
  AND B.URUN_KOD = D.TAS_KOD
  AND A.HESAP_NO IN (
  </code></pre>
  
  <p>But as you can see bottom of th <code>SQL</code>, I just want to show "<strong>Which customers i selected in CheckBoxList</strong>" in my Gridview.</p>
  
  <p>How can i do that?</p>
  
  <p>What should be in my <code>Send_Click()</code> function and in my <code>SQL</code>?</p>
  
  <p>Best Regards, Soner</p>