sqlite数据库加密操作，sqlite数据库加密

和通数据库htsjk.Com2019-09-26 00:44 来源:未知阅读:17997 评论 114 热度2

标签：

sqlite数据库加密操作，sqlite数据库加密

//1.给不带密码的数据库添加密码
string strconn = @"Data Source=E:\test.db3;Pooling=true;FailIfMissing=false";
            SQLiteConnection conn = new SQLiteConnection(strconn);
            conn.Open();
     //首次设置密码
            conn.ChangePassword("password");
            conn.Close();

//2.读取带密码的数据
string strconn = @"Data Source=E:\test.db3;Pooling=true;FailIfMissing=false";
            SQLiteConnection conn = new SQLiteConnection(strconn);
     //输入密码
            conn.SetPassword("password");
            string sql = "select * from tb";
            SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            adapter.Fill(ds);
            this.dataGridView1.DataSource = ds.Tables[0];

//3.修改数据库密码
string strconn = @"Data Source=E:\test.db3;Pooling=true;FailIfMissing=false";
            SQLiteConnection conn = new SQLiteConnection(strconn);
            //数据原来密码
            conn.SetPassword("old_password");
            conn.Open();
            //设置新密码
            conn.ChangePassword("new_password");
            conn.Close();