Expire Session when click back/refresh

        Response.Buffer = true;
        Response.ExpiresAbsolute = DateTime.Now.Subtract(new TimeSpan(0, 0, 0, 0, 1));    <—–( day, hour, min, second, msecond)
        Response.Expires = 0;
        Response.CacheControl = “no-cache”;

FLV Streaming in .NET

之前整左好耐既flv streaming, 加左mime 都係唔得~~ 究竟係咩問題呢~~ >_<~

最終搵到一個web 係講.net 同flv streaming….. 原來…係… .net 同佢既問題, 係好複雜~~不過呢個方法係work ~~ very good!

http://blogs.ugidotnet.org/kfra/archive/2006/10/04/50003.aspx

flv file 一定要同個aspx 放係同一個level 先行到…. / _ \

get from databind value and pass in querystring

<asp:Hyperlink runat=”server” Text=’<%#DataBinder.Eval(Container.DataItem,”Order ID”)%>’ NavigateUrl=’<%# “page.aspx?Orderid=” + DataBinder.Eval(Container.DataItem,”Orderid”) + “&ProductID=” + DataBinder.Eval(Container.DataItem,”ProductID”)%>’ ID=”Hyperlink1″ NAME=”Hyperlink1″/>

Datalist ([Eval("XXX") ])

<asp:DataList ID=”DataList3″ runat=”server” DataSourceID=”SqlDataSource3″ RepeatColumns=”4″ CellPadding=”20″ CellSpacing=”20″
                ShowFooter=”False” ShowHeader=”False”>
                <HeaderTemplate>
               
                </HeaderTemplate>
                <ItemTemplate>
                    <a href=’<%# Eval(“AP_LINK”, “?getgroup=”)%><%# Eval(“AP_PAGEGROUP”) %>’ rel=’lightbox[<%# Eval("AP_THUMB") %>]‘ id=’<%# Eval(“AP_UID”) %>’
                        title=’<%# Eval(“AP_ALT”) %>’>
                        <img src=’<%# Eval(“AP_THUMB”, “images/press/{0}”)%>’ alt=’<%# Eval(“AP_ALT”) %>’ title=’<%# Eval(“AP_ALT”) %>’ border=”0″ /></a>
                </ItemTemplate>
                <HeaderStyle Font-Bold=”False” Font-Italic=”False” Font-Overline=”False” Font-Strikeout=”False” Font-Underline=”False” Wrap=”False” />
            </asp:DataList>
            <asp:SqlDataSource ID=”SqlDataSource3″ runat=”server” ConnectionString=”<%$ ConnectionStrings:WebDBConnectionString %>” SelectCommand=”SELECT * FROM [A_Press] WHERE (([IS_ACTIVE] = @IS_ACTIVE) AND ([AP_PAGE] = @AP_PAGE) AND (YEAR([AP_POSTDATE]) = @AP_POSTDATE))”>
                <SelectParameters>
                    <asp:Parameter DefaultValue=”1″ Name=”IS_ACTIVE” Type=”Int16″ />
                    <asp:Parameter DefaultValue=”0″ Name=”AP_PAGE” Type=”Int16″ />
                    <asp:QueryStringParameter DefaultValue=”2009″ Name=”AP_POSTDATE” QueryStringField=”year” />
                </SelectParameters>
            </asp:SqlDataSource>

break sql statement

係一句sql statement , 係前面加 @ , 咁就可以直接click enter 分行~~

OleDbCommand cmd1 = new OleDbCommand(@”INSERT INTO [orders] (customer_name, customer_address, customer_suburb,
customer_postcode, customer_state, card_type, card_number, card_expire, order_total, order_date) VALUES (‘@name’, ‘@address’, ‘@suburb’, @code, ‘@state’,
‘@type’, @number, ‘@expire’, @total, ‘@date’)”, conn1);