SqlCeDataAdapter daPop = null;
SqlCeCommand sqlcmd = null;
SqlCeConnection sqlconn = null;
DataTable dtData = null;
try
{
MessageBox.Show("Run: " + GC.GetTotalMemory (true).ToString());
sqlconn = new SqlCeConnection("Data Source=\\VDTCS.sdf");
sqlconn.Open();
dtData = new DataTable();
daPop = new SqlCeDataAdapter("SELECT * FROM MSTSET", sqlconn);
daPop.Fill(dtData);
if (dgEnqChassisNo.DataSource != null)
{
DataTable dtRec = (DataTable)dgEngChassisNo.DataSource;
dtRec.Clear();
dtRec.Dispose();
dtRec = null;
dgEnqChassisNo.DataSource = null;
}
dgEnqChassisNo.DataSource = dtData;
}
catch (System.Exception ex)
{
MessageBox.Show("GetData: " + ex.Message);
}
finally
{
if (daPop != null)
{
daPop.Dispose();
daPop = null;
}
if (dtData != null)
{
dtData.Dispose();
dtData = null;
}
if (sqlconn != null)
{
sqlconn.Close();
sqlconn.Dispose();
sqlconn = null;
}
GC.WaitForPendingFinalizers();
GC.Collect();
MessageBox.Show("Finish: " + GC.GetTotalMemory
(true).ToString());
}