userinfo.aspx.cs

数据绑定采用GridView控件

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.OleDb;
public partial class admin_UserInfo : System.Web.UI.Page
{
    OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
    DataBase db = new DataBase();
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!this.Page.IsPostBack)
        {
            this.ShowUser();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int hideid=1;
        int replyid=0;
        int orderid = 1;
        string adminreply=this.adminreply.Text.Trim();
        if (!this.RadioButton1.Checked)
        {
            hideid = 0;
        }
        if (this.adminreply.Text == String.Empty)
        {
            replyid = 0;
        }
        else 
        {
            replyid = 1;
        }
        if (RadioButton3.Checked)
        {
            orderid = 2;
        }
        else 
        {
            orderid = 1;
        }
        string sql = "update message set hideid="+hideid+",replyid="+replyid+",orderid="+orderid+",adminreply='"+adminreply+"' ";
        sql+="where id="+Request.QueryString["id"].ToString();
        if (db.ExecSQl(sql))
        {
            OleDbCommand comm = new OleDbCommand(sql, conn);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
            //bc.MessageBoxs("回复留言成功！");
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('回复留言成功！');</script>");  
            
        }
        else 
        {
           // bc.MessageBoxs("回复留言失败！");
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('回复留言失败！');</script>");  
            
        }
       
    }
    private void ShowUser() 
    {
        string id = Request.QueryString["id"].ToString();
        if (id == "" || id == null) 
        {
            id = "1";
        }
        string sql ="select * from message where id="+id;
        DataSet ds =db.GetDataSet(sql,"a");
        DataRowView rv=ds.Tables["a"].DefaultView[0];
        this.username.Text = rv["username"].ToString();
        this.msgtime.Text = rv["addtime"].ToString();
        this.userip.Text = rv["userip"].ToString();
        this.usercontent.Text = rv["usercontent"].ToString();
        this.adminreply.Text = rv["adminreply"].ToString();
    }
}