C#

static void AddFeatures(ReportTask report, Guid taskId, out int nRow, out Table table)
{
	table = null;
	nRow = 0;
	var miStyle = TabUtility.MakeMapInfoStyle(report.Style);
	var dbtable = new DataTable();
    try
    {
        using (var cmd = new SqlCommand())
        using (var conn = Config.GetOpenedConnection())
        {
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandTimeout = Config.SqlTimeout;
            cmd.CommandText = report.StoredProc;
            cmd.AddParameter("uidTaskID", SqlDbType.UniqueIdentifier, taskId);

			// 1st quick read of all data: no SqlTimeout
			// there might be tens of thousand of row in this data
			using (var reader = cmd.ExecuteReader())
			{
				// 1st OutOfMemory sometimes here
				if (reader.HasRows)
					dbtable.Load(reader);
			}
        }
    }
    catch (Exception ex)
    {
        ex.Data["ReportName"] = report.Name;
        ex.Data["ReportSP"] = report.StoredProc;
        throw;
    }

	// then slow creation of MapXtreme table
	try
	{
        long TotalWKBRead = 0;
		foreach (DataRow row in dbtable.Rows)
		{
            try
            {
                var wkb = row[GeomColumnName] as byte[];
                if (wkb == null || wkb.Length == 0)
                    continue;
                var geom = WKB.ToFeatureGeometry(wkb);
                if (geom == null)
                    continue;

                TotalWKBRead = wkb.Length;

                if (table == null)
                {
                    table = CreateTable(report.BasePath, report.Name, miStyle, dbtable);
                    table.BeginAccess(TableAccessMode.Write);
                }

                var feature = new Feature(table.TableInfo.Columns);
                feature.Geometry = geom;
                feature.Style = miStyle;
                TabUtility.SetFeatureValues(feature, row);

		// 2. OutOfMemory exception, in 3rd party code, damn it!
                table.InsertFeature(feature);
                nRow++;
            }
            catch (Exception ex)
            {
                var wkb = row[GeomColumnName] as byte[];

                ex.Data["TaskID"] = taskId;
                ex.Data["ReportName"] = report.Name;
                ex.Data["table.Row.Count"] = nRow;
                ex.Data["WKB.Length"] = wkb != null ? wkb.Length : 0;
                ex.Data["TotalWKB.Length"] = TotalWKBRead;
                throw;
            }
		}
	}
	finally
	{
		if (table != null)
			table.EndAccess();
	}
}

<br />
BOOL IsOpenedNyWindowsExplorer(CString FolderName)<br />
{<br />
   ATLENSURE(FolderName);<br />
<br />
   BOOL RESULT=FALSE;<br />
   IShellWindows *psw;<br />
   HRESULT hr=0;<br />
<br />
   hr = CoCreateInstance(CLSID_ShellWindows, NULL, CLSCTX_ALL,IID_IShellWindows,(void**)&psw);<br />
    <br />
    if (SUCCEEDED(hr))<br />
    {<br />
		long lCount=0;<br />
		psw->get_Count(&lCount);<br />
		for (int i = 0; i < (int)lCount; i++)<br />
        {<br />
            _variant_t vtIndex( (long)i);<br />
			IDispatch* pDisp=NULL;<br />
		    hr=psw->Item(vtIndex,&pDisp);<br />
			if(SUCCEEDED(hr))<br />
			{<br />
               IWebBrowser2* pBrowser=NULL;<br />
			   hr=pDisp->QueryInterface(IID_IWebBrowser2,(void**)&pBrowser);<br />
			   if(SUCCEEDED(hr))<br />
			   {<br />
                   BSTR Loc=SysAllocStringLen(NULL,270);<br />
				   hr=pBrowser->get_LocationURL(&Loc);<br />
				   if(SUCCEEDED(hr))<br />
				   {<br />
					   TCHAR* Dest=new TCHAR[270];<br />
					   DWORD Buff=0;					   <br />
					   CString str(Loc);<br />
					   if(AtlUnescapeUrl(str,Dest,&Buff,270))<br />
					   {<br />
						   str.ReleaseBuffer();<br />
						   str=Dest;<br />
<br />
						   str.TrimLeft(L"file:///").Replace('/','\\');<br />
						   if(!FolderName.CompareNoCase(str)) <br />
						     RESULT=TRUE;<br />
<br />
						   str.ReleaseBuffer();<br />
					   }<br />
					   str.ReleaseBuffer();<br />
					   delete[] Dest;<br />
					   pBrowser->Release();<br />
				   }<br />
				   SysFreeString(Loc);<br />
			   }<br />
			   pDisp->Release();<br />
			}<br />
	    }<br />
        <br />
        psw->Release();<br />
    }<br />
<br />
	return RESULT;<br />
}<br />

Sayed Sajid wrote:

Any early replies will be appreciated.