Hi, Joe:

     When I move page up or  down in  PageTree.aspx with sqlitedb,  deadlock occurs:

Below code is in PageSettings.cs:

//////////////////////////////////////////////////////////////////////////////////////////////////

public void ResortPages()
{
int i = 1;
IDataReader reader = this.GetChildPages();
while(reader.Read())  //you have open the Sqltedb file mojoportal.db,
{
int pageID = Convert.ToInt32(reader["PageID"]);
PageSettings.UpdatePageOrder(pageID, i); //Want Open the file mojoportal.db again? no ,you can't except you close it first. it will deadlock here
i += 2;
}

reader.Close();
}

////////////////////////////////////////////////////////////////////////////////////////////

Above code is not right for Sqlitedb, Because Sqlitedb is a file database, It can't be open twice.

The Above code can be changed as below:

///////////////////////////////////////////////////////////////////////

public void ResortPages()
{
int i = 1;
IDataReader reader = this.GetChildPages(); //Open the sqlitedb file;

System.Collections.Generic.List<int> cp = new System.Collections.Generic.List<int>();

while(reader.Read())
{
cp.Add(Convert.ToInt32(reader["PageID"]));
}

reader.Close(); //Close the sqlitedb file;

foreach (int item in cp)
{
PageSettings.UpdatePageOrder(item, i); //After above close, then I can Open the sqltedb file again.
i += 2;
}

}

///////////////////////////////////////////////////////////////////////

So, Can't treat Sqlitedb  as msql or mysql  entirely the same, Maybe Other place has the same problem.

Thanks!

Hi, Joe

    Your solution is more elegant, it's great.

Thanks!