netQT/SelectMessage.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;
using CommonLib;
using DBUtility;
public partial class SelectMessage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
          
            string str;
            str = Request.QueryString["id"].ToString();
            SqlConnection conn = new DBCon().getCon();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection =conn;
            cmd.CommandText = "select *from T_Message where id='"+str+"'";
            SqlDataReader dr = cmd.ExecuteReader();
            DataList1.DataSource = dr;
            DataList1.DataBind();


        }
    }
   
   
    protected void Button1_Command(object sender, CommandEventArgs e)
    {
        
    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "del")
        {
            string abc = "delete from  T_Message where id =" + e.CommandArgument.ToString();
            new DBExec().execSqlQry(abc);
            DBUtility.SqlHelper.BindDataList(DataList1, SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, "select *from T_Message", null);
            
        }
      
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Panel1.Visible=!Panel1.Visible;
        Label10.Text = TextBox1.Text;
    }
}