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