index.aspx.cs

采用C＃.NET2008与SQL SERVER的社区网站

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.Configuration;
using System.Data.SqlClient;

namespace Aspnet
{
	/// <summary>
	/// Index 的摘要说明。
	/// </summary>
	public class Index : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Button BT_cancel;
		protected System.Web.UI.WebControls.Button BT_Submit;
		protected System.Web.UI.WebControls.RadioButtonList RBL_type;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox TB_pwd;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TB_name;
		protected System.Web.UI.WebControls.DataGrid dg1;
		protected System.Web.UI.WebControls.DataGrid dg3;
		protected System.Web.UI.WebControls.DataGrid dg2;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				BindData();
				Binding();
			}// 在此处放置用户代码以初始化页面
			
		}
		private void BindData()
		{
			string strConn="server=.;database=Aspnet;uid=sa;pwd=sa;";
			SqlConnection myConn = new SqlConnection(strConn);
			string strCom;
			
			strCom = "select TOP 3 title from article where  articleid > 0 and classid = 42 " ;
			SqlCommand cmd = new SqlCommand(strCom,myConn);
			myConn.Open();
			SqlDataReader forumReader = cmd.ExecuteReader();
			forumReader.Close();
			forumReader = cmd.ExecuteReader();
			dg1.DataSource = forumReader;
			dg1.DataBind();
			myConn.Close();
			
		}
		private void Binding()
		{
			
		
			string ConnString = "server=.;uid=sa;pwd=sa;database=Aspnet";
			SqlConnection conn=new SqlConnection(ConnString);
			DataSet ds = new DataSet();
			DataView dv = new DataView();
			conn.Open();
			string SelectString="select TOP 3 title from article where  articleid > 0 and classid = 34 order by article.addtime DESC";
			SqlDataAdapter da = new SqlDataAdapter(SelectString,conn);
			da.Fill(ds,"article");
			dv = ds.Tables["article"].DefaultView;
			dg2.DataSource = dv;
			dg2.DataBind();
///////////////////////////////////////////////////////
			SelectString="select TOP 5 title from article where  articleid > 0 and classid = 36 order by article.addtime DESC";
			conn=new SqlConnection(ConnString);
			ds = new DataSet();
			dv = new DataView();
			da = new SqlDataAdapter(SelectString,conn);
			da.Fill(ds,"article");
			dv = ds.Tables["article"].DefaultView;
			dg3.DataSource = dv;
			dg3.DataBind();
			conn.Close();

		}
		

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

		}
		#endregion
	

		private void BT_Submit_Click(object sender, System.EventArgs e)
		{
			string strconn="server=.;database=Aspnet;uid=sa;pwd=sa";//连接字符串
			string selectstr;
			SqlConnection Conn=new SqlConnection(strconn);
			if(RBL_type.SelectedItem.Value.ToString()=="个人")
			{
				selectstr="select count(*) from UserInfo where UserName like '"+TB_name.Text+"' and Pwd like '"+TB_pwd.Text+"'";
			}
			else
			{
				selectstr="select count(*) from AdminInfo where AdminID like '"+TB_name.Text+"' and AdminPwd like '"+TB_pwd.Text+"'";
			}
			Session["type"]=RBL_type.SelectedItem.Value.ToString();
			SqlCommand mycommand=new SqlCommand(selectstr,Conn);
			Conn.Open();//打开数据库连接
			int flag=(int)mycommand.ExecuteScalar();
			Conn.Close();
			if(flag>0)//用户存在
			{
				Session["UserName"]=TB_name.Text;
				Response.Redirect("Review.aspx");//("../sysconfig/Viewmessage.aspx");
				TB_name.Text="";
				TB_pwd.Text="";
			}
			else
			{
				Response.Write("<script>alert('用户名或密码错误,请重新登录！')</script>");
				TB_name.Text="";
				TB_pwd.Text="";
			}
		}

		private void BT_cancel_Click(object sender, System.EventArgs e)
		{
			TB_name.Text="";
			Response.Redirect("Review.aspx");
		}
		/*private void dgTopic_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			this.dgTopic.CurrentPageIndex=e.NewPageIndex;
			this.BindData();
		}*/
		private void dgTopic_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
			{
				((LinkButton)e.Item.Cells[3].Controls[0]).Attributes.Add("onClick","return confirm('真的你要删除吗?');");
			}
		}
		
	
	}
}