！！！！！
using System.Data.SQLite;
using System.Data;
namespace 连接yjk数据库
{
class Program
{
static void Main(string[] args)
{
//创建数据库文件
string dbName =
"D:\\study\\c#\\破解yjk文件\\dtlmodel.ydb";
//SQLiteConnection.CreateFile(dbName);
//建立数据库连接并打开数据库
SQLiteConnection conn = new
SQLiteConnection();
SQLiteConnectionStringBuilder
connsb = new SQLiteConnectionStringBuilder();
connsb.DataSource =
dbName;
//connsb.Password =
"acen";
conn.ConnectionString =
connsb.ToString();
conn.Open();
//添加表
SQLiteCommand cmd = new
SQLiteCommand(conn);
//string cmdText = "CREATE
TABLE TEST(ID int,name varchar(20))";
//cmd.CommandText =
cmdText;
//cmd.ExecuteNonQuery();
//插入测试数据
//cmd.CommandText = "INSERT
INTO [TEST] (ID,name) VALUES (1,'acen')";
//cmd.ExecuteNonQuery();
//cmd.CommandText = "INSERT
INTO [TEST] (ID,name) VALUES (2,'unique')";
//cmd.ExecuteNonQuery();
//查询结果
cmd.CommandText = "SELECT *
FROM [tblJoint]";
SQLiteDataReader dr =
cmd.ExecuteReader();
StringBuilder sb = new
StringBuilder();
int id = 0;
while (dr.Read())
{
Console.WriteLine(dr["ID"]);
id = id + 1;
}
Console.WriteLine(sb);
Console.ReadKey();
}
}
}
加载中，请稍候......
加载中…
喜欢