dumian's Q&A profile

• Visual Studio Tools for Office Caching with app add-ins

  Ive been looking at using data caching for storing our add-in related XML - is this even possible for app level add-ins (specifically Excel). The doco Ive come across always refers to the ServerDocument class and the StartCaching method of a workbook or sheet. In my case the StartCaching method doesnt exist for a sheet or workbook. Ultimately I want to move storage out of hidden sheets to something more robust... Thanks Dave Thanks Cindy, guess we're stuck with hidden sheets then. If anyone knows that caching will be available for application level add-ins or not, please let us know... Thanks Dave ...Show All

• Smart Device Development GPRS Connect at Startup

  Hi again (again), Last question, I promise. I'm looking to start the GPS up wen the device starts. I don't mind changing hte registry for this, or doing it programatically. All the stuff I have found is either for C#, or the registry info doesn't exist in my phone. Once again, any help would be very appreciated. Cheers, Dan. I don't know what I was talking about in the last post, I must have been reading some very strange things. I've implemented it now, and it compiles and runs, but it doesn't actually inialise the GPRS. The GPRS connection remains the same. Here is what I have: CONNMGR_CONNECTIONINFO pConnInfo = { sizeof (CONNMGR_CONNECTIONINFO) }; pConnInfo.dwPriority = CONNMGR_PRIOR ...Show All

• Windows Forms Can someone explain why this SetCurrentCellAddressCore override does not work?

  What I'm trying to do is have a read only column (column zero) that never, ever gets the focus. This seemed like the proper approach, but it doesn't quite work right and I'm not sure why: internal class DataItemViewGrid : DataGridView { protected override bool SetCurrentCellAddressCore( int columnIndex , int rowIndex , bool setAnchorCellAddress , bool validateCurrentCell , bool throughMouseClick) { if (columnIndex == 0) columnIndex = 1; return base .SetCurrentCellAddressCore(columnIndex ,rowIndex ,setAnchorCellAddress ,validateCurrentCell ,throughMouseClick); } I've been at this for sometime now and have tried to handle nav keys by skipping the cell, and override ...Show All

• SQL Server Scripting Stored Procedure in sql 2005 with PRC format is it Possible?

  Hi We recently moved to 2005 and I happily created my stored procedures and when I was about to script a file x object I have noticed that sql 2005 doenst script them in prc format anymore.Unfortunately I need to script them in this format. Or Can I do it with smo Any ideas how to achieve this thanks and best regards We also require that feature. It was there in SQL 2000 and all our stored procedures are maintained in .PRC format in the version control. Let me know if you get any solution. ...Show All

• SQL Server Cross Tab / PIVOT problems with multiple datatypes

  I am building a system that accesses personal data in a view based on two tables. The view is there because the number of used/necessary fields changes with every import of data (which is, perhaps once or twice every week, approx. 50 weeks per year). The view is thus regenerated with every import. I have a Person table with fixed data such as name and address (see below), and I keep statistics and other variables for each person in a second table: PersonStat. Person table ID (PK) Name Address PhoneNo PersonStat keeps one record per person and statistics variable, and thus looked like this: ID (PK) PersonId (FK) StatName StatValue I put these two together in the view making the data easy to access as if it were one single tab ...Show All

• SQL Server Copy cube from a DB to another one

  Hi, I would like to copy a cube and its content from a database to another one. The first database is the one used for production and the second will be used to archive the old cubes. Is there a specific way to deal with this kind of issue Thanks in advance for your support. Rgds, Juan You can take a look at the following link for "synchronize". http://msdn2.microsoft.com/en-us/library/ms174928.aspx Yes. It supports xmla script. The easy way is to generate the script using the synchronize wizard. ...Show All

• SQL Server copy a task error

  Have you ever gotten an error when copying a task in the designer I can't copy a task. That's going to be a pain for developing big packages. I have already uninstalled BIDS and installed Visual Studio and still get the error. Any thoughts on what could I could remove and reinstall to get a working environment Would removing VS and SQL 2005 and all its components work I ran some of the CTP cleanup tools (ttool and msiinv) and they reported no problems and no beta software TITLE: Microsoft Visual Studio ------------------------------ An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. ------------------------------ ADDITIONAL INFORMATION: Could not copy object 'info ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A potential bug in the XNA Framework ?

  On two separate occasions my XNA application has crashed because of an AccessViolationException thrown from Microsoft.Xna.Framework.dll!Microsoft.Xna.Framework.Graphics.Texture2D.GetSurfaceLeve(int level = 0). The exception is being thrown when I try to change the render target. Both times the error has been thrown it was after about 5 minutes of running the application without any problems (and on the same line). The second time I kept moving the mouse around and was using the computer to make sure it wasn't an issue being caused by my screen saver. I am not making any native calls into anything except QueryPerformanceTimer() and QueryPerformanceFrequency() which are being imported in a separate class using PInvoke. Render Targets: m_posi ...Show All

• Visual Studio 2008 (Pre-release) Bind Image to single xmlelement

  I'd like to bind an Image's datasource to a single element in an XmlDataProvider. Each element in the Xml has a unique ID and the image knows the ID it needs to bind to. Is there a way to set the binding of my image so it searches for the appropriate element Brian Ok. i think i'm starting to understand now, you want to bind the image src to the xml element based on the id.  The fundamental problem here is that the XPath support in WPF is limited to literal strings, you can't insert variables, such as the id in your case.  Specifically, you cannot write an xpath query like this:   <Image Source={Binding XPath=imagelist/image/url[imagelist/image/imageid= @prop ]} /> The prob ...Show All

• Windows Forms Process preview window

  I am looking to create a preview window in a form that I have that will display a running process. It's much that same as the preview window when selecting a screensaver in Windows. Basically I want to have a preview button that will display the running process in a preview window on my form and then be able to adjust parameters and see the results of this on the process. Does anyone have any ideas on how to do this, just the getting the process to display in a preview window part. Thanks What is a process by your definition E.g. a running windows service is a process to the system, but it would be kind of hard to display it somehow... ...Show All

• Visual Studio Express Editions How to find missing numbers

  I am trying to figure out code to determine which numbers are missing from a column within a datagridview based on a number entered by the user. In other words, if the user enters 10 into a textbox and there are 3 rows of data in a datagridview that contain 2, 5, and 7 in a column named Number, then I need a string result to be "1 Or 3 Or 4 Or 6 Or 8 Or 9 Or 10". Can anyone help me I'm sure it has to involve For, Next statements and possibly some If, Then statements, but I can't follow the logic and put it to code. For an added challenge, The "numbers" in the column are actually strings, with the number 1 displayed as "001", the number 10 as "010", and the number 100 as "100". But, ...Show All

• Windows Forms How to build a windows application project into dll?

  Hello everyone, Maybe you understand while you're reading my subject. I'd like to build different projects into dlls and integrate them into a main project. For example: In the main project "ABC", I have a main form which has 3 buttons: "A", "B", and "C". When I click on button "A", the project "A", which was built into dll, will be displayed on such Main Form. And I'll do the same way for "B" and "C" buttons. Thank you very much in advance. Regards, Hi, create a Visual C#->Windows Control Library project and design your control (which can be a form). This will produce a DLL that you'll reference in the projec ...Show All

• Visual Studio 2008 (Pre-release) Notation for extension methods

  Congratulations for Linq, it is very refreshingly neat and simple and extremely powerful. What is the reason for using the dot symbol to specify an extension method in C# 3.0, why not use another symbol or for example simply double the dot: myString..MyExtensionMethod(). Are you going to provide some serialization support to the Expression classes I would think that the ability to easily distribute queries across machines or simply application domains could prove extremely useful. The question is: is it good to allow "overriding" of extension methods by standard member methods If an extension method is used on class C in several pieces of code and then a method with the same signature is added ...Show All

• SQL Server SSIS clustered, accessed by multiple instances

  Hi, I have a clustered environment which has many instances in it. I have modified the xml file to allow several instances to use ssis. Everything works great when the instances are on the same node as the clustered ssis. However if they are on different nodes there seems to be an aunthentication problem and it loses my credentials. For some reason it tries to use Anonymous Logon instead. Here is the full error: The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online. Login failed for user 'NT ...Show All

• Visual Studio Is there a Multivalue property for (Select All)

  The article "Using Parameters in Expressions" in SQL Server 2005 Books Online ( http://msdn2.microsoft.com/en-us/library/aa337293.aspx ) discusses various properties of Multivalue Parameters, for instance: =Parameters!<MultivalueParameterName>.IsMultiValue What I don't see is a property that exposes the True/False value of the (Select All) option. Obviously, the reportViewer is aware of this value, but it does not appear exposed in the API. We are very interested in evaluating if the user has selected the (Select All) option. MSFT...Might this be one of the features in the SP1 update, but not yet documented in Books online Thanks - Mike The .IsMultiValue property is availa ...Show All