I answered this for you in your duplicate post on
microsoft.public.sqlserver.ce, which is the appropriate
newsgroup for this question.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"AndreB" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> This is a Smart Device App with Windows CE.NET.
>
> I experience a memory leak with the following code. Every time I append
> 500
> records to my TestTable, I display a Messagebox.
> If and in the "Start | Settings | Control Panel | System | Memory"
> window,
> I can see that more than 200 KB of memory are lost.
>
> My main code is a little loop.
>
> int RecordNumber = 1;
>
> while (true)
> {
> _CmdAppend.Parameters["@cCode" ].Value =
> RecordNumber.ToString().PadRight(7,' ');
> _CmdAppend.ExecuteNonQuery();
>
> if (RecordNumber % 500 == 0)
> {
> if (MessageBox.Show("\n\n" + RecordNumber.ToString()+ "
> Record(s)\n\n","Test
> Append",MessageBoxButtons.OKCancel,MessageBoxIcon.None,MessageBoxDefaultButton.Button2)
> != DialogResult.OK)
> break;
> }
> RecordNumber++;
> }
>
> Does anybody could tell me where I am wrong in my code.
>
> Many thanks because I'm exhausted,
>
> AndreB.
>
> Following is the complete code to make your complete test.
>
> //- Form1.cs
>
> using System;
> using System.Drawing;
> using System.Collections;
> using System.Windows.Forms;
> using System.Data;
> // Add Reference to System.Data.Common;
> using System.Data.Common;
> // // Add Reference to System.Data.SqlServerCe;
> using System.Data.SqlServerCe;
> using System.IO;
>
> namespace TestSqlCe
> {
> public class Form1 : System.Windows.Forms.Form
> {
> #region Constructor
> public Form1()
> {
> InitializeComponent();
>
> }
> #endregion Constructor
>
> #region Dispose
> protected override void Dispose( bool disposing )
> {
> base.Dispose( disposing );
> }
> #endregion Dispose
>
> #region InitializeComponent
> private void InitializeComponent()
> {
> //
> // Form1
> //
> this.ClientSize = new System.Drawing.Size(240, 275);
> this.Text = "Form1";
> this.Load += new System.EventHandler(this.Form1_Load);
> }
> #endregion
>
> #region Main
> static void Main()
> {
> Application.Run(new Form1());
> }
> #endregion Main
>
> #region Form1_Load
> private void Form1_Load(object sender, System.EventArgs e)
> {
> string FileName = @"\My Documents\TEST.sdf";
> if (File.Exists(FileName))
> File.Delete(FileName);
>
> // Create Database and Table
> SqlCeEngine varEngine = new SqlCeEngine("Data Source = " +
> FileName);
> varEngine.CreateDatabase();
> SqlCeConnection _ConnectionSqlCe = new SqlCeConnection("Data
> Source
> = " + FileName);
> SqlCeCommand varCreate = _ConnectionSqlCe.CreateCommand();
> varCreate.CommandText = "Create TABLE TestTable (RecordNum int
> IDENTITY(1,1),cCode nvarchar(7) PRIMARY KEY)";
> _ConnectionSqlCe.Open();
> varCreate.ExecuteNonQuery();
> _ConnectionSqlCe.Close();
> varCreate.Dispose();
>
> // Create SqlCeCommand
> _ConnectionSqlCe = new SqlCeConnection("Data Source = " +
> FileName);
> _ConnectionSqlCe.Open();
> SqlCeCommand _CmdAppend = _ConnectionSqlCe.CreateCommand();
> _CmdAppend.CommandText = "INSERT INTO TestTable (cCode) VALUES
> (?)";
> _CmdAppend.Parameters.Add(new
> SqlCeParameter("@cCode",SqlDbType.NVarChar, 7,"cCode" ));
>
> int RecordNumber = 1;
> while (true)
> {
> _CmdAppend.Parameters["@cCode" ].Value =
> RecordNumber.ToString().PadRight(7,' ');
> _CmdAppend.ExecuteNonQuery();
>
> if (RecordNumber % 500 == 0)
> {
> if (MessageBox.Show("\n\n" + RecordNumber.ToString()+ "
> Record(s)\n\n","Test
> Append",MessageBoxButtons.OKCancel,MessageBoxIcon.None,MessageBoxDefaultButton.Button2)
> != DialogResult.OK)
> break;
> }
> RecordNumber++;
> }
> _CmdAppend.Dispose();
> _ConnectionSqlCe.Close();
> }
> #endregion Form1_Load
>
> }
> }
>
>
>
Similar Threads
