Evan Hennis's Q&A profile

• SQL Server retrieve the value that occurs the most

  Hi, I am trying to retrieve the value that occurs the most at a dimension level. For example, I have to analyze the product type mostly used in a specific target segment by number of products. The mathematical function normally used is MODE. However, in AS2005 there is not such function. I tried to use TopCount but it is not as easy as I thought. Any suggestion Thanks! I think TopCount would only get you a mode if you were to use it against a count measure. I am guessing that you want to find out which member from the product dimension has the most transactions against it for a given set of criteria. Depending on the granularity of your dimensions you may have difficulty doing this with ...Show All

• Windows Forms Key, Tag to store the primary key in listview against the item we load.

  Hi all, I am loading data in listview conrol. In that i want to store the primary key in listview key or tag property something else. I want to display the name in that listview . Any one can help me Regards, sureshp Surezhp wrote: I am loading data in listview conrol. If you can show the code that loads the data...We should be able to show you how to put the pk in the tag ...Show All

• Visual Studio Printing without the ReportViewer

  In a Win Forms app, is it possible to print a report without using the ReportViewer control I want to provide a print button on a Form (like Outlook does) and then use an embedded Report to print the data so I don't really need the ReportViewer. I would want to display the PrinterDialog though and use the settings from here to control the printed Report. Is this possible too Regards Graham Well, I'm so close yet so far. I have found the GetPrintDocument method  on the Viewer and I thought I could do something like: All in code... 1. Create a ReportView Control. 2. Set the LocalReport properties for the report datasource and resource 3. Create a PrintDialog control. 4. Set the printDialog.Documen ...Show All

• .NET Development FtpWebRequest

  .NET Framework 2.0 c#   I need to access a FTP Server. I'm using FTPWebRequest as described in visual studio 2005 documentation. Everything works fine except the following: 1) I dont know how to change de current working directory on the server to the parent directory 2) Why cant I do this, or why doesn't work In Internet explorer works! 3) how can I send some FTP low levels commands to the server using .net 2.0 ftp api. <some code...for FtpWebRequest> FtpWebRequest ....Create(" ftp://192.168.1.4/../ret "); thanks Jose Cruz How can I log in when username includes "@" like this... username: user@domain.com" password: pass server: myFtpServer   Code would ...Show All

• Visual Studio Team System about the method VisitCall

  I found there is a visitcall method that can be overrided. but how to use it what are the parameters mean public override void VisitCall( Variable destination, Variable receiver, Method callee, ExpressionList arguments, bool isVirtualCall, IProgramContext programContext, IExecutionState stateBeforeInstruction, IExecutionState stateAfterInstruction) i found some code block example blew: IStronglyConnectedComponent component1 = programContext.get_ControlFlowGraph().get_StronglyConnectedComponents().SccForBlock(programContext.get_Block()); if (((component1.get_ContainsCycle() && callee.get_IsSpecialName()) && (callee.Name.get_Name().StartsWith( "get_" ) || (callee.Name.get_Name(). ...Show All

• Software Development for Windows Vista Netfxlive off?

  Hi, I can't access www.netfxlive.com . The problem is with me or the project is off It can be access by the IP - and should be up by EOD today. http://72.232.20.154/ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you implement Fog into a scene?

  Hi All, I have finally got some 3D up and running so things are whizzing about (which is always fun to watch... for a while, yeah I know, small things...) and I was wondering if anyone had any examples of putting fog into a scene. I tried last night and succeeded in turning all my meshes to white, not matter how far away they were from the camera. No matter what I did to the values, nothing changed. As always, any help is greatly appreciated. Cheers Its not like a bunch of artists got together and decided that 0..255 is the most artist friendly colour range around. 0..255 is only used because it is common to represent images in 24 bits (32 bits with alpha or padding) with 8 bits per colour component and 255 is the maximum ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using Game (and GameComponents) in a Windows Forms editor?

  Hi I just started looking at XNA, and I've assembled a small team for the DBP contest. The first thing I'm trying to do is to make the game run inside an editor, because I'm pretty sure it'll be very useful. However, looking around at the different solutions that people have come up with for running XNA in a control, it seems none of them are using the Game class. And on Shawn's (who is a developer of the XNA framework ) blog, he writes: "If you want to render into a custom window, don't use the Game class. It will be much easier and more reliable to directly create your own GraphicsDevice object." This, in turn, makes it impossible to use GameComponents. But it would be nice to use GameComponents that other people have created ...Show All

• Gadgets Sidebar gadget and IE interaction

  I'm having this problem between the sidebar gadget and IE: For example when I log in on YouTube with IE it reminds me logged in but when I try to access YouTube from my sidebar gadget I'm not logged in any more. But if I debug the gadget on the IE it works. Does anyone know why is this happening and how to solve Simplified, what I want to do is log in on IE and use this "login" on my sidebar gadget. Is this possible Ty you are right, this solves my problem, but it's not funny to ask the user to disable the "Protected Mode" and see that message in the IE all the time. ...Show All

• Visual Studio Express Editions HELP - Lost default browser

  Please Help. Running Visual Studio 2005 Express - and it's great. All was running fine. It was using Mozilla as the default browser. I have replaced Mozilla - the Debugger still tries to start Mozilla and gets in trouble (can't find the file - it's gone). I have used the new browser FireFox to re-set the system default browser to FireFox -but- the VWD-2005-Express still tries to start the old Mozilla browser..... How can I tell Visual Studio 2005 Express to start the now current default browser FireFox Thanks in advance, Paul I marked this reply as Not Helpful - it referees me to some drivel about Register entries and the .Net Framework - - - I ask about the Visual Studio 2005 Express and (not being a gre ...Show All

• SQL Server why can't I CREATE ASSEMBLY on stdole.dll ???

  when I run ... CREATE ASSEMBLY asm_stdole FROM 'E:\sql\stdole.dll' I get the error ... Warning: The Microsoft .Net frameworks assembly 'stdole, version=7.0.3300.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' you are registering is not fully tested in SQL Server hosted environment. Warning: Assembly "stdole" was built using version v1.0.3705 of the .NET Framework. SQL Server currently uses version v2.0.50727. Msg 6215, Level 16, State 1, Line 1 CREATE ASSEMBLY failed because method 'Next' on type 'stdole.IEnumVARIANT' in safe assembly 'stdole' has invalid attribute 0x1003. First up to the plate, Derek Comingore sqlgeek lol.... okay now seriously.... you are receiving several errors as y ...Show All

• SQL Server WSUS reconstruct the environment

  Hi All Im a new comer to the site and wsus. I inherited a functional wsus server it was great but due to a demand for improved reporting features I attempted to install the Wsus rollup reporting sample. Im uncertain as to how but I hashed up the installation to the extent that it corrupted the MSDE installation. It was suggested I remove wsus and reinstall. At this point I made another error. I was told that WSUS 3 had improved reporting features (and indeed it does, its infinitely better in that respect) so I signed up with Microsoft and downloaded the installation file. WSUS 3 uses SQL 2005 for Windows so my back up of the MDF & log files were rendered useless. I have since removed WSUS 3 reinstalled a fresh copy of WSUS Sp1 and run ...Show All

• SQL Server Freeze panes when report is exported to Excel

  I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel I have the feeling the answer is no, but I thought I'd check. Hi, there is a property named FixedHeader. I didn’t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn’t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel) HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# Generics in C# - new() cnstraint

  Hello...   I am trying to play a bit with the generics feature of the .Net 2.0 Framework and I ran into this "Problem"   I try to create a Singelton Base-Class, which will create an instance of itself if the instance is accessed. Since I want to create an Instance of <T> inside my generic Base, I need to supply a new() contraint to <T>. This "forces" me to create a public constructor, since that what new() means.  I think the scope of new should not be "public" but  "protected". Protected would allow me to hide the constructor from the outside world, but it would still allow the creation of the class inside the baseclass. Since I am not able to do this, a direct creation of my Bas ...Show All

• .NET Development Bad Variable exception, when using an ActiveX on WinForm as a seperate Thread.

  Hi, I have typical problem which i am trying for past 4 days. I am newbie to .NET world. I have a ocx component which i have to use in C#. So i hosted it on a winform and can use it without problems. How ever if i make this Winform as a seperate thread and use the same interface which is worked in above case(Winform as not a seperate thread) it is giving BAD VARIABLE TYPE exception. I have used BeginInvoke and delegate method in MainThread to start execution of the member function in WinForm thread. And in Debug->Threads window i can see thread switch happened without any problems. How ever when we call the interface it throws the exception. I tried to debug the ActiveX code. It fails in ForwardCalltoInvoke... method. I dont understand ...Show All