userg1.cs

物业管理系统

			this.label3.BackColor = System.Drawing.Color.Transparent;
			this.label3.Location = new System.Drawing.Point(40, 87);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(56, 16);
			this.label3.TabIndex = 2;
			this.label3.Text = "密  码：";
			// 
			// label2
			// 
			this.label2.BackColor = System.Drawing.Color.Transparent;
			this.label2.Location = new System.Drawing.Point(40, 31);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(56, 16);
			this.label2.TabIndex = 1;
			this.label2.Text = "用户名：";
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(544, 80);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(152, 32);
			this.label1.TabIndex = 1;
			this.label1.Text = "label1";
			// 
			// userg1
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(480, 272);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.tabControl1);
			this.Name = "userg1";
			this.Text = "用户管理";
			this.Load += new System.EventHandler(this.userg1_Load);
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.panel1.ResumeLayout(false);
			this.tabPage2.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

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

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

		private void userg1_Load(object sender, System.EventArgs e)
		{
			string connstr,selectcmd;
			connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\\xqwy.mdb";
			selectcmd="select * from user1";
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();
			OleDbDataAdapter da=new OleDbDataAdapter(selectcmd,conn);
			//OleDbDataAdapter oleDbDataAdapter1=new OleDbDataAdapter(selectcmd,conn);
			DataSet ds=new DataSet();
	
			//DataSet dataSet1=new DataSet();
			da.Fill(ds);

			DataTable mytable=new DataTable();
			mytable=ds.Tables[0];

			//oleDbDataAdapter1.Fill(dataSet1);
			this.dataGrid1.DataSource=mytable;
			//conn.Close();
			try
			{
			
				//this.oleDbDataAdapter1.Fill(this.dataSet1,"user1");
				this.textBox2.DataBindings.Add("Text",mytable,"Name");
				this.textBox3.DataBindings.Add("Text",mytable,"Passwd");
		
				this.MyBind=this.dataGrid1.BindingContext[mytable];

				this.dataGrid1.Select(0);
			}
			catch(Exception Err)
			{
				MessageBox.Show("打开数据库表错误："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}	
		}

		private void button8_Click(object sender, System.EventArgs e)
		{
			//第一条记录
			this.dataGrid1.UnSelect(MyBind.Position);
			this.MyBind.Position=0;
			this.dataGrid1.Select(MyBind.Position);
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			//前一条记录
			if(this.MyBind.Position==0)
			{
				MessageBox.Show("已经是第一条记录","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			else
			{
				this.dataGrid1.UnSelect(MyBind.Position);
				this.MyBind.Position--;
				this.dataGrid1.Select(MyBind.Position);

			}
		}

		private void button6_Click(object sender, System.EventArgs e)
		{
			//后一条记录
			if(this.MyBind.Position==this.MyBind.Count-1)
			{
				MessageBox.Show("已经是末一条记录","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			else
			{
				this.dataGrid1.UnSelect(MyBind.Position);
				this.MyBind.Position++;
				this.dataGrid1.Select(MyBind.Position);
				this.label1.Text=MyBind.Count.ToString();

			}
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			//末一条记录
			this.dataGrid1.UnSelect(MyBind.Position);
			
			this.MyBind.Position=this.MyBind.Count-1;
			
			
			this.dataGrid1.Select(this.MyBind.Position);
		}

		private void button4_Click(object sender, System.EventArgs e)
		{
			//新建记录
		
			
		}

		private void button18_Click(object sender, System.EventArgs e)
		{
		
			this.MyBind.Position=0;
		}

		private void button17_Click(object sender, System.EventArgs e)
		{
		
			this.MyBind.Position--;
		}

		private void button16_Click(object sender, System.EventArgs e)
		{
			this.MyBind.Position++;
		}

		private void button15_Click(object sender, System.EventArgs e)
		{
			this.MyBind.Position=this.MyBind.Count-1;
		
		}

		private void button14_Click(object sender, System.EventArgs e)
		{
			this.textBox2.Text="";
			this.textBox3.Text="";
		}

		private void button13_Click(object sender, System.EventArgs e)
		{
			//增加记录
			if(this.textBox2.Text.Length<1|this.textBox3.Text.Length<1)
			{
				MessageBox.Show("客户所有信息必须填写！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			try
			{
				string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\\xqwy.mdb";
				OleDbConnection conn=new OleDbConnection(connstr);
				conn.Open();
				string StrSQL="INSERT INTO user1(Name,Passwd)VALUES('"+this.textBox2.Text.Trim()+"','"+this.textBox3.Text.Trim()+"')";	
				
				//sring strsql="select * from***"

				/*OleDbDataAdapter da1=new OleDbDataAdapter(StrSQL,conn);
				DataSet ds1=new DataSet();
				da1.Fill(ds1);

				DataTable mytable1=new DataTable();
				
				DataRow newrow=myatble.newrow()
				newrow[0=
				
				mytable[1,2]
				
				mytable.add(datarow)
				mytable1=ds1.Tables[0];
				OleDbCommandBuilder cmdbld1=new OleDbCommandBuilder(da1);*/

				OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
				cmd.ExecuteNonQuery();


				//da1.Update(mytable1);
			
				
				MessageBox.Show("增加数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			catch(Exception Err)
			{
				MessageBox.Show("增加数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
		
			}		
		}

		private void panel1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
		{
		
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void button11_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void button12_Click(object sender, System.EventArgs e)
		{
			//修改记录
			try
			{
				
				OleDbConnection conn2=new OleDbConnection(@"provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+ "\\xqwy.mdb");
				conn2.Open();

				string strsql="select * from user1 where name='"+this.textBox2.Text.Trim()+"' ";

				OleDbDataAdapter da=new OleDbDataAdapter(strsql,conn2);

				DataSet ds=new DataSet();
				da.Fill(ds);

				DataTable mytable=new DataTable();
				mytable=ds.Tables[0];
	
			
					DataRow row1;
					row1=mytable.Rows[0];
					row1[0]=this.textBox2.Text.Trim();
					row1[1]=this.textBox3.Text.Trim();

					OleDbCommandBuilder cmdbld=new OleDbCommandBuilder(da);

					da.Update(mytable);
					MessageBox.Show("密码修改成功！");


				conn2.Close();
			}
			catch(Exception err)
			{
				MessageBox.Show(err.Message);
			}

		}

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

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

		private void button19_Click(object sender, System.EventArgs e)
		{
			
				try
				{
					string connstr="Provider=Microsoft.jet.oledb.4.0;data source="+Application.StartupPath+"\\xqwy.mdb";
					OleDbConnection conn=new OleDbConnection(connstr);
					conn.Open();
					string StrSQL="DELETE FROM  user1 WHERE ";
					StrSQL+=" Name='"+this.textBox2.Text+"'";	
					//"delete from user1 where( "Name="'"+this.textBox2.Text.Trim()+"','"+this.textBox3.Text.Trim()+"')";	
					//string StrSQL="DELETE FROM  user1 WHERE(Name='"+this.textBox2.Text.Trim()+"'and Passwd='"+this.textBox3.Text.Trim()+"')";
					//StrSQL+="Name='"+this.textBox2.Text.Trim()+"'";	
					//StrSQL+="Passwd='"+this.textBox3.Text.Trim()+"'";
				
					OleDbCommand cmd=new OleDbCommand(StrSQL,conn);
					cmd.ExecuteNonQuery();

			
				
					MessageBox.Show("删除数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				}
				catch(Exception Err)
				{
					MessageBox.Show("删除数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
		
				}	
				
				
		}
	}
}