newsmanage.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 newsmanage : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["news_manageConnectionString"].ConnectionString);
    SqlCommand cmd;
    SqlDataAdapter Data;
    DataSet ds1 = new DataSet();
    int key;
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    protected void btnCheck_Click(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
    }
    //GridView1_RowCommand删除代码
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "del")
        {
            key = Convert.ToInt32(GridView1.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text);
            string str = "delete from t_news where newsid = " + key + "";       
            cmd = new SqlCommand(str, conn); 
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            this.GridView1.DataBind();
        }

    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //只有数据项才高亮显示
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#8899ff'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
        }
    }
}