首页 vs2019 C# 对SQLite数据库的增删改查的代码实例

vs2019 C# 对SQLite数据库的增删改查的代码实例

上传者： zyw38121913 | 上传时间： 2024-07-22 10:05:45 | 文件大小： 33.24MB | 文件类型： RAR
这是一个用C#实现的读写sqlite数据库的例子，希望能对正学习这一块的朋友有帮助。 需要使用System.Data.SQLite库 大至步骤如下： 在WinForms项目中添加一个数据库连接。你可以使用SQLiteConnection类来建立数据库连接。 创建SQLiteCommand对象来执行SQL查询。 使用SQLiteDataReader来读取查询结果。 执行增删改查操作。 关于SQLite SQLite是一个轻量级的关系型数据库管理系统，遵守ACID原则，其特点是高度便携、使用方便、结构紧凑、高效和可靠。它不是客户端-服务器结构的数据库，而是嵌入式的数据库引擎，可以将其看作是一个单一的、自包含的、零配置的数据库文件。SQLite支持大多数SQL92标准，可以在所有主要的操作系统上运行，并且其源代码是完全公开的。 SQLite也有一些限制和不足之处，例如不具有高度的并发性和良好的存取权限控制，没有内置的函数集，不支持存储过程以及深奥的SQL语言特性，也不支持XML/Java扩展等。

文件下载

资源详情

[{"title":"（ 175 个子文件 33.24MB ） vs2019 C# 对SQLite数据库的增删改查的代码实例","children":[{"title":"System.Data.SQLite.dll.altconfig <span style='color:#111;'> 739B </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll.altconfig <span style='color:#111;'> 739B </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll.altconfig <span style='color:#111;'> 739B </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll.altconfig <span style='color:#111;'> 739B </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll.altconfig <span style='color:#111;'> 739B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.64KB </span>","children":null,"spread":false},{"title":"wfmsqlite.csproj.GenerateResource.cache <span style='color:#111;'> 1012B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 273B </span>","children":null,"spread":false},{"title":"wfmsqlite.csproj.CoreCompileInputs.cache <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"wfmsqlite.csproj.AssemblyReference.cache <span style='color:#111;'> 11B </span>","children":null,"spread":false},{"title":"App.config <span style='color:#111;'> 1.49KB </span>","children":null,"spread":false},{"title":"wfmsqlite.exe.config <span style='color:#111;'> 1.49KB </span>","children":null,"spread":false},{"title":"packages.config <span style='color:#111;'> 594B </span>","children":null,"spread":false},{"title":"wfmsqlite.csproj.CopyComplete <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"Form1.Designer.cs <span style='color:#111;'> 9.17KB </span>","children":null,"spread":false},{"title":"Form1.cs <span style='color:#111;'> 7.64KB </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.78KB </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 521B </span>","children":null,"spread":false},{"title":".NETFramework,Version=v4.8.AssemblyAttributes.cs <span style='color:#111;'> 210B </span>","children":null,"spread":false},{"title":"wfmsqlite.csproj <span style='color:#111;'> 6.73KB </span>","children":null,"spread":false},{"title":"testdb.db <span style='color:#111;'> 12.00KB </span>","children":null,"spread":false},{"title":"testdb.db <span style='color:#111;'> 12.00KB </span>","children":null,"spread":false},{"title":"Debugtestdb.db <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"EntityFramework.dll <span style='color:#111;'> 4.76MB </span>","children":null,"spread":false},{"title":"EntityFramework.dll <span style='color:#111;'> 4.76MB </span>","children":null,"spread":false},{"title":"EntityFramework.dll <span style='color:#111;'> 4.75MB </span>","children":null,"spread":false},{"title":"EntityFramework.dll <span style='color:#111;'> 4.55MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.78MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.76MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.75MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.74MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.74MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.74MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.44MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.42MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.38MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.38MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.36MB </span>","children":null,"spread":false},{"title":"SQLite.Interop.dll <span style='color:#111;'> 1.29MB </span>","children":null,"spread":false},{"title":"EntityFramework.SqlServer.dll <span style='color:#111;'> 577.88KB </span>","children":null,"spread":false},{"title":"EntityFramework.SqlServer.dll <span style='color:#111;'> 577.88KB </span>","children":null,"spread":false},{"title":"EntityFramework.SqlServer.dll <span style='color:#111;'> 577.58KB </span>","children":null,"spread":false},{"title":"EntityFramework.SqlServer.dll <span style='color:#111;'> 572.88KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 441.17KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 430.68KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 430.68KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 430.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 421.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.dll <span style='color:#111;'> 421.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 213.18KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 203.68KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 203.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 203.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 203.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 203.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 203.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 201.68KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.dll <span style='color:#111;'> 201.68KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 201.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 201.67KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.dll <span style='color:#111;'> 201.67KB </span>","children":null,"spread":false},{"title":"ef6.dll <span style='color:#111;'> 87.38KB </span>","children":null,"spread":false},{"title":"Microsoft.Data.Entity.Build.Tasks.dll <span style='color:#111;'> 31.08KB </span>","children":null,"spread":false},{"title":"ef6.exe <span style='color:#111;'> 76.36KB </span>","children":null,"spread":false},{"title":"ef6.exe <span style='color:#111;'> 76.36KB </span>","children":null,"spread":false},{"title":"ef6.exe <span style='color:#111;'> 75.87KB </span>","children":null,"spread":false},{"title":"ef6.exe <span style='color:#111;'> 75.87KB </span>","children":null,"spread":false},{"title":"wfmsqlite.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"wfmsqlite.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"ef6.runtimeconfig.json <span style='color:#111;'> 154B </span>","children":null,"spread":false},{"title":"Stub.System.Data.SQLite.Core.NetFramework.1.0.118.0.nupkg <span style='color:#111;'> 9.87MB </span>","children":null,"spread":false},{"title":"EntityFramework.6.4.4.nupkg <span style='color:#111;'> 6.11MB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.EF6.1.0.118.0.nupkg <span style='color:#111;'> 300.69KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Linq.1.0.118.0.nupkg <span style='color:#111;'> 297.42KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.1.0.118.0.nupkg <span style='color:#111;'> 26.34KB </span>","children":null,"spread":false},{"title":"System.Data.SQLite.Core.1.0.118.0.nupkg <span style='color:#111;'> 26.28KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 24.06KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 24.06KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 24.06KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 24.06KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 24.06KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 18.27KB </span>","children":null,"spread":false},{"title":"wfmsqlite.pdb <span style='color:#111;'> 37.50KB </span>","children":null,"spread":false},{"title":"wfmsqlite.pdb <span style='color:#111;'> 37.50KB </span>","children":null,"spread":false},{"title":"ef6.pdb <span style='color:#111;'> 19.37KB </span>","children":null,"spread":false},{"title":"ef6.pdb <span style='color:#111;'> 18.88KB </span>","children":null,"spread":false},{"title":"ef6.pdb <span style='color:#111;'> 18.88KB </span>","children":null,"spread":false},{"title":"ef6.pdb <span style='color:#111;'> 18.88KB </span>","children":null,"spread":false},{"title":"ef6.pdb <span style='color:#111;'> 18.87KB </span>","children":null,"spread":false},{"title":"Icon.png <span style='color:#111;'> 6.84KB </span>","children":null,"spread":false},{"title":"EntityFramework.DefaultItems.props <span style='color:#111;'> 304B </span>","children":null,"spread":false},{"title":"EntityFramework.props <span style='color:#111;'> 252B </span>","children":null,"spread":false},{"title":"EntityFramework.props <span style='color:#111;'> 188B </span>","children":null,"spread":false},{"title":"EntityFramework.props <span style='color:#111;'> 155B </span>","children":null,"spread":false},{"title":"EntityFramework.props <span style='color:#111;'> 138B </span>","children":null,"spread":false},{"title":"install.ps1 <span style='color:#111;'> 13.70KB </span>","children":null,"spread":false},{"title":"init.ps1 <span style='color:#111;'> 13.67KB </span>","children":null,"spread":false},{"title":"install.ps1 <span style='color:#111;'> 462B </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]

评论信息

其他资源

免责申明

【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明

个人信息

下载历史

相关资源标签

热门下载

最新下载