friends_modi.aspx.cs

尚都shangdu新闻后台管理程序,可做各种网站新闻发布

using System;
using System.IO;
using System.Text.RegularExpressions;
using System.Data;
using System.Runtime;
using System.Data.SqlClient;
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_friends_modi : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["shang_admin"] == null)
        {
            Response.Redirect("get_your_passport.aspx");
        }
        if (!IsPostBack)
        {
            SqlConnection con = db.CreateConnection();
            con.Open();
            string strsql = "select * from friends where bh='" + Request.QueryString["bh"] + "'";
            SqlCommand cmd = new SqlCommand(strsql, con);
            SqlDataAdapter ad = new SqlDataAdapter(strsql, con);
            DataSet ds = new DataSet();
            ad.Fill(ds, "aa");
            TextBox1.Text = ds.Tables["aa"].Rows[0]["lianjie_name"].ToString();
            TextBox2.Text = ds.Tables["aa"].Rows[0]["lianjie_infor"].ToString();
            TextBox3.Text = ds.Tables["aa"].Rows[0]["lianjie_url"].ToString();
            TextBox4.Text = ds.Tables["aa"].Rows[0]["lianjie_pic"].ToString();
            TextBox5.Text = ds.Tables["aa"].Rows[0]["bh"].ToString();
            con.Close();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = db.CreateConnection();
        con.Open();
        string strsql = "update friends set lianjie_name='"+TextBox1.Text+"',lianjie_infor='"+TextBox2.Text+"',lianjie_url='"+TextBox3.Text+"',lianjie_pic='"+TextBox4.Text+"' where bh='"+TextBox5.Text+"'";
        SqlCommand cmd = new SqlCommand(strsql, con);
        cmd.ExecuteNonQuery();
        con.Close();
        Response.Redirect("friends_manage.aspx");
    }
}