How to set Sqlite Database password?

Question

Hi,

 

i am planning to develop dot net based desktop application where i am thinking to use sqlite database as it is standalone and embedded database which doesn't require separate installation . But in our scenario this database will contain some private information which I do not want to expose by the application user or by sqlite extension.

I have never used Sqlite in any application hence not sure that we can secure our database with password protected? Please let me know if you have used sqlite before how i can achieve this?

Thanks

Answer 1

Hi Friend,

The below coding will help if you save the values in tostring()
                
                    string d;
                    d = dateTimePicker1.Value.ToShortDateString() + " 00:00:00".ToString();
                    string d1;
                    d1 = dateTimePicker2.Value.ToShortDateString() + " 23:59:59".ToString();

                    select command:

                select * from today where date between''+d+"'and'"+d1+"'


With Regards,
Gomathi.P