info_re.aspx.cs

一个简单的聊天代码

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 admin_info : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            popol();
            if (Request.QueryString["id"] != null)
            { shanchu(); }
          
        }
    }
    void popol()
    {  string sql;
        sql = "select * from Spclass";
        {
            sql = "select *,(select name from Spclass where id= Info.sort) as SortName  from Info order by id desc";
        }
        DataSet ds = Spbase.GreatDs(sql);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        DataTable dt = Spbase.GreatDs("Select * from Spclass").Tables[0];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            ListItem Dr = new ListItem(dt.Rows[i]["name"].ToString(), dt.Rows[i][0].ToString());
            DropDownList1.Items.Add(Dr);
        } 
    }
    void shanchu()
    {
        string sid, sql;
        sid = Request.QueryString["id"];
        sql = "delete from info where id=" + sid;
        Spbase.DoSql(sql);
        Sp.MessageBox.Show(this.Page, "成功删除！");
        popol();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string gjz,lb;
        gjz = spstr.tosql(TextBox_gjz.Text);
        lb=DropDownList1.SelectedValue;
        
        string sql;
        sql = "select * from Spclass";
        if (gjz== null && lb == null)
        {
            sql = "select *,(select name from Spclass where id= Info.sort) as SortName  from Info order by id desc";
        }
        else if (gjz!= null || lb != null)
        {
            sql = "select *,(select name from Spclass where id= Info.sort) as SortName from Info where sort =" + lb + " and title like '%" + gjz + "%'";
        }    


        DataSet ds = Spbase.GreatDs(sql);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
        popol(); 
    }
}