viewmessage.aspx.cs

留言板得源代码 是初学网络的较好代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace Aspnet
{
	/// <summary>
	/// Viewmessage 的摘要说明。
	/// </summary>
	public class Viewmessage : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label label1;
		protected System.Web.UI.WebControls.DataGrid DG_message;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(System.DateTime.Now.Hour>=5&&System.DateTime.Now.Hour<=12)
			{
				label1.Text="朋友上午好，欢迎光临留言板.NET！ ";
			} 
			else if(System.DateTime.Now.Hour>=12&&System.DateTime.Now.Hour<=18)
			{
				label1.Text="朋友下午好，欢迎光临留言板.NET！";
			}
			else if(System.DateTime.Now.Hour>=18&&System.DateTime.Now.Hour<=24)
			{
				label1.Text="朋友晚上好，欢迎光临留言板.NET！";
			}
			else
			{
				label1.Text="朋友，这么晚还光临留言板，太感动了！";
			}
        

			//检查该页面是否第一次被装载
			if(!IsPostBack)
			{
				//使用 Binding 的方法
				Binding() ;
			}
			if(Session["type"].ToString()=="普通用户")//如果是普通用户登录，不具有删除的权限
			{
				DG_message.Columns[5].Visible=false;
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DG_message.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DG_message_PageIndexChanged);
			this.DG_message.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DG_message_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		
		private void Binding()
		{
			//数据库的连接字符串
			string strConn="server=localhost;database=Aspnet;uid=sj;pwd=;";
			//生成一个新的连接
			SqlConnection myConn = new SqlConnection(strConn) ;
			string strCom;		
			strCom = "SELECT postid ,Subject ,Newpost.UserName ,Newpost.RegTime,WebSite,Email FROM Newpost,UserInfo where Newpost.UserName=UserInfo.UserName and parentid=0  ORDER BY Newpost.RegTime DESC";			
			SqlCommand forumCommand = new SqlCommand(strCom, myConn);
			myConn.Open();
			SqlDataAdapter da=new SqlDataAdapter(strCom, myConn);
			DataSet ds=new DataSet();
			da.Fill(ds,"newpost");//填充数据源
			DG_message.DataSource=ds;//设置DG_message的数据源	
			//数据绑定
			DG_message.DataBind();
			myConn.Close();
		}

		private void DG_message_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DG_message.CurrentPageIndex=e.NewPageIndex;
			Binding();
		}

		private void DG_message_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//该函数处理DataGrid删除事件
			//获取删除参数
			string thisID = DG_message.DataKeys[e.Item.ItemIndex].ToString();
			//连接数据库
			string ConnStr = "server=localhost;database=Aspnet;uid=sj;pwd=";			
			SqlConnection conn = new SqlConnection(ConnStr);
			conn.Open();
			//删除
			string deletestring = "delete Newpost where PostID = '"+thisID+"'";
			SqlCommand sc = new SqlCommand(deletestring,conn);
			sc.ExecuteNonQuery();
			//关闭连接，释放资源
			conn.Close();
			conn.Dispose();
			sc.Dispose();
			//重新绑定DataGrid
			Binding();
		}



	}
}