Popup window from asp:Hyperlink with two parameters

Posted: July 31, 2007 | Author: | Filed under: ASP.NET 2 | Leave a comment

Here is a working sample for a popup window with two parameters:

C#:

<asp:TemplateField HeaderText="NamePop">
<ItemTemplate>
<asp:HyperLink runat="server"  ID="HyperLinkpopup"  NavigateUrl= <%#"javascript:_popupWin=window.open(
'btest.aspx?Sample_ID=" + Eval("Sample_ID") + "&Count_ID="+ Eval("Count_ID") +"','_popupWin',
'width=300,height=300,resizable=yes,location=yes,scrollbars=yes');_popupWin.focus()" %>
 Text='<%# Eval("Speciescode")+ "---" + Eval("Species")%>'></asp:HyperLink>
                        </ItemTemplate>
 </asp:TemplateField>
VB.NET:
 
<asp:TemplateField HeaderText="NamePop">
 <ItemTemplate>
 <asp:HyperLink runat="server"  ID="HyperLinkpopup"  NavigateUrl= 


<%#"javascript:_popupWin=window.open('btest.aspx?Sample_ID=" & Eval("Sample_ID") & "&Count_ID=" & Eval("Count_ID") 


& "','_popupWin','width=300,height=300,resizable=yes,location=yes,scrollbars=yes');_popupWin.focus()" %>
     Text='<%# Eval("Speciescode")& "---" & Eval("Species")%>'></asp:HyperLink>
 </ItemTemplate>
</asp:TemplateField>


  

Switch function in Access

Posted: July 25, 2007 | Author: | Filed under: Access 2007 | Leave a comment
Today i came across Switch function for a forum question. The user wants to sort his Month column in right order instead of alphabetically. It would be easy to do this in SQL Server with CASE statement. Thought IIF in Access should work, but it stops at nested level 10. Here comes the Switch function, the syntax of Switch is:
Switch(Expression1, What To Do If Expression1 Is True,
       Expression2, What To Do If Expression2 Is True,
       Expression_n, What To Do If Expression_n Is True) As SomeValue

Unlike IIf(), the Switch() function does not take a fixed number of arguments. It takes as many combinations of <Expression -> Statement>s as you need. Each expression is evaluated. If the expression evaluates to true, the statement that follows it executes.

http://www.yevol.com/en/access2007/Lesson13.htm

The solution for the user is:
Query:
SELECT * FROM (SELECT id, TalkMonth, CINT(Switch([TalkMonth]='January',1,
[TalkMonth]='February',2,
[TalkMonth]='March',3,
[TalkMonth]='April',4,
[TalkMonth]='May',5,
[TalkMonth]='June',6,
[TalkMonth]='July',7,
[TalkMonth]='August',8,
[TalkMonth]='September',9,
[TalkMonth]='Octeber',10,
[TalkMonth]='November',11,
[TalkMonth]='December',12,
[TalkMonth] is NULL,999)) As TalkMonthNumber
FROM 12Months) 
ORDER BY TalkMonthNumber

 And use the new numeric column in SortExpression for the string column.
<asp:BoundField DataField="TalkMONTH" HeaderText="TalkMONTH" SortExpression="TalkMonthNumber" />
However,it seems that Switch can only go upto level 14 for nesting.