form1.cs

Winform_理论部分 Wi培训机构的案例的理论部分

using System ; 
using System.Windows.Forms ; 
using System.Drawing ; 
using System.Data ; 
using System.Data.OleDb ; 
class MainForm : Form 
{ // 定义数据连接的字符串 
	private static string strConnect = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + 
		Application.StartupPath + "\\DB_ListViw.mdb" ; 
	private OleDbConnection objConnection = new OleDbConnection ( strConnect ) ;
	private System.Windows.Forms.Button cmdChangeView;
	private System.Windows.Forms.ListView lvPerson;

	
	public MainForm ( ) 
	{ 
	
		InitializeComponent();
		
		// 关闭Form的时候，同时也关闭数据连接 
		this.Closed+=new EventHandler ( this_Closed ) ; 
	} 
	protected void this_Closed ( object sender , EventArgs eArgs ) 
	{ 
		this.objConnection.Close ( ) ;//关闭数据连接 
	} 
	public static void Main ( ) 
	{ 
		Application.Run ( new MainForm ( ) ) ; 		
	}

	private void InitializeComponent()
	{
		this.cmdChangeView = new System.Windows.Forms.Button();
		this.lvPerson = new System.Windows.Forms.ListView();
		this.SuspendLayout();
		// 
		// cmdChangeView
		// 
		this.cmdChangeView.Location = new System.Drawing.Point(184, 0);
		this.cmdChangeView.Name = "cmdChangeView";
		this.cmdChangeView.TabIndex = 0;
		this.cmdChangeView.Text = "列表显示";
		this.cmdChangeView.Click += new System.EventHandler(this.cmdChangeView_Click);
		// 
		// lvPerson
		// 
		this.lvPerson.Location = new System.Drawing.Point(8, 32);
		this.lvPerson.Name = "lvPerson";
		this.lvPerson.Size = new System.Drawing.Size(448, 232);
		this.lvPerson.TabIndex = 1;
		this.lvPerson.View = System.Windows.Forms.View.Details;
		// 
		// MainForm
		// 
		this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
		this.ClientSize = new System.Drawing.Size(496, 317);
		this.Controls.Add(this.lvPerson);
		this.Controls.Add(this.cmdChangeView);
		this.Name = "MainForm";
		this.Text = "在ListView中显示数据库内容!";
		this.Load += new System.EventHandler(this.MainForm_Load);
		this.ResumeLayout(false);

	}

	private void FillColumn()
	{
		// 针对数据库的字段名称，建立与之适应显示表头 
		lvPerson.Columns.Add ( "姓名" , 60 , HorizontalAlignment.Right ) ; 
		lvPerson.Columns.Add ( "住宅电话" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Columns.Add ( "办公电话" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Columns.Add ( "移动电话" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Columns.Add ( "居住地点" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Columns.Add ( "工作单位" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Columns.Add ( "电子邮件" , 100 , HorizontalAlignment.Left ) ; 
		lvPerson.Visible = true ; 
		

	
	}
	private void FillData()
	{
		
		OleDbDataReader reader ; 
		string strCommand = "SELECT * FROM Persons" ; 
		this.objConnection.Open ( ) ;// 打开数据连接 
		OleDbCommand objCommand = new OleDbCommand ( strCommand , objConnection ) ; 
		reader = objCommand.ExecuteReader ( ) ;//获得数据集 
		// 不断往列表中添加数据记录 
		while ( reader.Read ( ) ) 
		{ 
			ListViewItem lstItem = new ListViewItem ( ) ; 
			lstItem.SubItems.Clear ( ) ; 
			lstItem.SubItems[0].Text = reader["name"].ToString ( ) ; 
			lstItem.SubItems.Add ( reader["HomePhone"].ToString ( ) ) ; 
			lstItem.SubItems.Add ( reader["WorkPhone"].ToString ( ) ) ; 
			lstItem.SubItems.Add ( reader["MobilePhone"].ToString ( ) ) ; 
			lstItem.SubItems.Add ( reader["City"].ToString ( ) ) ; 
			lstItem.SubItems.Add ( reader["Address"].ToString ( ) ) ; 
			lstItem.SubItems.Add ( reader["Email"].ToString ( ) ) ; 
			lvPerson.Items.Add ( lstItem ) ; 
		} 
		reader.Close ( ) ; // 关闭数据集 


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

	private void MainForm_Load(object sender, System.EventArgs e)
	{
		FillColumn();
		FillData();
	}

	private void cmdChangeView_Click(object sender, System.EventArgs e)
	{
		this.lvPerson.View=View.List;
	} 
}