Mr Parker's Q&A profile

• SQL Server How to show KPIS on a webpage?=

  I want to show KPIS on a webpage How can I do this     Hi Luis, Check out this article from Mosha about ADOMD.NET source code for querying KPIs in Ananlysis Services 2005 in ASP.NET, I hope it answer your questions. http://www.sqljunkies.com/WebLog/mosha/archive/2004/12/06/5433.aspx sample code: http://blogs.msdn.com/olivier_pieri/archive/2004/12/06/275811.aspx Regards, Peter ...Show All

• Visual Basic DLL PRoblem

  Hi All, I'm newbies to create DLL file. I have wrote a custom class file, and I compiled it as a DLL. However, I just couldn't get it register with regsrv32. And I couldn't import or add this dll as a references to MS Access as well. Can anyone give me some idea on what's the basic step we have to do in order to create a Dll file and use it in MS Access REgards, silkkeng Hi, Just another quick question, as I create a sub New procedures, to load the settings and read and write procedures. how do I make sure whether the dll file resources is free from memory ...Show All

• Visual Basic Access DB INSERT problem

  Hi all, I am currently working on a VB.NET 2003 application that needs to INSERT multiple records in an access database. I this insert query for example : strSQL = "INSERT into NOTE_DEF (CHAPT_PK, FIGNO_PK, NOTE_NO, NOTE_DEF) Values ('" & _ gstrChaptNo & "', '" & gstrFigureNo & "', '" & gNote.NOTE_NO & "', '" & gNote.NOTE & "')" The problem is : If one of my variables, lets say gNote.NOTE (a string), contains a " ' " I get an error message when I execute the INSERT command "Syntax error (missing operator) in query expression.. ...Show All

• Visual Studio Express Editions Visual Studio C++ Express 2005 builds send my monitor nuts

  I'm running XP Home + SP2. Video adapter is NVidia GeForce 4 MX 440. Visual Studio C++ Express 2005. My monitor goes into a blackout/clicking frenzy due to resolution changes it believes exist during any build. This happens every time "Compiling..." appears in the Output window, and when "Linking..." comes up in it. This slows down my builds a lot, plus I can't use the machine for other tasks while all this is going on. The resolution appears to switch to some very low value, and the cursor appears as a fairly large white square on this black background. The problem lies somewhere in my Windows setup/registry. I ...Show All

• Visual C# urlEncode

  Hi, I'm working with Windows Forms in VS.NET 05. I'm trying to use HttpUtility.urlEncode from System.Web. But because i'm working with winforms I can't use urlEncode. It doesn't exists for winforms. Does anybody knows a good equivalent thanks Actually, you can use System.Web.HttpUtility from a Windows forms application. You'll just need to add a reference to System.Web in your project. In the Project Explorer, right click on references and choose 'Add reference' Select the 'System.Web' namespace Now, in your form, you can just use the following code private void btnEnco ...Show All

• Visual Studio Tools for Office Getting an Excell::* pointer form a com component

  Hi I have recently automated an excel app to show some statistics from a different program. Now I would like to show it on the program view. I have added a worksheet component to the view but I can’t find a way to path on the info to it by code (VC++). I cant get the _WorksheetPtr to point to it. I would appreciate any tips on the subject, and apologize for my poor English skills J Tal Hey Tal, This isn't a VSTO related question. I would suggest looking into one of the following forums. you're much more likely to get an answer there. General programming issues: excel.programming ne ...Show All

• .NET Development List of OleDb Providers

  Hi, I'm developing a generic database interface tool. Some vendors have their Dot Net drivers, while in other cases I need to go through an OleDb provider.  I'd like to show the users a list of available OleDb drivers installed on their machine.  I've seen other tools (e.g. DTS) doing this. How would I get a list of available OleDb providers in Dot Net code   I realise this is a low-level feature, and, if it gets too complex, then I'd rather leave it for a better day. Andrew Use OleDbEnumerator.GetEnumerator to enumerate the available data sources on a machine. OleDbDataReader rdr = OleDbEnume ...Show All

• Visual C++ Read Binary data from registry to a string

  Here what i did till yet. Now remain how i get a bytearray from the systemobject-pointer. In regobj is a pointer to the systemobject. From it i am unable to make a byte array. If i use the ToString-Method i receive only the string "SYSTEM.BYTE[]" as content (it's type - not the contents). How can i make a string or a bytearray from System.Byte private : System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { using namespace Microsoft::Win32; using namespace System; RegistryKey^ rk; Object^ regobj; String^ regstr; rk = Registry::LocalMachine->OpenSubKey( "SYSTEM\\CurrentCon ...Show All

• .NET Development Memory Utilization

  I am very interested in the large memory capability of 64 bit computers.  Now, how to use the memory is the issue.  I have a database which stores pointers to  a large number of files (word, excel, project, image, etc) in the file system.  I currently have about 3 gigabytes of support files  addressed by my database.  Is there a way for me keep my 3+ gigabytes of files in ram and have my database reference them  as ram objects. Thanks, Fred Herring ...Show All

• SQL Server is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), but i cant get the variants when building a oledb consumer Yes, it is safe if you do not do anything else inside if this SP. Just small suggestion. If you can, select just the fields you need a ...Show All

• Visual C# calling C# function from C

  Hi I have been searching for an example code/instructions as to how to call a C# function from a native C dll. I have seen some instructions for C++ such as writing a managed MC++ wrapper, or playing with the low level IL code which is not an option for me. I appreciate any kind of feedback Thanks Mehmet Atlihan MCP You don't have any other options - if you want to call managed code, you need to build something in MC++. You could build a MC++ dll that you call from C, perhaps Your other option actually is COM - but I would imagine COM in plain C would be a pain. You can write C# code tha ...Show All

• Visual C# get device info

  i want to get the unque MAC address and network IP address of the machine. i have my application on different WIndows XP stations on he network and i want to get as much as details from which station (PC) the user added or modifie the data. The network is on DHCP so i don't thinkgetting the IP will be useful but MAC adress or anyother unqiue info will help in tracking al changes. ...Show All

• SQL Server Can a Snapshot report be created programmatically?

  Can I create a Snapshot report with parameters programmatically in RS 2000 or RS 2005 If this can be done what is the command for it Thanks. I assume you mean the snapshot datetime stamp used as URL access parameter to render history snapshot. The snapshot datetime value is always based on UTC time which is independent of your local timezone, while the date in the internal catalog tables depends on your server timezone settings. -- Robert ...Show All

• Windows Forms OptimizedDoubleBuffer

  I heard somewhere that by setting ControlStyle.OptimizedDoubleBuffer, you automatically have ControlStyle.UserPaint and ControlStyle.AllPaintingInWmPaint set as well. Is this true The API is unfortunate, but it is a ControlStyle which affects a minority of users. Typically, we'd suggest Control.DoubleBuffered. Marking Obsolete is akin to ripping it - we generate build warnings for every project where it's being used. It's just plain too late for the change and we'll have to rely on the docs to explain i ...Show All

• Visual C++ Comparing ref pointers for equality

  Now that operator overloading allows to ref classes to be compared for equality using == syntax, how does one compare the actual ref pointers ( ^ ) for equality instead As an example: SomeRefObject ^ obj1(..initialized somehow); SomeRefObject ^ obj2(..initialized somehow); if (obj1 == obj2) // This compares the objects themselves for equality in C++/CLI I assume. How do I compare the ref pointers themselves ( ^ ) for equality You have to downcast to System::Object first - this avoids any equality operators that may be defined if (static_cast<System::Object^>(obj1) == st ...Show All