How to access and / or change (sql) DataSource in code behind (ASP.net C #)?

Question

To connect to my database, I used the wizard to create the SQLDataSource. But I need to access it in code to store my data in a database. Does anyone know how I can do this?

I appreciate your help. This is the code:

<asp:SqlDataSource ID="MySqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:HELPDESK_OUTLOOKConnectionString3 %>" 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"></asp:SqlDataSource> 

Answer 1

Do you need to get SQLDS data in something like DataTable in order to see your data on code? or do you just need to return the data to the database?

Although I give you two useful links that can help you in both situations:

1) http://www.dotnetspider.com/resources/7333-How-Extract-data-from-SQLDataSource-Data.aspx

 DataView dv = new DataView(); DataTable dt = new DataTable(); dv = mySQLDataSource.Select(DataSourceSelectArguments.Empty) as DataView; dt = dv.ToTable(); 

now on dt you have your own data

2) http://www.c-sharpcorner.com/UploadFile/raj1979/SqlDataSource10032008142537PM/SqlDataSource.aspx

Work with sqldatasource on .net 3.5

Hope this helps

Answer 2

If you specify the data source ID, in the markup code:

 <SqlDataSource ID="MyDatasource" .../> 

You must have access to it from the code.