Re: Change password in System.Data.Sqlite - C# Discussion Boards

29 May '12 - 2:49

Hello!
I cannot change the password in System.Data.Sqlite DB.

Here is the code:

_DB = new SQLiteConnection("Data Source=" + db + String.Format(";Password={0}",
                Convert.ToBase64String(password)));

Later I do this:

_DB.SetPassword(Convert.ToBase64String(newPassword));

But when I open the DB again, I get the error:
"File is encrypted or is not a database..." - the same when open with wrong password.

But after changing the password this way, the DB is still OK until application close.
If I do:

_DB.Open();
_DB.ChangePassword(Convert.ToBase64String(password));
_DB.Close();

I cannot access DB after this.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Pete O'Hanlon

29 May '12 - 3:14

amrok2amrokk wrote:
_DB.SetPassword(Convert.ToBase64String(newPassword));

This line isn't intended to change a password. In SqlLite, you use this to set the password for the database before you issue the Open command.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

29 May '12 - 3:32

Well, it seems

SetPassword()

has to be issued before every

Open()

after

ChangePassword()

has been called.

29 May '12 - 4:46

There is something strange going on. It's written in documentation:

SQLiteConnection.Open Method
Opens the connection using the parameters found in the ConnectionString

But when I change the password

DB.Open(); DB.ChangePassword("newpass"); DB.Close();

and change the password parameter in connection string, I still cannot decrypt DB with new password.

Not all code paths return a value

29 May '12 - 7:04

So I fixed that: changed Base64 string to UTF8 and with update of ConnectionString it works now. Thanks
Sign In·View Thread·Permalink

sheringkapoting

29 May '12 - 0:40

    private DataTable AddNewRowToGrid()
    {
        int rowIndex = 0;
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {
                    //extract the TextBox values
                    drCurrentRow = dtCurrentTable.NewRow();
                    dtCurrentTable.Rows[i - 1]["EffectFrom"] = ((TextBox)mdlpopupGrid.Rows[rowIndex].Cells[1].FindControl("txtEffectFrom")).Text;
                    dtCurrentTable.Rows[i - 1]["EffectivePercentage"] = ((TextBox)mdlpopupGrid.Rows[rowIndex].Cells[2].FindControl("txtEffectivePercentage")).Text;
                    dtCurrentTable.Rows[i - 1]["Grade_Salary"] = ((TextBox)mdlpopupGrid.Rows[rowIndex].Cells[3].FindControl("txtGradeSalary")).Text;
                    rowIndex++;
                }
                dtCurrentTable.Rows.Add(drCurrentRow);
                ViewState["CurrentTable"] = dtCurrentTable;
                return dtCurrentTable;
            }
        }
    }

This code gives me the Fallowing Error:
Not all code paths return a value plss Help !!

Can SARIGÜL

29 May '12 - 0:43

insert return null; before the last }
Sign In·View Thread·Permalink

sheringkapoting

29 May '12 - 0:51

Can SARIGÜL wrote: insert return null; before the last } not working actually I want this Function result to be used as Datatable to fill a Gridview. return null will work
Sign In·View Thread·Permalink

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Pete O'Hanlon

29 May '12 - 0:51

The reason it's given you this message is because you have the condition to test if the ViewState is not null. What happens if ViewState["CurrentTable"] is null? (You have a similar issue if dtCurrentTable.Rows.Count == 0. To fix this, return an empty DataTable from the method (most style guides recommend not returning null).

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos