wince 操作sqlite数据库

View Code
using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;

namespace wince数据库
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SQLiteConnection conn = new SQLiteConnection(@"data source=\Program Files\test.db");
            conn.Open();
            SQLiteCommand cmd = new SQLiteCommand("select * from student",conn);
            SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dataGrid1.DataSource = dt;
        }

     
    }
}

增加System.Data.SQLite;的引用

及Interop.066.DLL文件支持;

代码如下:

http://download.csdn.net/detail/anbylau2130/4735371

posted @ 2012-11-05 19:36  尼姑哪里跑  阅读(309)  评论(0编辑  收藏  举报