cs文件:

 

1. using System; 
2. using System.Collections.Generic; 
3. using System.ComponentModel; 
4. using System.Data; 
5. using System.Drawing; 
6. using System.Linq; 
7. using System.Text; 
8. using System.Windows.Forms; 
9. using System.Data.SQLite; 
10.  
11. using DevComponents.DotNetBar; 
12.  
13. namespace MyWinForm 
14. { 
15.     public partial class Form1 : Office2007Form 
16.     { 
17.         public Form1() 
18.         { 
19.             InitializeComponent(); 
20.         } 
21.  
22.         private void Form1_Load(object sender, EventArgs e) 
23.         { 
24.             SQLiteConnection dbConnection = new SQLiteConnection("Data Source=../../test.db;"); 
25.             SQLiteCommand dbCommand = new SQLiteCommand("SELECT * FROM user", dbConnection); 
26.             dbCommand.CommandType = CommandType.Text; 
27.             SQLiteDataAdapter dbDataAdapter = new SQLiteDataAdapter(dbCommand); 
28.             DataSet dataSet = new DataSet(); 
29.             dbDataAdapter.Fill(dataSet, "user"); 
30.             dataGridView1.DataSource = dataSet.Tables["user"]; 
31.         } 
32.  
33.     } 
34. } 

设计器生成:

 

1. namespace MyWinForm 
2. { 
3.     partial class Form1 
4.     { 
5.         /// <summary> 
6.         /// 必需的设计器变量。 
7.         /// </summary> 
8.         private System.ComponentModel.IContainer components = null; 
9.  
10.         /// <summary> 
11.         /// 清理所有正在使用的资源。 
12.         /// </summary> 
13.         /// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param> 
14.         protected override void Dispose(bool disposing) 
15.         { 
16.             if (disposing && (components != null)) 
17.             { 
18.                 components.Dispose(); 
19.             } 
20.             base.Dispose(disposing); 
21.         } 
22.  
23.         #region Windows 窗体设计器生成的代码 
24.  
25.         /// <summary> 
26.         /// 设计器支持所需的方法 - 不要 
27.         /// 使用代码编辑器修改此方法的内容。 
28.         /// </summary> 
29.         private void InitializeComponent() 
30.         { 
31.             this.components = new System.ComponentModel.Container(); 
32.             System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); 
33.             this.bindingSource1 = new System.Windows.Forms.BindingSource(this.components); 
34.             this.dataGridView1 = new System.Windows.Forms.DataGridView(); 
35.             this.id = new System.Windows.Forms.DataGridViewTextBoxColumn(); 
36.             this.uname = new System.Windows.Forms.DataGridViewTextBoxColumn(); 
37.             this.password = new System.Windows.Forms.DataGridViewTextBoxColumn(); 
38.             ((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).BeginInit(); 
39.             ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); 
40.             this.SuspendLayout(); 
41.             //  
42.             // dataGridView1 
43.             //  
44.             this.dataGridView1.AllowUserToAddRows = false; 
45.             this.dataGridView1.AllowUserToDeleteRows = false; 
46.             this.dataGridView1.BackgroundColor = System.Drawing.Color.White; 
47.             this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; 
48.             this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { 
49.             this.id, 
50.             this.uname, 
51.             this.password}); 
52.             this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill; 
53.             this.dataGridView1.Location = new System.Drawing.Point(0, 0); 
54.             this.dataGridView1.Name = "dataGridView1"; 
55.             this.dataGridView1.ReadOnly = true; 
56.             this.dataGridView1.RowTemplate.Height = 23; 
57.             this.dataGridView1.Size = new System.Drawing.Size(344, 191); 
58.             this.dataGridView1.TabIndex = 0; 
59.             //  
60.             // id 
61.             //  
62.             this.id.DataPropertyName = "uid"; 
63.             this.id.HeaderText = "用户标识"; 
64.             this.id.Name = "id"; 
65.             this.id.ReadOnly = true; 
66.             //  
67.             // uname 
68.             //  
69.             this.uname.DataPropertyName = "uname"; 
70.             this.uname.HeaderText = "用户名"; 
71.             this.uname.Name = "uname"; 
72.             this.uname.ReadOnly = true; 
73.             //  
74.             // password 
75.             //  
76.             this.password.DataPropertyName = "password"; 
77.             this.password.HeaderText = "密码"; 
78.             this.password.Name = "password"; 
79.             this.password.ReadOnly = true; 
80.             //  
81.             // Form1 
82.             //  
83.             this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); 
84.             this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; 
85.             this.BottomLeftCornerSize = 15; 
86.             this.BottomRightCornerSize = 15; 
87.             this.ClientSize = new System.Drawing.Size(344, 191); 
88.             this.Controls.Add(this.dataGridView1); 
89.             this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); 
90.             this.Name = "Form1"; 
91.             this.Text = "用户资料"; 
92.             this.Load += new System.EventHandler(this.Form1_Load); 
93.             ((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).EndInit(); 
94.             ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); 
95.             this.ResumeLayout(false); 
96.  
97.         } 
98.  
99.         #endregion 
100.  
101.         private System.Windows.Forms.BindingSource bindingSource1; 
102.         private System.Windows.Forms.DataGridView dataGridView1; 
103.         private System.Windows.Forms.DataGridViewTextBoxColumn id; 
104.         private System.Windows.Forms.DataGridViewTextBoxColumn uname; 
105.         private System.Windows.Forms.DataGridViewTextBoxColumn password; 
106.  
107.     } 
108. } 

 

运行界面:

 

注意需要引用System.Data.SQLite.dll

 

 本文转自 xcf007 51CTO博客，原文链接：http://blog.51cto.com/xcf007/426681，如需转载请自行联系原作者