Month: November 2008

declare   @str   varchar(8000)  
  set   @str   =   ”  
  select   @str   =   @str   +   ‘,’   +   name   From   sysobjects   WHERE   xtype=’P’   and   status>=0  
  select   @str   =   ‘drop   proc   ‘   +   substring(@str,2,8000)  
  select   @str  
  exec   (@str)   
 

        <asp:DataList ID="DataList1" runat="server" BorderWidth="1px" CellPadding="2"
        DataKeyField="qaa_id" DataSourceID="SqlDataSource1"  GridLines="Both" HorizontalAlign="Center" Width="98%"
        ExtractTemplateRows="True">

            <ItemTemplate>
           
            <asp:Table ID="Table1" runat="server">
                <asp:TableRow>
                    <asp:TableCell Text='<%# (Convert.ToInt32(Eval("qaa_userid"))==0)?"客服回复":"我的问题"%>’ RowSpan="2" CssClass="tdleftcol"></asp:TableCell>
                    <asp:TableCell Text='<%# Eval("qaa_content") %>’></asp:TableCell>
                </asp:TableRow>
                <asp:TableRow>  
                    <asp:TableCell Text='<%# Eval("qaa_date") %>’ CssClass="grayfont"></asp:TableCell>              
                </asp:TableRow>
            </asp:Table>

            </ItemTemplate>
    </asp:DataList>

        private void RefreshCurrentPage()
        {
            if (Request.QueryString["randomseed"] == null)
            {
                Response.Redirect(Request.RawUrl + "?randomseed=" + DateTime.Now.ToString());
            }
        }

Request.RawUrl, 当前页网址， 加个随机种子，这样就不会再读缓存。

声明decimal，后面加个M就好了。

decimal intNum = 0.01M;