yhgf.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 gswz
{
	/// <summary>
	/// yhgf 的摘要说明。
	/// </summary>
	public class yhgf : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		protected System.Data.SqlClient.SqlConnection sqlConnection1;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		protected gswz.DataSet1 dataSet11;
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
				this.sqlConnection1.Open();
				this.sqlDataAdapter1.Fill(this.dataSet11);
				this.sqlConnection1.Close();
				this.DataGrid1.DataSource=this.dataSet11;
				this.DataGrid1.DataBind();
				this.sqlConnection1.Open();
				this.sqlDataAdapter1.Fill(this.dataSet11);
				this.sqlConnection1.Close();
				this.DataGrid2.DataSource=this.dataSet11;
				this.DataGrid2.DataBind();
			}
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.dataSet11 = new gswz.DataSet1();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			this.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid2_PageIndexChanged);
			this.DataGrid2.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid2_CancelCommand);
			this.DataGrid2.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid2_EditCommand);
			this.DataGrid2.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid2_UpdateCommand);
			this.DataGrid2.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid2_DeleteCommand);
			this.DataGrid2.SelectedIndexChanged += new System.EventHandler(this.DataGrid2_SelectedIndexChanged);
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT id, userName, passsword FROM [user]";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO [user] (userName, passsword) VALUES (@userName, @passsword); SELECT i" +
				"d, userName, passsword FROM [user] WHERE (id = @@IDENTITY)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@userName", System.Data.SqlDbType.VarChar, 10, "userName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@passsword", System.Data.SqlDbType.VarChar, 10, "passsword"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = "UPDATE [user] SET userName = @userName, passsword = @passsword WHERE (id = @Origi" +
				"nal_id) AND (passsword = @Original_passsword) AND (userName = @Original_userName" +
				"); SELECT id, userName, passsword FROM [user] WHERE (id = @id)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@userName", System.Data.SqlDbType.VarChar, 10, "userName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@passsword", System.Data.SqlDbType.VarChar, 10, "passsword"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_passsword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "passsword", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_userName", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "userName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = "DELETE FROM [user] WHERE (id = @Original_id) AND (passsword = @Original_passsword" +
				") AND (userName = @Original_userName)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_passsword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "passsword", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_userName", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "userName", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=\"W3-24\";packet size=4096;user id=sa;data source=\"(local)\";persist " +
				"security info=False;initial catalog=login";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "user", new System.Data.Common.DataColumnMapping[] {
																																																			  new System.Data.Common.DataColumnMapping("id", "id"),
																																																			  new System.Data.Common.DataColumnMapping("userName", "userName"),
																																																			  new System.Data.Common.DataColumnMapping("passsword", "passsword")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();

		}
		#endregion

		private void DataGrid2_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.DataGrid2.EditItemIndex=-1;
			this.sqlConnection1.Open();
			this.sqlDataAdapter1.Fill(this.dataSet11);
			this.DataGrid2.DataSource=this.dataSet11;
			this.DataGrid2.DataBind();
			this.sqlConnection1.Close();
		}

		private void DataGrid2_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string xh=e.Item.Cells[0].Text.Trim();
			SqlCommand mySqlCommand=new SqlCommand();
			mySqlCommand.Connection=this.sqlConnection1;
			mySqlCommand.CommandText="delete from [user] where id='"+xh+"'";
			this.sqlConnection1.Open();
			mySqlCommand.ExecuteNonQuery();
			this.sqlConnection1.Close();
			this.sqlConnection1.Open();
			this.sqlDataAdapter1.Fill(this.dataSet11);
			this.sqlConnection1.Close();
			this.DataGrid2.DataSource=this.dataSet11;
			this.DataGrid2.DataBind();
		}

		private void DataGrid2_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			
			this.DataGrid2.EditItemIndex=e.Item.ItemIndex;
			this.sqlConnection1.Open();
			this.sqlDataAdapter1.Fill(this.dataSet11);
			this.DataGrid2.DataSource=this.dataSet11;
			this.DataGrid2.DataBind();
			this.sqlConnection1.Close();
		}

		private void DataGrid2_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string xh=e.Item.Cells[0].Text;
			SqlCommand mySqlCommand=new SqlCommand();
			mySqlCommand.Connection=this.sqlConnection1;
			mySqlCommand.CommandText="update [user] set username='"+((TextBox)e.Item.Cells[1].Controls[0]) .Text+"',passsword='"+((TextBox)e.Item.Cells[2].Controls[0]) .Text+"' where id='"+xh+"'";
			this.sqlConnection1.Open();
			mySqlCommand.ExecuteNonQuery();
			this.sqlConnection1.Close();
			this.sqlDataAdapter1.Fill(this.dataSet11);
			this.DataGrid2.EditItemIndex=-1;
			this.DataGrid2.DataSource=this.dataSet11;
			this.DataGrid2.DataBind();
			
		}

		private void DataGrid2_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			this.DataGrid2.CurrentPageIndex=e.NewPageIndex;
			this.sqlConnection1.Open();
			this.sqlDataAdapter1.Fill(this.dataSet11);
			this.DataGrid2.DataSource=this.dataSet11;
			this.DataGrid2.DataBind();
			this.sqlConnection1.Close();
		}

		private void DataGrid2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

	}
}