D
D. Shane Fowlkes
<asp:SqlDataSource ID="sqlCapBudgetItems" runat="server"
ConnectionString="<%$ ConnectionStrings:NETWebConnectionString %>"
SelectCommand="SELECT * FROM [CapitalBudgets] WHERE ([ApplicationID] =
@ApplicationID)">
<SelectParameters>
<asparameter DefaultValue="5477" Name="ApplicationID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
Looking at the sample above, can I define the actual value of the
asparameter to something else in another sub? The 5477 value is just for
testing but can I dynamically change this to whatever I want. I've tinkered
with some syntax but nothing is working so far. For example....
sub page_load()
My Sub()
end sub
My Sub()
'Look up user's ID record and change value of asparameter
DefaultValue to user's ID so I can load GridView with user data.
End Sub
Thanks!!
(VB.NET 2)
ConnectionString="<%$ ConnectionStrings:NETWebConnectionString %>"
SelectCommand="SELECT * FROM [CapitalBudgets] WHERE ([ApplicationID] =
@ApplicationID)">
<SelectParameters>
<asparameter DefaultValue="5477" Name="ApplicationID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
Looking at the sample above, can I define the actual value of the
asparameter to something else in another sub? The 5477 value is just for
testing but can I dynamically change this to whatever I want. I've tinkered
with some syntax but nothing is working so far. For example....
sub page_load()
My Sub()
end sub
My Sub()
'Look up user's ID record and change value of asparameter
DefaultValue to user's ID so I can load GridView with user data.
End Sub
Thanks!!
(VB.NET 2)