using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SQLite;
namespace Test
{
class Program
{
static void Main(string[] args)
{
SQLiteConnection conn = new SQLiteConnection();
SQLiteConnectionStringBuilder connstr = new SQLiteConnectionStringBuilder();
connstr.DataSource = "C:/my.s3db";
conn.ConnectionString=connstr.ToString();
conn.Open();
SQLiteCommand cmd=new SQLiteCommand();
/*string sql="insert into list values('chenyikang')";
cmd.CommandText=sql;
cmd.Connection=conn;
int number=cmd.ExecuteNonQuery();
Console.WriteLine("更新了"+number+"行数据!!");*/
string sql = "select * from list";
cmd.CommandText = sql;
cmd.Connection = conn;
SQLiteDataReader reader = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (reader.Read())
{
Console.WriteLine(reader.GetString(0));
Console.WriteLine(sb.Append("Name").Append(reader.GetString(0)));
}
}
}
}
c#连接sqlite数据库
最新推荐文章于 2024-03-21 17:01:55 发布