Spollie's Q&A profile

• SQL Server Dynamic column in the query using SQL 2005

  Hi All,  I am using Micosoft Visual Studio Report Desinger. with MS SQL 2005. I have a table transac table fields are likely, location,date,amount values, USA,01/07/2006,3000 SG,01/07/2006,2500 USA,02/07/2006,6000 SG,02/07/2006,3500 USA,03/07/2006,1000 SG,03/07/2006,6700 USA,04/07/2006,500 SG,04/07/2006,200 Am writing query for date = 04/07/2006 select location,date,amount from transac where date = 04/07/2006 I wanted to add two more column in the query which is a.two days before what is the amount b. From 01/07/2006 to 04/07/2006 what is the amount   The result I want to be Location,date,amount,2daysbefore,uptodate USA,04/07/2006,500,6000,10500 SG,04/07/2006,200 ...Show All

• SQL Server Remote connection not working using MSSMSE

  Im getting quite desperate and frustrated!! I have installed SQL 2005 Express successfully and can connect to it fine using Management Studio locally. If I try and connect remotely using Management Studio Im getting the old Error 10061 : The machine actively refused the connection! I have set it up exactly as per all documentation and help from the forums. Remote connections is on TCP and Named Pipes, I even have the firewall disabled. Im running it on Windows Server 2003 Standard. Any help would be really apriciated as i have tried everything!!! THANK YOU, THANK YOU, THANK YOU. Im in! I checked the client config util and there were 2 entries in there so i removed them! I then connecte ...Show All

• Visual Studio DebuggableAttribute in ILDASM Manifest for Release Builds

  A while back we were having problems with a client of ours and after working with Microsoft, they told us that the assemblies the client had were debug versions. They pointed out that the DebuggableAttribute was in the ILDASM manifest of our release assemblies and that this meant they were debug and not release. After changing a few parameters being passed to the compile r we were able to get pdb from release builds without the attribute. However after upgrading to VS2005 and using MSBuild no matter what setting I have /p:DebugType=pdbonly or /p:DebugType=full I get the attribute in the assembly. Even though the documentation states the difference in pdbonly vs full is that the when using "full" the compiler emits the Debug ...Show All

• Audio and Video Development XPath Node Set Functions

  Does any know if node set functions, such as count or position, are vaild to use in the HDi world I've been trying, but I keep having problems getting a valued returned. Below is the line that is giving me the issue. It may not be 100% correct because I am writing this from home without the exact code in front of me. I believe it's close enough to get the idea across though. var position = this.savedbookmarks.evaluteXPath(position( //bookmark[@time ="+current+")],this.savedbookmarks.documentElement); From what I can remember, the evaluteXPath call returns a node list. In this case, it's returning a node list with a length of zero. Is there maybe a different way I should be going about this ...Show All

• Software Development for Windows Vista Communication with external applications

  Hello, I've been trying the hands-on labs and now I'm developing a simple workflow myself, but I don't really know how to communicate between an external application and the local workflow. I know that lab05 deals with a similar topic but I've found that the communication was only between a LOCAL application and the workflow but not with an external application. Now I'm trying to follow the expense reporting application in lab01 (resources folder) and I try to see how it communicates with the workflow. I've seen it uses .NET Remoting to create an instance of the remote class, but I don't get to understand well what it does because the same project has together the remoteservices class and the localservices class. Please can someon ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. LoadGraphicsContent for Game and Component - What is the best practice...

  Hi, I've followed the spacewar example and put the call to new ContentManager in the LoadGraphicsContent of the Game. Because I need to use the content manager in some of my components I have made it a static property on the top level game. I can call now call upon the content manager from the LoadGraphicsContent method within my components and load textures and stuff as required. However, it seems that the LoadGraphicsContent of the components are being called before the one in the Game. What is the best practice with regards to setting up the ContentManager, and using it within the Game and Component's LoadGraphicsContent. Any ideas Kind Regards, James Jim Perry wrote: I'm ...Show All

• SQL Server Need for Multi-Threaded Visual Basic.NET to SQL Server Data Access Example Code

  Of all the Visual Basic.NET data access books that I have purchased and all the Internet site example code that I have reviewed, none have had any good examples of multi-threaded VB.NET code doing data access. I am trying to avoid the non-responsiveness in a VB app while a simple data retrieval from SQL Server 2005 is in progress. If anyone knows of any book titles or web sites that have example code (good or not) of multi-threaded VB.NET applications doing data access against Microsoft SQL Server (7, 2000, or 2005) or even against Microsoft Access(TM), it would be very much appreciated if you could provide the book title or URL to point me in the right direction. The more examples the better. Thanks in advance. ...Show All

• Visual Studio Team System Can the comments for the requests be seen?

  Hi, I have entered comments for each requests.On play back wheter i am able to see the comments in that window also or in anywhere Kindly suggest. Thanks in advance - Vijay. ...Show All

• SQL Server New to SSIS, seem to me missing something fundamental:

  I am attempting to import data into SQL 2005 (using the Tasks->Import Data wizard) and get as far as selecting a datasource. My source is ODBC and I am selecting ".NET Framework Data Provider for Odbc" but then get stuck on the connection string... I am attempting to import from 'Relativity Client' which as far as I can tell is an interface to a Cobol database, I have also had this problem importing from FoxPro - how do I come up with a connection string I have also tried to create a DTSX package, created the connection to the odbc source, tested ok, then when selecting the connection as a source (datareader source) I get the message 'Cannot acquire a managed connection from the run-time connection manager'... I have als ...Show All

• Visual Studio Express Editions friend classes

  How can I define friend classes in c# The C# keyword that matches the VB Friend keyword is 'internal'. C# doesn't have an analogue for the C++ friend keyword. ...Show All

• Visual C# Syncing data - locking a public property?

  Hi folks, I have a public property (generic Dictionary) which contains some instances of a custom class (myCustomObject). this custom object also has some aggregations which also has some more aggregations -> a tree heirachy. Now, i have some threads which need to access the objects in the generic dictionary (hence the property is public). Q1. Can i put a lock keyword in the getter and setter of the dictionary property Q2. If i need to access something within the object (eg. some aggregation) do i need to lock the object still Here's some code to help explain what i'm thinking - i'm not sure if this is the correct concept or not... Dictionary<Guid, MyCustomObject> dictionary = new myCustomObject<Guid, MyCustom ...Show All

• Gadgets Network activity monitor ?

  Hi, I'm looking for a network activity monitor gadget but I can't find any !! I only found NetMonitor and NetActivity but I can't even install them. Any ideas thx NetActivity will only work if Sidebar is running elevated as Administrator. So you'll need to exit Sidebar and manually run it as Adminstrator. If you installed it as a normal user, the Gadget doesn't appear for some reason. ...Show All

• Windows Forms Cant access public methods of a C# applet through javascript

  I have created a winforms control that i want to embed into a HTML page to add extra functionality. That is working well and IE can display the control and works as expected. However i cannot access any public methods defined in the C# control. Lets say the winform control has a textbox called txtName. There is a public method that retrieves the text value public string GetName() { return txtName.Text; } In the HTML markup this is the object tag. <object id="control1" classid="control.dll#control.control1" VIEWASTEXT></object> I then have a javascript command like the following: alert(control1.GetName); this always returns UNDEFINED even when there is text entered text box I am very lost here and wou ...Show All

• Visual C# show release version

  Hello, I have 2 forms that i need to show the respective version in a dialog box or in another form. something like this: form1 version: 1.0.0.0 form2 version: 1.0.0.1 Cpyright.......... Im thinking to put in a class so that's any new form can use it. Any idea I'd say go with a ListBox in a design similar to how the About page of Visual Studio 2005 (and Express) looks. If you made it into a control just provde a method that would take in the objects name and it's Version (ie System.Version ) and store it internally. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bug in texture content importer (alpha generation)

  It appears that a texture will be made chroma-keyed, even if you don't select the chroma-keyed texture processor. When importing a pre-saved DDS from Photoshop, pure magenta color turns to black (which in DXT1 can mean alpha), even when using the plain "texture (mipmapped)" processor. Bug filed at: https://connect.microsoft.com/feedback/ViewFeedback.aspx FeedbackID=237899&SiteID=226 Both the SpriteTextureProcessor and the ModelTextureProcessor do color keying.  the plain TextureProcessor does not.  Are you sure the texture is being built with the TextureProcessor   Keep in mind that if you add both a model and that model's texture to solution explorer, you are actually causing the texture to be buil ...Show All