自己写的 *** 纵SQLite数据库的SQLHelper,备忘的-_-(VS2005 C#)_sql

概述System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SQLite; using System.Data.Common; namespace WM { class SQLHelper { //建库 pub

650) this.wIDth=650;" onclick="window.open("http://blog.51cto.com/vIEwpic.PHP?refimg=" + this.src)" src="http://img.jb51.cc/vcimg/static/loading.png" align="top" src="http://approlife.blog.51cto.com/images/editer/InBlock.gif">

System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.sqlite;

using System.Data.Common;

namespace WM

{

class sqlHelper

{

//建库

public DbConnection getCon()

{

DbConnection con = new sqliteConnection();

con.ConnectionString = "Data Source=WebMan.db";

return con;

}

//建表

public voID CreateWebtable(DbConnection con)

{

con.open();

try

{

using (DbCommand com = con.CreateCommand())

{

com.CommandText = "create table webtable( ID integer primary key,username varchar(20),qiyename varchar(50),webname varchar(50),tel varchar(20),lianxiren varchar(20),fufeIDate varchar(10),daoqIDate varchar(10),price varchar(10),status varchar(10),yewuyuan varchar(15),mark varchar(50))";

com.ExecuteNonquery();

com.CommandText = "create table yewutable( ID integer primary key,num varchar(20),workername varchar(20),gender varchar(5),age varchar(5),bear varchar(10),fromwhere varchar(60),mark varchar(50))";

com.ExecuteNonquery();

com.CommandText = "create table usertable( ID integer primary key,pwd varchar(20))";

com.ExecuteNonquery();

}

catch (Exception)

{

}

//查询

public DataSet query(DbConnection con,string sql)

{

DataSet ds = new DataSet();

DbDataAdapter da = new sqliteDataAdapter(sql,(sqliteConnection)con);