WinForm Read and Write SQLite database example (RPM)

. Net SQLite Database driver and System.Data.SQLite.dll download the latest address:

Http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

SQLite Management tools:

Http://www.cr173.com/soft/94247.html

App. Config file modification:

[HTML]View Plaincopyprint?

2. <? XML version="1.0"?>
4. <configuration>
6. <appSettings>
8. <!--failifmissing=false means that the database is automatically created when it does not exist
10. <add key= "dbsqlite" value= "data source=| datadirectory| DB.DB3; Pooling=true; Failifmissing=false "/>
12. </appSettings>
14. </configuration>

Note: If the development environment is 4.0, and System.Data.Sqlite is the lower version, the error message "Mixed-mode assemblies are generated for the v2.0.50727 version of the runtime and cannot be configured with no additional information in 4.0 Load the assembly in the runtime, the workaround is to add:

<startup uselegacyv2runtimeactivationpolicy= "true" >
<supportedruntime version= "v4.0"/>

</startup>

Database read-write assistant SqliteHelper.cs

[CSharp]View Plaincopyprint?

2. Using System;
4. Using System.Collections.Generic;
6. Using System.Linq;
8. Using System.Text;
10. Using System.Data;
12. Using System.Data.Common;
14. Using System.Data.SQLite;
20. Public class Sqlitehelper
22. {
24. Public sqlitehelper ()
26. {
28. //  
30. //todo: Add constructor logic here
32. //  
34. }
38. private static sqliteconnection getconnection ()
40. {
42. string connstr = system.configuration.configurationmanager.appsettings["Dbsqlite"].   ToString ();
44. Sqliteconnection conn = new Sqliteconnection (CONNSTR);
46. Conn. Open ();
48. return conn;
50. }
54. public static int executesql (string sql)
56. {
58. using (Sqliteconnection conn = getconnection ())
60. {
62. var cmd = new Sqlitecommand (SQL, conn);
64. return cmd.  ExecuteNonQuery ();
66. }
68. }
72. public static int executescalar (string sql)
74. {
76. using (Sqliteconnection conn = getconnection ())
78. {
80. var cmd = new Sqlitecommand (SQL, conn);
82. object o = cmd.  ExecuteScalar ();
84. return Int.  Parse (O.tostring ());
86. }
88. }
90. public static Sqlitedatareader ExecuteReader (String sql)
92. {
94. Sqliteconnection conn = getconnection ();
96. var cmd = new Sqlitecommand (SQL, conn);
98. Sqlitedatareader myreader = cmd. ExecuteReader (commandbehavior.closeconnection);
100. return myreader;
102. }
104. public static DataSet execdataset (String sql)
106. {
108. using (Sqliteconnection conn = getconnection ())
110. {
112. var cmd = new Sqlitecommand (SQL, conn);
114. Sqlitedataadapter da = new Sqlitedataadapter (CMD);
116. DataSet ds = new DataSet ();
118. Da. Fill (DS);
122. return DS;
124. }
126. }
128. }

Apply Form1.cs in a form

[CSharp]View Plaincopyprint?

2. //Determines whether the table exists, does not exist, and generates
4. int result = Sqlitehelper.executescalar ("Select COUNT (*) from sqlite_master where type= ' table ' and name= ' TB '");
6. if (result = = 0)
8. {
10. //Create a table
12. Sqlitehelper.executesql ("CREATE TABLE [TB] (ID integer PRIMARY KEY autoincrement, [name] varchar (), [CreateDate] da  Tetime Default (DateTime (' Now ', ' localtime ')));
14. }
16. Insert a row of data
18. result = Sqlitehelper.executesql ("INSERT INTO [TB] (name) VALUES (' Luck ')");
20. if (Result > 0)
22. {
24. string msg = "";
26. //Read Data
28. Sqlitedatareader dr = Sqlitehelper.executereader ("SELECT * from [TB]");
30. if (Dr. Read ())
32. {
34. msg + = Dr[0] + "," + dr[1] + "," + dr[2 ";
36. }
38. MessageBox.Show (msg);
40. }

WinForm Read and Write SQLite database example (RPM)