screch.aspx.cs

来自「基于JSP+SQL Sever2000+Tomcat的网络服务器体系结构开发技术」· CS 代码 · 共 52 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class screch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fill();
        }
    }
    public void fill()
    {
        string sql = Request.QueryString["sql"];
        string whe = Request.QueryString["key"];

        string que = "";
        switch (sql)
        {
            case "name":
               　que += ("select * from guest where name like '%" + whe + "%' order by id Desc");
                break;
            case "title":
                que += ("select * from guest where title like '%" + whe + "%' order by id Desc");
                break;
            case "concent":
                que += ("select * from guest where concent like '%" + whe + "%' order by id Desc");
                break;
        }

        if ((odb.ds(que)).Rows.Count <= 0)
        {
            Response.Write("未找到你想要的，<a href=javascript:history.back()>返回</a>重新来过吧！");
        }
        else
        {
            GridView1.DataSource = odb.ds(que);
            GridView1.DataBind();
        }
        
    }
}