screch.aspx.cs

基于JSP+SQL Sever2000+Tomcat的网络服务器体系结构开发技术和对数据库技术的进一步了解以及对政府网站的调查研究

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();
        }
        
    }
}