How Do I Pass VB Variables To The Asp Parameters Of An SqlDataSource?

I’ve got the following piece of ASP code, which updated a
table through the standard edit/update command filed options.

 


        <
asp:
SqlDataSource ID="SqlDataSource1" runat="server"


            ConnectionString="<%$
ConnectionStrings:CAT_SYSTEMConnectionString %>"


            OldValuesParameterFormatString="original_{0}"



            SelectCommand="sp_diplomaViewQualifications"



            UpdateCommand="UPDATE
PsnQualifications SET quantity=@quantity WHERE rowstatus=1 and
qualId=@original_qualId"


            DeleteCommand="UPDATE
PsnQualifications SET rowStatus=0, lastUpdateOn=getdate(), lastUpdateBy=@createdBy
WHERE rowstatus=1 and qualId=@original_qualId"


            SelectCommandType="StoredProcedure">


            <
UpdateParameters>


                <
asp:
Parameter Name="original_qualId"
/>


                <
asp:
Parameter Name="quantity"
/>


    
       </
UpdateParameters>


            <
DeleteParameters>


                <
asp:
Parameter Name="original_qualId"
/>


                <
asp:
Parameter Name="createdBy"
  DefaultValue="TEST"/>


            </
DeleteParameters>


            <
SelectParameters>


                <
asp:
Parameter Name="masterKey"
/>


            </
SelectParameters>


        </
asp:
SqlDataSource>

 


My problem is that I need to pass the contents
of the VB variable ‘createdBy’ into the DeleteParameters option.


 


This is defined in the code as: Dim createdBy As String = getUserLoginName(Me.Page)

How do I pass this into the update and/or delete part
of the command field on the ASP page?