usermanage.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;
using System.Data.SqlClient;

public partial class UserInfo_FindUserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        
        if (e.Row.DataItemIndex == -1)
        {
            return;
        }
        else
        {

            e.Row.Attributes.Add("onmouseover", "this.style.cursor='hand';this.originalcolor=this.style.backgroundColor; this.style.backgroundColor='Silver';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalcolor;");

            e.Row.Cells[4].Text = "<a href=PopedomManage.aspx?UserID=" + DataBinder.Eval(e.Row.DataItem, "USERID") + " ><img src='../Image/qx.gif'></img></a>";
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GridView1.DataSourceID = "";

        if (DropDownList1.SelectedItem.Value == "all")
        {

            SqlConnection con = DataAccess.CreateConnection();
            con.Open();
            string str = "select *from t_News_User";
            SqlDataAdapter sda = new SqlDataAdapter(str, con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "t_News_User");
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
        }
        else
        {
            SqlConnection con = DataAccess.CreateConnection();
            con.Open();
            string str = "select *from t_News_User where USERID='" + DropDownList1.SelectedItem.Value + "'";
            SqlDataAdapter sda = new SqlDataAdapter(str, con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "t_News_User");
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
        }
    }
    protected void Button2_Click1(object sender, EventArgs e)
    {
        //string strpubname=((TextBox)e.Item.Cells[1].Controls[0]) .Text;
        //SqlConnection con = DataAccess.CreateConnection();
        //con.Open();
        //string str = "update t_News_User set userpassword='111111'where userid="+GridView1.;
        //SqlCommand com = new SqlCommand(str, con);
        //com.ExecuteNonQuery();
    }
}