FatalRanger's Q&A profile

• SQL Server I found a bug in Sql Server 2000！！！

  Yesterday I created a table in Sql Server 2000,using this script： CREATE TABLE [dbo].[User]( [Id] [int] NOT NULL, [UserName] [nvarchar](20) NOT NULL, [TrueName] [nvarchar](20) NOT NULL, [Password] [nvarchar](60) NOT NULL, [Department] [int] NOT NULL, [Mobile] [nvarchar](20) NULL, [Telephone] [nvarchar](20) NULL, [Remark] [nvarchar](200) NULL, [Enabled] [bit] NOT NULL, [Available] [bit] NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [Id] ASC ) ON [PRIMARY] ) ON [PRIMARY] There was only one record in it: INSERT INTO [User] VALUES(1,N'SUP',N'Jim',N'213123',1,NULL,NULL,NULL,1,1) After I executed this script： UPDATE [User] SET UserName=N'f',TrueName=N'gg',[Password]=N'dfsdfsdf',Mobile=NULL,Telephone=NULL,Remark=NULL, Ena ...Show All

• SQL Server Interval/Bucket Dimension

  I am trying to find the most efficient way of handelling discreet buckets over continuous/discreet set of values. In english I am looking to have a dimension that says if age is between 0 and 5 they are an infant, 6 to 18 child and > 18 adult. I know I can do this in a case statement but I have similar senarios that require multiple levels of nesting and the ability to easily change the banding criteria with many fact table sharing the same banding information. I have done this in the past by preprocessing the fact table and updating the key value based on between joins, but this is very inefficient on large datasets (upwards of 30 million rows). I also need to be able to do this across continuous values such a monetary amounts ...Show All

• Visual Basic Attribute Question

  Hello ! I have as sample Attribute code in c# and i wont to convert this to Visual Basic C# Code [DtsPipelineComponent( DisplayName = "SSIS Source Adapter", ComponentType = ComponentType.SourceAdapter, IconResource = "Dts.Pipeline.SSISSourceAdapter.source.ico")] public class SSISSourceAdapter : PipelineComponent { ........ this Code works! And my code in Visual Basic is: <DtsPipelineComponent(ComponentType.SourceAdapter,"SSIS SourceAdapter","Dts.Pipeline.SSISSourceAdapter.source.ico")>_ Public Class ProfSSISSourceAdapter Inherits PipelineComponent ..... My Compiler says: " To much Arguments for Public Sub New() and underline ->D ...Show All

• Visual C++ Build two configurations of the same project in the same solution

  Here is a simplified version of what I am trying to do: solution.sln contains project1.vcproj which has two configurations Release|Win32 and Debug|Win32 and project2.vcproj When I build the solution I want three things built: project1 with the Release|Win32 configuration project1 with the Debug|Win32 configuration project2 with whatever my current configuration is. In a nutshell, how to I build two different configurations of the same project file in a single build step As a fist step just show me how to do that, for bonus points show me how to make configuration dependant dependances, ie project2 depends on project1 Release|Win32. Be advised that I have already ruled out nmake /make for other design reasons. Thanks in advance. In c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to create a level editor

  I was wondering if anyone out there has written a level editor for their XNA game If so, how did you write it and did you use XNA to write it I am mostly interested in 3D games. I am trying to decide whether I should create the level in a modeling program and inport that for the enviroment, but this seems like it would be far to resource consuming. Any help would be greatly appreciated. :) Thanks. You can load in objects as and when you need them so you don't have to load them all in at runtime. If it were me I would work on creating the level editor first then a seperate program to run the game using components I've already built for the level editor. As long as your program is structured ...Show All

• Smart Device Development Catch soft input panel event

  Hi all, Can you please tell me how can i catch the event when a user clicks on a key on the soft input panel in a PDA I am using VS2005 and Windows mobile sdk 5.0 Thanks Dhiraj Hi Dhiraj, We cannot get the "123" keydown event because this key will not cause an input. It is used to switch the input between alphabet to numeric one, just like another one beside the "Ctrl". And would you please tell me the reason that you want to catch the key down event of "123" We may find other solutions suitable enough. Thanks. Regards, Zero Dai - MSFT ...Show All

• Visual Studio Team System Migrating to Team System from an existing environment

  I'm new to these forums, and had posted the following in the Visual Studio Team General forum. It looks like this is the better place for this question. Sorry for the cross post. I'm looking for some strategy whitepapers or documents on how an existing development organization should go about planning a migration to Team System. My development organization has a bug tracking system, we have a source control system, we have testing tools, and project management tools, and we maintain and enhance existing products built with VS2003, VS6 (C++ and VB6), and a bit of Java. We know we will be moving to VS2005 at some point, and we have new needs that our existing bug tracking and testing tools will not handle. So Team System looks compell ...Show All

• SQL Server How to print labels like label 1 of 1 and label 2 of 3....

  I have a report that will be a label and I need to print N number of labels depending on a certain number returned from the query. Let's say that number returned is 3. So, on my first label I want to print 1 of 1 and on the second label, 2 of 3 and the third, 3 of 3. All other information on the label will be the same for all 3 labels. All information used is from the query. One of the fields accessed through the query holds the number I need to use to do this. Is there a way to do that through the report designer using vs.net Is there a setting for this or is it a SQL thing I need to put in the query some how. Or am I completely off track Any help would be greatly apprciated. thanks I don't hav ...Show All

• Visual Studio Team System Virtual Server in a Production environment

  Hi      I am planning on doing a dual server installation of TFS.My data tier is a real box, where as my app tier is a VM.I am going to be doing this in a production environment at my client's place. Microsoft recommends not to  run TFS on a VM in a production environment in the following article http://msdn2.microsoft.com/en-us/library/ms316494.aspx   Virtual PC Team Foundation Server servers will operate correctly on a Virtual PC or a virtual server. However, this configuration is not recommended for production environments. It can be used in evaluation or demonstration scenarios   Is there a specific reason why If so, what are the risks involved Could someone please hel ...Show All

• Smart Device Development Running a DLL like an EXE

  Hi, This may seem like a silly question, but is it possible to have a DLL just run by itself I know that the registered DLL will be accessed at startup by it's DllMain function (and then it's xxx_Init function... or is that wrong ), and this function will lock out all other processes. So I can't just go linking the rest of my program from there. But, is it possible to spawn a thread during the start up functions so that the program will continue to run Basically I want to just use my functions in a never ending loop in the background, so to write an EXE which just sits there calling the function seems a bit wasteful. Thanks for your help. Dan. This is normally done by writing a service. A v ...Show All

• Visual Studio Team System How to get the path to the build output directory during an unit test run.

  Hi, I'm trying to figure out how I can reach some XML files that is copied on build to the build output directory (bin/Debug or bin/Release) from inside an unit test. The TestContext property doesn't have any subproperties that's pointing to where the binaries were copied from before the unit test was started. Anyone who can give me a clue on how I can solve this Regards, Lars Wilhelmsen Senior Software Engineer Teleplan Globe AS Just found out that I could add additional files and folders that should be deployed by opening the test configration and navigate to the Deployment section. --larsw ...Show All

• Visual C# How to return and use a value from one method call to another

  Here is a rough scratch of my code which is much longer. Just focus on my question here, do not focus on correctness. Question/Problem: how can I pass the JAAlbum.ProductID to me second call to AddNewProduct for "Track" so that I can use its value in the call to  AddNewProductRelationship_Album_Track Right now, when I call AddNewProduct(xl, row, host, fileExtWAV, "Track", filePathSourceWAV, fileName, moveFile, sstore), the previous JAA.ProductID is lost but I need it ! foreach loop here {           if ((String.Compare(lastAlbumTitle, currentAlbumTitle,true) == 0) || (firstAlbum == 1))           {       ...Show All

• Visual Studio Express Editions MDI-Parent, creation

  I am trying to create a MDI-Parent container. I am having no luck at all. I have tried a few things and still get no place. I would put the code up that I have but I dont think were I got it from was even correct. My only request is I want to click on a menu button and open the form within the container. Right now I Click on a menu button and it opens up in a separate window. I want the program to look clean by having everthing contained.   Thanks for the help Public Class Form1 'DesignTime property for form1 IsMDIContainer= True Private Sub OpenChildForm() Dim f as New Form2 Form2.mdiParent =me Form2.Show() End Sub End Class ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 70 Balls colliding, physics sample

  Have fun going through my code but maybe you can get something out of it useful. Does pixel perfect collision and 'as good as I can make it' physics ball engine. 70 balls is about the max with the current setup, if you want to see the collisions better change the number of balls at the top. Let me know what you think. http://www.dxxd.net/keith/SpriteTesst.rar Nice program but the collision detection could be simplified a lot for round objects. You could replace the Collide function with this public bool Collide(Sprite target) { Vector2 v; v = new Vector2((target.Position.X - position.X), (target.Position.Y - position.Y)); float dist = v.Length(); if (dist < BALL_RADIUS) ...Show All

• Windows Forms How to serialize with TreeView?

  How to serialize with TreeView in .NET 2.0 Serializing is necessary when you want to write the data structure of a class/object to a file or transmitted over a network. Deserializing is the opposite, you have the data structure to populate a class/object from a file or network stream. ...Show All