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> […]
Archive for 2011
VB.NET – Date in code behind
Here is example of how we can define date in code behind: Current month name ‘ – label text for current month (e.i. September) CMonthLbl.Text = “Current month is ” & MonthName(Date.Now.Month).ToString() ‘ – label <asp:label ID=”CMonthLbl” runat=”server”> ‘ – output Current month is September Other examples: Any month name ‘ – your favorite month […]
OnMouseOver Pop-Up Box
code <head> <meta http-equiv=”Content-Language” content=”en-us”> <meta http-equiv=”Content-Type” content=”text/html; charset=windows-1252″> <title>My Page</title> <link rel=”stylesheet” href=”../link.css” type=”text/css”> <script type=”text/javascript” src=”../javascript/browser_detect.js”></script> <script type=”text/javascript” src=”../javascript/popup.js”></script> </head> <body> PROFESSIONAL SKILLS<a onmouseover=”popup(‘Skills and abilities not directly related to the position for which you are applying, however, they may provide additional insight into your abilities as an employee (Examples: typing 60 words […]