磁县邯郸网站建设,织梦手机网站怎么安装教程视频教程,深圳建设工程交易服务网中标,公司网络规划设计方案一、下载SQLite
Sqlite官网 我下载的是3370000版本:sqlite-dll-win64-x64-3370000.zip 和 sqlite-tools-win32-x86-3370000.zip
二、解压下载的两个压缩包 三、配置环境 四、检查是否安装配置成功
winR#xff1a;输入cmd调出命令窗口#xff0c;输入sqlite3后回车查看s…一、下载SQLite
Sqlite官网 我下载的是3370000版本:sqlite-dll-win64-x64-3370000.zip 和 sqlite-tools-win32-x86-3370000.zip
二、解压下载的两个压缩包 三、配置环境 四、检查是否安装配置成功
winR输入cmd调出命令窗口输入sqlite3后回车查看sqlite版本
五、Navcate连接Sqlite 以上就是安装配置Sqlite并使用数据库管理工具---Navicat简单创建或者打开数据库文件在管理工具中可以对db文件中的表进行修改
六、C#代码中调用SQLite数据库db文件
新建项目在NuGet程序包内搜索System.Data.Sqlite 安装Sqlite类库 创建SQLiteHelper类 public class SQLiteHelper{///可以创建数据库文件public static void CreateDBFile(string fileName){string path System.Environment.CurrentDirectory /Data/;if (!Directory.Exists(path)){Directory.CreateDirectory(path);}string databaseFileName path fileName;if (!File.Exists(databaseFileName)){SQLiteConnection.CreateFile(databaseFileName);}}//生成连接字符串private static string CreateConnectionString(){SQLiteConnectionStringBuilder connectionString new SQLiteConnectionStringBuilder();connectionString.DataSource System.Environment.CurrentDirectory \StudentDB.db;//这里StudentDB.db文件中的Grade表是我在Navicat中新创建的用来测试string conStr connectionString.ToString();return conStr;}/// summary/// 对插入到数据库中的空值进行处理/// /summary/// param namevalue/param/// returns/returnspublic static object ToDbValue(object value){if (value null){return DBNull.Value;}else{return value;}}/// summary/// 对从数据库中读取的空值进行处理/// /summary/// param namevalue/param/// returns/returnspublic static object FromDbValue(object value){if (value DBNull.Value){return null;}else{return value;}}/// summary/// 执行非查询的数据库操作/// /summary/// param namesqlString要执行的sql语句/param/// param nameparameters参数列表/param/// returns返回受影响的条数/returnspublic static int ExecuteNonQuery(string sqlString, params SQLiteParameter[] parameters){string connectionString CreateConnectionString();using (SQLiteConnection conn new SQLiteConnection(connectionString)){conn.Open();using (SQLiteCommand cmd conn.CreateCommand()){cmd.CommandText sqlString;foreach (SQLiteParameter parameter in parameters){cmd.Parameters.Add(parameter);}return cmd.ExecuteNonQuery();}}}/// summary/// 执行查询并返回查询结果第一行第一列/// /summary/// param namesqlStringSQL语句/param/// param namesqlparams参数列表/param/// returns/returnspublic static object ExecuteScalar(string sqlString, params SQLiteParameter[] parameters){string connectionString CreateConnectionString();using (SQLiteConnection conn new SQLiteConnection(connectionString)){conn.Open();using (SQLiteCommand cmd conn.CreateCommand()){cmd.CommandText sqlString;foreach (SQLiteParameter parameter in parameters){cmd.Parameters.Add(parameter);}return cmd.ExecuteScalar();}}}/// summary/// 查询多条数据/// /summary/// param namesqlStringSQL语句/param/// param nameparameters参数列表/param/// returns返回查询的数据表/returnspublic static DataTable GetDataTable(string sqlString, params SQLiteParameter[] parameters){string connectionString CreateConnectionString();using (SQLiteConnection conn new SQLiteConnection(connectionString)){conn.Open();using (SQLiteCommand cmd conn.CreateCommand()){cmd.CommandText sqlString;foreach (SQLiteParameter parameter in parameters){cmd.Parameters.Add(parameter);}DataSet ds new DataSet();SQLiteDataAdapter adapter new SQLiteDataAdapter(cmd);adapter.Fill(ds);conn.Close();return ds.Tables[0];}}}}
调用SQLiteHelper类
public class Program
{static void Main(string[] args){GetAllGrade();}/// summary/// 查询所有年级/// /summary/// returns/returnspublic static ListGradeEty GetAllGrade(){ListGradeEty gradeEties new ListGradeEty();SQLiteHelper sQLiteHelper new SQLiteHelper();string sqlQuery SELECT * FROM Grade;;SQLiteParameter[] parameters new SQLiteParameter[]{};DataTable dt SQLiteHelper.GetDataTable(sqlQuery, parameters);for (int i 0; i dt.Rows.Count; i){string Id dt.Rows[i][ID].ToString();string GradeName dt.Rows[i][GradeName].ToString();GradeEty clientEty new GradeEty(Id, GradeName);gradeEties.Add(clientEty);}return gradeEties;}
}public class GradeEty
{public string Id { get; set; }public string Name { get; set; }public GradeEty(string id, string name){Id id;Name name;}
}
db文件中的Grade表 拿到db文件中Grade表的数据转化成List集合
