System. Data. SQLite Test

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 sqlbench
{
Public partial class form1: Form
{
Public form1 ()
{
Initializecomponent ();
}

Private void button#click (Object sender, eventargs E)
{
Sqliteconnection conn = new sqliteconnection ();
Sqlitecommand cmd;
Sqlitedatareader Dr;

Conn. connectionstring = "Data Source = c: \ temp \ mdb2sql_all.db3 ";
Conn. open ();

string _ SQL = "select djh from zd_zjb where lzzjrxm is null group by djh intersect select djh from zd_zjb where lzzjrxm is not null group by djh ";
cmd = new sqlitecommand (_ SQL, Conn);
DR = cmd. executereader ();
while (dr. read ()
{< br> listbox1.items. insert (0, dr. getstring (0);
// application. doevents ();
}< BR >}