public void Dispose() { if (_sqlCmd != null) { _resultSet.Dispose(); _sqlCmd.Dispose(); _record = null; _resultSet = null; _sqlCmd = null; } }
private void SaveHistory() { StringBuilder q = new StringBuilder(); connection.Open(); var transaction = connection.BeginTransaction(); SqlCeCommand sqlCeCommand = connection.CreateCommand(); sqlCeCommand.CommandType = CommandType.TableDirect; sqlCeCommand.CommandText = "HistoryTransaction"; sqlCeCommand.Transaction = transaction; SqlCeResultSet result = sqlCeCommand.ExecuteResultSet(ResultSetOptions.Updatable); SqlCeUpdatableRecord rec = result.CreateRecord(); foreach (DataRow item in dtHistory.Rows) { string encrypt = Cryptography.RSA2.Encrypt(item["Body"].ToString()); // q.Append(@"INSERT INTO [HistoryTransaction] ([IsGroup], [AccountName], // [ServerID], [GroupName], [Body], [DateTime], [PIC]) VALUES "); // q.AppendFormat("({0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", // 1, _xmppClient.Username, _xmppClient.XmppDomain, // _roomJid.Bare, encrypt, DateTime.Parse(item["Body"].ToString()), item["PIC"].ToString()); rec.SetValue(1, 1); rec.SetValue(2, _xmppClient.Username); rec.SetValue(3, _xmppClient.XmppDomain); rec.SetValue(4, _roomJid.Bare); rec.SetValue(5, encrypt); rec.SetValue(6, DateTime.Parse(item["DateTime"].ToString())); rec.SetValue(7, item["PIC"].ToString()); result.Insert(rec); } result.Close(); result.Dispose(); transaction.Commit(); connection.Close(); }
/// <summary> /// Releases resources /// </summary> public override void Dispose() { _resultSet.Dispose(); }