accessexplorer.cs

这是用C#数据库编程的实例

						myArrayList.Add(myTableName);
						//将模块名称增加到列表
					}
					myDataReader.Close();
					//关闭数据读取对象
					int iArrayCount= myArrayList.Count;
					//取得模块的数量
					TreeNode [] myTables=new TreeNode[iArrayCount];
					//建立节点数组
					myArrayList.CopyTo(myTables);
					//拷贝到节点数组
					TreeNode myTableNameNode=new TreeNode("Modules", myTables);
					//建立模块节点
					myRootNode.Nodes.Add(myTableNameNode);
					//增加模块节点到根节点					
				}//if
				treeView1.Nodes.Add(myRootNode);
				//将根结点增加到树控件			
			}//if
			else
			{
				MessageBox.Show("连接参数错误,重试！","连接错误");
				//如果链接失败反馈信息
			}
			return connectedFlag;
			//返回链接标志
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.treeView1 = new System.Windows.Forms.TreeView();
			this.contextMenu1 = new System.Windows.Forms.ContextMenu();
			this.listView1 = new System.Windows.Forms.ListView();
			this.SuspendLayout();
			// 
			// treeView1
			// 
			this.treeView1.Dock = System.Windows.Forms.DockStyle.Left;
			this.treeView1.ImageIndex = -1;
			this.treeView1.Name = "treeView1";
			this.treeView1.SelectedImageIndex = -1;
			this.treeView1.Size = new System.Drawing.Size(176, 317);
			this.treeView1.TabIndex = 0;
			this.treeView1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.treeView1_MouseDown);
			// 
			// listView1
			// 
			this.listView1.Dock = System.Windows.Forms.DockStyle.Fill;
			this.listView1.Location = new System.Drawing.Point(176, 0);
			this.listView1.Name = "listView1";
			this.listView1.Size = new System.Drawing.Size(296, 317);
			this.listView1.TabIndex = 1;
			// 
			// AccessExplorer
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(472, 317);
			this.Controls.AddRange(new System.Windows.Forms.Control[] {
																		  this.listView1,
																		  this.treeView1});
			this.Name = "AccessExplorer";
			this.Text = "Access查看器";
			this.Closing += new System.ComponentModel.CancelEventHandler(this.AccessExplorer_Closing);
			this.ResumeLayout(false);

		}
		#endregion

		private void AccessExplorer_Closing(object sender, System.ComponentModel.CancelEventArgs e)
		{
		
		}

		private void treeView1_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			//在树形目录上点击鼠标事件
			switch(e.Button)
			{
					//根据鼠标的按键的不同做到不同反应
				case MouseButtons.Left:
					//右键无反应
					break;
				case MouseButtons.Right:
					//左键
					TreeNode mySelectedNode =null;
					//定义一个节点变量
					mySelectedNode = treeView1.GetNodeAt(e.X, e.Y);
					//通过鼠标取得节点
					treeView1.SelectedNode = mySelectedNode;
					//设置节点
					if (mySelectedNode!=null )
					{
						//当节点非空时
						TreeNode myParentNode =mySelectedNode.Parent;
						//定义一个父节点
						if(myParentNode !=null)
						{
							//如果父节点非空
							if(myParentNode.Text.ToString() == "Tables")
							{
								//如果父节点的text为Tables
								ShowContextMenuForTable();
								//调用函数设置节点右键菜单
								treeView1.ContextMenu = contextMenu1;
								//取得节点菜单
							}
							else if(myParentNode.Text.ToString() == "Stored Procs")
							{	
								//如果父节点的text为Stored Procs
								treeView1.ContextMenu = contextMenu1;
								//取得菜单
							}
							else if(myParentNode.Text.ToString() == "Views")
							{
								//如果父节点的text为Views
								ShowContextMenuForTable();
								//设置菜单
								treeView1.ContextMenu = contextMenu1;
								//取得菜单
							}
							else
							{
								treeView1.ContextMenu =null;
								//否则清空菜单
								listView1.Clear();
								//清空列表
							}//if
						}
						else
						{
							treeView1.ContextMenu = null;
							//清空菜单
						}
						//检查父节点，如果是表则显示菜单						
					}//if
					break;
				case MouseButtons.Middle:
					//中键
					break;
				case MouseButtons.None:
					//无键
					break;
				default:
					break;
			}
		}
		private void ShowContextMenuForTable()
		{
			//设置菜单
			contextMenu1.MenuItems.Clear();
			//清空菜单项
			contextMenu1.MenuItems.Add("查看"
				,new System.EventHandler(this.OnPopupDetail));
			//增加菜单项和OnPopupDetail事件
		}
		public void OnPopupDetail(object sender
			, System.EventArgs e)
		{
			//增加自己的菜单项事件
			DataSet myDataSet =new DataSet();
			//定义DataSet对象
			if(treeView1.SelectedNode.Parent.Text.ToString() == "Views")
			{
				//当父节点为view+时
				myDataSet = myViewsData;
				//设置DataSet对象
			}
			else
			{
				myDataSet = myTableData;
				//设置DataSet对象
			}
			foreach(DataTable myTable in myDataSet.Tables)
			{
				//处理所有表
				int iFound=-1;
				iFound=myTable.TableName.IndexOf(
					treeView1.SelectedNode.Text.ToString(), 0);
				//取得表单的索引
				if(iFound >= 0)
				{
					//如果索引存在
					listView1.Clear();
					//清空列表
					listView1.View = View.Details;
					//设置listView1的查看属性
					ColumnHeader myColumnHeader =new ColumnHeader();
					//定义表单列的标题对象
					myColumnHeader.Text = "ColumnName";
					//设置标题
					listView1.Columns.Add(myColumnHeader);
					//增加列
					myColumnHeader = new ColumnHeader();
					//建立新列对象
					myColumnHeader.Text = "AutoIncrement";
					//设置列标题
					listView1.Columns.Add(myColumnHeader);
					//增加列
					myColumnHeader = new ColumnHeader();
					//建立新列
					myColumnHeader.Text = "DataType";
					//设置列标题
					listView1.Columns.Add(myColumnHeader);
					//增加列
					myColumnHeader = new ColumnHeader();
					//建立新列
					myColumnHeader.Text = "AllowNull";
					//设置列标题
					listView1.Columns.Add(myColumnHeader);
					//增加列
					myColumnHeader = new ColumnHeader();
					//建立新列
					myColumnHeader.Text = "Unique";
					//设置列标题
					listView1.Columns.Add(myColumnHeader);
					//增加列
					String [] myValues=new String[5];
					//定义取值得字符串数组
					foreach(DataColumn myColumn in myTable.Columns)
					{
						//对表单里面的每一个列对象进行操作
						myValues[0] = myColumn.ColumnName;
						//取得列的题目
						myValues[1] = myColumn.AutoIncrement.ToString();
						//取得列是否自动增加
						myValues[2] = myColumn.DataType.FullName.ToString();
						//取得是那种数据类型
						myValues[3] = myColumn.AllowDBNull.ToString();
						//是否是必添的
						myValues[4] = myColumn.Unique.ToString();
						//是否是唯一的
						ListViewItem myListItem=new ListViewItem(myValues);
						//定义一个列表项变量，并取得以上数组的值
						listView1.Items.Add(myListItem);
						//增加列表项
					}//foreach
				}//if
			}//foreach
		}
	}
}