c# sqlite 操作

 

 

 // 通话记录的数据库
        private SQLiteConnection callHistoryConn = null;
        string strErrorMessage = string.Empty;      //错误信息
        // 数据库本地临时文件
        private string localFile = string.Format(@"C:/Documents and Settings/Administrator/Local Settings/Temp/Android PC Suite/Temp/contacts.db");
        private string localDir = string.Format(@"C:/Documents and Settings/Administrator/Local Settings/Temp/Android PC Suite/Temp");
        private string remote = string.Format("/data/data/com.android.providers.contacts/databases/contacts.db");
        private string backupFile = string.Format(@"D:/我的文档/91 Mobile/Android/Backup/contacts.db");
        private string backupDir = string.Format(@"D:/我的文档/91 Mobile/Android/Backup");

 

 

    private void DownAndCopyDB()
        {
            adb.DownloadFile(remote, localFile);
            try
            {
                if (Directory.Exists(backupDir))
                {
                    System.IO.File.Copy(localFile, backupFile, true);
                }
                else
                {
                    Directory.CreateDirectory(backupDir);
                    System.IO.File.Copy(localFile, backupFile, true);
                }
            }
            catch (Exception)
            {
                throw;
            }

        }

 

  this.StrCnn = "Data Source=" + localFile + @";Version=3";

 

  callHistoryConn = SQLiteClass.GetSQLiteConnection(this.StrCnn);

 IDataReader reader = null;

 reader = SQLiteClass.ExecuteReader(strSQL, this.callHistoryConn, ref strErrMsg);

 

 string sql = "select * from [calls] where type = " + 2 + " and duration " + (success ? "<>" : "=") + 0;

 

   SQLiteClass.ExecuteNoneQuery("Delete From [calls] where _id in " + idGroupStr, this.callHistoryConn, null, null, ref strErrMsg);