shfcxx.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class shfcxx : System.Web.UI.Page
{
    SqlConnection conn = DB.getcon();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Bind();

    }
    public void Bind()
    {
        SqlConnection con = DB.getcon();
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter("select   * from house where ID=" + Request.QueryString["id"], con);
        sda.Fill(ds, "mclass");
        this.XRepeater.DataSource = ds.Tables["mclass"].DefaultView;
        this.XRepeater.DataBind();

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Button1.Enabled = true;
        SqlConnection conn = DB.createCon();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = "update  house set sp='1'where ID=" + Request.QueryString["id"];
        if (cmd.ExecuteNonQuery() > 0)
        {
            Response.Write("<script>alert('审核成功！');</script>");
        }
        else
        {
            Response.Write("<script>alert('审核失败！');</script>");
        }
        conn.Close();
        Button1.Text = "已审核";
        Button1.Enabled = false;

    }
    protected void XRepeater_ItemCommand(object source, RepeaterCommandEventArgs e)
    {

    }
}