title: How to access and/or modify the (sql)DataSource in code behind (ASP.net c#)?
body: <p>To connect to my database I used the wizard to make SQLDataSource. But I need to access it in code behind, to store my data in the database. Does someone knows how I can do that?</p>
  
  <p>I appreciate your help. This is the code:</p>
  
  <pre><code>&lt;asp:SqlDataSource 
  
  ID="MySqlDataSource" runat="server" 
              ConnectionString="&lt;%$ ConnectionStrings:HELPDESK_OUTLOOKConnectionString3 %&gt;" SelectCommand="SELECT 
  
  hd_aanvraag_fase.aanvraag_id,
  
  hd_statussen.status_omschrijving as status,
  
  hd_melding_niveau_1.niveau_omschrijving AS niveau1_omschrijving,
  
  aanvrager.werknemersnaam AS melder ,
  
  hd_aanvragen.aanvraag_titel ,
  
  hd_aanvragen.aanvraag_omschrijving,
  
  hd_aanvraag_fase.fase_datum
  
  FROM hd_aanvragen 
  
  INNER JOIN hd_meldingen         ON hd_meldingen.melding_id      =  hd_aanvragen.melding_id
  
  INNER JOIN hd_melding_niveau_1  ON  hd_melding_niveau_1.niveau1_id = hd_meldingen.niveau1_id
  
  INNER JOIN hd_melding_niveau_2  ON  hd_melding_niveau_2.niveau2_id = hd_meldingen.niveau2_id
  
  INNER JOIN hd_aanvraag_fase     ON hd_aanvraag_fase.aanvraag_id =  hd_aanvragen.aanvraag_id
  
  INNER JOIN hd_statussen         ON hd_statussen.status_id     =  hd_aanvraag_fase.status_id
  
  INNER JOIN  hd_werknemers AS oplosser    ON oplosser.werknemer_Id    =  hd_aanvraag_fase.werknemer_Id
  
  INNER JOIN hd_werknemers  AS aanvrager    ON aanvrager.werknemer_Id    =  hd_aanvragen.werknemer_Id
  
  WHERE hd_statussen.status_id = 15
  
  ORDER BY hd_aanvragen.aanvraag_id ,  hd_statussen.status_id"&gt;&lt;/asp:SqlDataSource&gt;
  </code></pre>