using System.Data.OleDb;
using System.Data;

----------------------------获取数据-------------------------------

        OleDbConnection conn = new OleDbConnection(DB.conn);
        conn.Open();
        string sql = "select * from cxy_pageC where id=1";
        OleDbCommand cmd = new OleDbCommand(sql,conn);
        OleDbDataReader dr = cmd.ExecuteReader();
        dr.Read();

----------------------------格式化日期时间-----------------------
<%# DataBinder.Eval(Container.DataItem, "addtime", "{0:yyyy-MM-dd}")%>

--------------------------------图片路径--------------------------
UpLoadFile/Small_Img/<%#Eval("picurl")%>

--------------------------------详细页链接--------------------------
product_details.aspx?id=<%#Eval("id") %>
news_details.aspx?id=<%#Eval("id") %>


-------------------------------截取标题--------------------------
<%#Eval("title").ToString().Length>=35?Eval("title").ToString().Substring(0,35):Eval("title") %>


----------------------------------获取new图片--------------------------------
<%#getimg(Convert.ToDateTime(Eval("addtime")))%>

    public string getimg(DateTime data)
    { 
        string dt1 = data.ToString(); 
        string dt2 = System.DateTime.Now.ToLocalTime().ToString();
        TimeSpan sjc = Convert.ToDateTime(dt2) - Convert.ToDateTime(dt1);
        double day = sjc.TotalDays;
        if (day <= 7)
        {
            return "<img src='images/links_img.gif' class='links_img'/>";
        }
        else {
            return "";
        }
    }

----------------------------------绑定数据（带分页）----------------------------
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>       -----------引用命名空间

         <webdiyer:AspNetPager ID="AspNetPager1" runat="server" 
             onpagechanged="AspNetPager1_PageChanged" 
             CurrentPageButtonPosition="Center" 
             CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页显示%PageSize%条信息" 
             FirstPageText="首页" LastPageText="尾页" LayoutType="Div" NextPageText="下一页" 
             PageIndexBoxType="TextBox" PagingButtonLayoutType="None" 
             PrevPageText="上一页" ShowCustomInfoSection="Never" SubmitButtonText="Go" 
             ShowPageIndexBox="Never" TextBeforePageIndexBox="转到第" TextAfterPageIndexBox="页" >
           </webdiyer:AspNetPager>                                                                      -------分页控件


	<asp:Panel runat="server" ID="noinf" Visible="false">暂无资料...</asp:Panel>                     --------没有数据时显示

    public void dataBind() {
        string sql = "";
        if (Request.QueryString["class"] != "" && Request.QueryString["class"] != null)
        {
            sql = "select * from cxy_NewsC where clsid=" + Request.QueryString["class"].ToString()+" order by id desc";
        }
        else
        {
            sql = "select * from cxy_NewsC where clsid in (92,98,99) order by id desc";
        }
        OleDbConnection conn = new OleDbConnection(DB.conn);
        conn.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(sql,conn);
        DataSet ds = new DataSet();
        DataSet ds2 = new DataSet();
        da.Fill(ds2);
        AspNetPager1.PageSize = 10;
        AspNetPager1.RecordCount = (int)ds2.Tables[0].Rows.Count;
        if (AspNetPager1.RecordCount == 0) {
            noinf.Visible = true;
        }
        da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize,"aaa");
        news_list.DataSource = ds;
        news_list.DataBind();
        conn.Close();
    }

    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        dataBind();
    }

--------------------------------------返回----------------------
<div style="text-align:center;"><a href="javascript:window.history.go(-1);">返回</a></div>

------------------------------------获取编号（写在pageload事件中）-------------------------------------
    protected void getnum()
    {
        for (int i = 0; i < news_list.Items.Count; i++) {
            Label lb = news_list.Items[i].FindControl("num") as Label;
            if (i.ToString().Length == 1)
            {
                lb.Text = "0" + (i+1);
            }
            else
            {
                lb.Text = (i+1).ToString() ;
            }
        }
    }

------------------------------------强制不缓存------------------
	Response.Buffer = true;
        Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1);
        Response.Expires = 0;
        Response.CacheControl = "no-cache";
        Response.AddHeader("Pragma", "No-Cache");

-------------------------过滤HTML-----------------------------------

    public string checkStr(string html)
    {
        System.Text.RegularExpressions.Regex regex1 = new System.Text.RegularExpressions.Regex(@"<script[\s\S]+</script *>",
System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex2 = new System.Text.RegularExpressions.Regex(@" href *= *[\s\S]*script *:",
System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex3 = new System.Text.RegularExpressions.Regex(@" no[\s\S]*=", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex4 = new System.Text.RegularExpressions.Regex(@"<iframe[\s\S]+</iframe *>",
System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex5 = new System.Text.RegularExpressions.Regex(@"<frameset[\s\S]+</frameset *>",
System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex6 = new System.Text.RegularExpressions.Regex(@"\<img[^\>]+\>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex7 = new System.Text.RegularExpressions.Regex(@"</p>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex8 = new System.Text.RegularExpressions.Regex(@"<p>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        System.Text.RegularExpressions.Regex regex9 = new System.Text.RegularExpressions.Regex(@"<[^>]*>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        html = regex1.Replace(html, ""); //过滤<script></script>标记 
        html = regex2.Replace(html, ""); //过滤href=javascript: (<A>) 属性 
        html = regex3.Replace(html, " _disibledevent="); //过滤其它控件的on...事件 
        html = regex4.Replace(html, ""); //过滤iframe 
        html = regex5.Replace(html, ""); //过滤frameset 
        html = regex6.Replace(html, ""); //过滤frameset 
        html = regex7.Replace(html, ""); //过滤frameset 
        html = regex8.Replace(html, ""); //过滤frameset 
        html = regex9.Replace(html, "");
        //html = html.Replace(" ", "");
        html = html.Replace("</strong>", "");
        html = html.Replace("<strong>", "");
        return html;
    }


---------------------------获取子分类--------------------------------
    protected string getchild(int id)
    {
        OleDbConnection conn = new OleDbConnection(DB.conn);
        conn.Open();
        string sql = "select * from cxy_clsC where clsid="+id;
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        OleDbDataReader dr = cmd.ExecuteReader();
        string idstr = "";
        while (dr.Read()) {
            idstr += dr["id"].ToString()+",";
        }
        if (idstr == "")
        {
            return "0";
        }
        else 
        { 
            return idstr;
        }
    }

--------------------------保存留言-----------------------------------
<script language="javascript">
function $(str){
	return document.getElementById(str);
	}
function check(){
	if($("name").value==""){
		alert("姓名不能为空");
		return false;
		}
	if($("telephone").value==""){
		alert("电话不能为空");
		return false;
		}
	if($("theme").value==""){
		alert("主题不能为空");
		return false;
		}
	if($("text").value==""){
		alert("内容不能为空");
		return false;
		}
	}
</script>

    protected void submit_Click(object sender, EventArgs e)
    {
        string name2 = name.Value;
        string company2 = company.Value;
        string area2 = site.Value;
        string tel2 = telephone.Value;
        string email2 = mail.Value;
        string address2 = address.Value;
        string title2 = theme.Value;
        string content2 = text.Value;

        string sql = "insert into cxy_MessageC (name,company,area,tel,email,address,title,content) values (@name,@company,@area,@tel,@email,@address,@title,@content)";
        OleDbConnection conn = new OleDbConnection(DB.conn);
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(sql,conn);
        cmd.Parameters.AddWithValue("@name",name2);
        cmd.Parameters.AddWithValue("@company", company2);
        cmd.Parameters.AddWithValue("@area", area2);
        cmd.Parameters.AddWithValue("@tel", tel2);
        cmd.Parameters.AddWithValue("@email", email2);
        cmd.Parameters.AddWithValue("@address", address2);
        cmd.Parameters.AddWithValue("@title", title2);
        cmd.Parameters.AddWithValue("@content", content2);
        try{
            cmd.ExecuteNonQuery();
        }catch(Exception ex){
            Response.Write("留言失败！错误信息：<br>"+ex.StackTrace);
            Response.End();
        }
        Response.Write("<script language='javascript'>");
        Response.Write("alert('留言成功！');");
        Response.Write("window.location.href='message.aspx';");
        Response.Write("</script>");
    }


---------------------------------------------------QQ在线交谈

<a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=XXXXXXXX&site=qq&menu=yes">



---------------------------------------------------------页面淡入淡出
<meta http-equiv="Page-Enter" content="blendTrans(duration=0.2,transition=5)" />

----------------------------------------------页面加载完成后弹出对话框
ScriptManager.RegisterStartupScript(this, this.GetType(), "OK", "alert('XXXXXX');", true);

-----------------------------------------------thickbox 效果需导入的文件
    <link href="css/thickbox.css" rel="stylesheet" type="text/css" />
    <script src="js/jquery.min.js" type="text/javascript"></script>
    <script src="js/jquery-ui.min.js" type="text/javascript"></script>
    <script src="js/thickbox.js" type="text/javascript"></script>

-------------------------------------------------ajax核心代码
<script language="javascript" type="text/javascript">
    //核心对象变量
    var xmlHttp;

    //区分浏览器创建XMLHttpRequest核心对象
    function create() {
        try {
            // Firefox, Opera 8.0+, Safari
            xmlHttp = new XMLHttpRequest();
        }
        catch (e) {
            try {
                // Internet Explorer
                xmlHttp = new ActiveXObject('Msxml2.XMLHTTP');
            }
            catch (e) {
                try {
                    xmlHttp = new ActiveXObject('Microsoft.XMLHTTP');
                }
                catch (e) {
                    alert('对不起，您的浏览器不支持AJAX，可能导致页面上某些内容显示不正确!');
                    return false;
                }
            }
        } 
    }

    //ajax核心执行方法（此处为提交到servlet处理后,返回纯文本）
    function run() {
        create();
        var value = document.getElementById("id").value;
        var URL = "Handler.ashx?id=" + value;
        xmlHttp.open("GET", URL, true);
        xmlHttp.onreadystatechange = callback;
        xmlHttp.send(null);
    }

    //回调函数
    function callback() {
        if (xmlHttp.readyState == 4) {
            if (xmlHttp.status == 200) {
                var v = xmlHttp.responseText;
                document.getElementById("titlebox").innerHTML = v;
            }
        }
    }
</script>

-------------------------添加IOS图标-------------------------
<link rel="apple-touch-icon-precomposed" href="images/iosLogo.jpg" />
<link rel="stylesheet" href="css/add2home.css" type="text/css" media="screen" />
<script src="js/add2home.js"></script>

------------------------------动态网页关键字--------------------------------
        HtmlMeta desc = new HtmlMeta();
        desc.Name = "Description";
        desc.Content = "我的网站描述";
        Page.Header.Controls.Add(desc);

        //Keyword网页关键字
        HtmlMeta keywords = new HtmlMeta();
        keywords.Name = "keywords";
        keywords.Content = "我的网站关键字";
        Page.Header.Controls.Add(keywords);