ucontrol.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 bbs
{
	/// <summary>
	/// UControl 的摘要说明。
	/// </summary>
	public class UControl : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.DataList DataList1;
		protected System.Web.UI.WebControls.LinkButton LinkButton11;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.RadioButtonList RBL_sSex;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox TextBox_sQuestion;
		protected System.Web.UI.WebControls.TextBox TextBox_sAnswer;
		protected System.Web.UI.WebControls.TextBox TextBox_semail;
		protected System.Data.SqlClient.SqlDataReader dr;
		protected System.Web.UI.WebControls.LinkButton LinkButton_update;
		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			this.Panel1.Visible=false;

			if(Session["username"]==null || Session["username"].ToString()=="")
			{
				Response.Redirect("error.aspx");
			}
			else
			{
				this.Label1.Text=Session["iUserID"].ToString();
				this.Label2.Text=Session["UserName"].ToString();
			
			}
				


				if(!Page.IsPostBack)
				{
					this.MyDataBind();
					this.MyFaceDataBind();
				}

				

			// 在此处放置用户代码以初始化页面
		}
		private void MyDataBind()
		{
		
			string userid=Session["userid"].ToString();	
			string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(ConnectionString);
	
			conn.Open();

		
			string sql="select * from users where iUserID='"+userid+"'";		
			SqlCommand cmd=new SqlCommand(sql,conn);

			dr=cmd.ExecuteReader();
			dr.Read();
			try
			{
								
				if(dr["sSex"].ToString().Trim()!=null ||dr["sSex"].ToString().Trim()!="")
				{
					if(dr["sSex"].ToString().Trim()=="男")
						this.RBL_sSex.Items[1].Selected=true;
					else if(dr["sSex"].ToString().Trim()=="女")
						this.RBL_sSex.Items[0].Selected=true;
					
				}
				else
				{
					
					this.RBL_sSex.Items[0].Selected=false;
					this.RBL_sSex.Items[1].Selected=false;
				}
				this.TextBox_semail.Text=dr["semail"].ToString();
																					
			 }
		
			catch(Exception ex)
			{	
				Response.Write(ex.Message);
				conn.Close();
			}
			finally
			{		
				conn.Close();
				conn.Dispose();
				conn=null;
			}

			string sqlstr="select * from users where iUserID='"+userid+"'";
			da.da d=new da.da();
			DataSet ds=d.Select(sqlstr,"tbUsers");
			this.DataGrid1.DataSource=ds;
			this.DataGrid1.DataBind();

		}
		private void MyFaceDataBind()
		{
		
			string sqlstr = "select * from tbface";
			da.da d=new da.da();
			DataSet ds=d.Select(sqlstr,"tbface");
			this.DataList1.DataSource=ds;
			this.DataList1.DataBind();
		
		}
		protected string GetFace(object face)
		{			
			if(face!= null && face.ToString() != "")
			{
				return @"<img src="""+face.ToString() + @""" width=""100"" height=""100"" border=""0""/>";
			}
			else
			{
				return "&nbsp;";
			}
		}
		protected string GetRB(object face)
		{
			if (face != null && face.ToString() != "")
			{
				return @"<INPUT type=""radio"" value="""+ face.ToString() +@""" name=""MyRB"">";
			}
			else
			{
				return "";
			}
		}

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

		}
		#endregion

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			switch (e.CommandName)
			{
				case "MyImageEdit":
					this.Panel1.Visible = true;	
					this.MyFaceDataBind();
					break;				
			}
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			
			try
			{
				string userid=Session["userid"].ToString();	
				string sqlstr="select * from users where iUserID='"+userid+"'";
				string sqlstr2="update users set sSex='"+this.RBL_sSex.SelectedItem.Value.ToString()+"', semail='"+this.TextBox_semail.Text+"',sBbsquestion='"+this.TextBox_sQuestion.Text+"',sBbsAnswer='"+this.TextBox_sAnswer.Text+"' where iUserID='"+userid+"'";
				da.da ut=new da.da();
				ut.command(sqlstr2);
				this.MyDataBind();
				Response.Write("<script>alert('恭喜：***资料修改成功！')</script>");
			}
			
			
			catch
			{
				Response.Write("<script>alert('错误：***资料修改失败！')</script>");
			}
		}

		private void LinkButton10_Click(object sender, System.EventArgs e)
		{
			
				string userid=Session["userid"].ToString();	
				string sFace=Request["MyRB"].ToString();
				string sqlstr = "update users set face = '"+ sFace +"' where iUserID ='"+userid+"'";
				da.da d=new da.da();
				d.command(sqlstr);
				this.MyDataBind();
				this.Panel1.Visible = false;

		}

	
	}
}