Home » 2011 » September » 16

Archive for September 16, 2011

VB.NET – Parameters

Parameter default value in code behind SQL Datasource <asp:sqldatasource ID=”ServiceExpired” runat=”server” ConnectionString=”< %$ ConnectionStrings:intranetConnectionString2 %>” SelectCommand=”SELECT * FROM [Invoice] _ WHERE _ ([EXPIRATION_DATE] >= @EXP_BEG) _ AND _ ([EXPIRATION_DATE] < @EXP_END) _ AND ([EXPIRATION_CONTACT] = @EXPIRATION_CONTACT) _ ORDER BY _ EXPIRATION_DATE "> <selectparameters> <asp:parameter DefaultValue=”YES” Name=”EXPIRATION_CONTACT” Type=”String” /> <asp:parameter Name=”EXP_BEG” Type=”DateTime”/> <asp:parameter Name=”EXP_END” Type=”DateTime”/> </selectparameters> […]