GS80's Q&A profile

• Visual Studio Team System High SQLServer Memory Usage in LoadTest

  Hi, I am executing a load test with 8 webtests and 4 web test plugins, 1 for 2 webtests. In each of the plugin, I am pulling data from the SQL Server with select statement like "Select top 20000 from tablename"; and in the post webtest method in plugin, I am deleting the row which was used for webtests. While executing the loadtest I am seeing hight memory usage for SQL Server in taskmanager and in turn causing my system to be damn slow. How could I get around this problem Does my select and delete statements causing high sql activity Thanks. Yes, the load test plugin is the best option for cleaning up after the load test completes. You can also use the load test plu ...Show All

• SQL Server Copy Database wizard issue

  Despite the fact that both the package and the model db have the file locations set to e:\data\nnn, the SSIS package is creating / copying the files into C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. This is running as a job - could it be a security issue I don't see any warning / error messages that would indicate an issue. Update... This is sounding more and more like a bug. I changed the model db file locations to the c:\ drive (diff location but known access). no change I changed the destination file location in the wizard-created SSIS package to the c:\ drive. no change No matter what I do, the wizard insists on putting the files into the program files directory listed above. Both DB's li ...Show All

• Visual Studio Express Editions Saving Information

  Hello, I a making a program that will be opened once a day probably and some information will be imputed. How can I save the informaition to be used at a later date. I basically need to use something that is like a variable accept that the variable will be saved and after the program is closed and opened again it can be used. thanks Average Joe Thanks lot's for the links ahmedilyas, I read them and found lots of things that will help. I got my program working, at least the saving the information part. thanks Average Joe ...Show All

• Visual C# System command to throw an html file to ie/ff/opera/whatever

  Hi folks, I'm trying to open an html document with the following code : system( QString( "\"%1\"" ).arg(reportFile.name())); It * is * working but it takes ages (sometimes around 20sec to open a 2-lines html). I would like to know if anyone has a smarter way to do that. Thanks a lot ! Look at the System.Web namespace to work with anything web-related. You can obtain the html from an URL like this (from ondotnet ): public static string GetHTMLFromURL(string url)         {             if (url.Length == 0)                 throw ne ...Show All

• Visual C++ Problem of ActiveX

  When I am trying to call an ActiveX's method in my MFC application, it displays a dialog on the top of my application properly. But before it ends, the OS displays a dialog, which says "Another application is running, switch to ...". If I try to switch to others, everything is OK, my application continues to run. Could you tell me how I can avoid displaying the annoying dialog Why Thanks in advance. Thank you very much. I will try the solution you gave. But it is so strange that if I use VB to access the ActiveX and run the same method, everything will be OK. Could you tell me the difference ...Show All

• Visual Basic printing a hard copy

  So i have an app that has text boxes, labels, and comboboxes. the program populates a database. What i need to do now is Print a hard copy of the data (from a command button on the form) and send an email to someone (through Outlook).. Can anyone point me in the right direction on how to do this Thanks. Ian. this was very helpful THANK YOU! i was sending it to a .txt file and printing the .txt file but i think i will use this... THANKS AGAIN!!!!!! ...Show All

• Microsoft ISV Community Center Forums Projects, objects & modules

  I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Windows Forms MSDN Example can't compile

  I have cut and pasted all the code from a MSDN example ( http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx ) to VS 2005. I did as follows - New project/VC#/Windows Application (replacing any prebuilt code) , when I try to compile the code I get the following error: 'DataGridView' is a 'namespace' but is used like a 'type'. What am I doing wrong or missing If you start off with a new c# windows forms application this should work. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form ...Show All

• Visual Studio Team System In Project, can the Work Item ID field be editable?

  For some reason when a .mpp was opened, the Work Item ID field was blank. Though the project was connected to TFS and the other fields were available, the Work Item ID was blank and still 'read only.' Is there a way to make this field editable Mostly so we can enter the correct work item ID and publish back to TFS. hmmm.... I'm not interested in creating new IDs, the old ones are fine, but they need to be there to publish back to TFS. From my original post: [ ...when a .mpp was opened, the Work Item ID field was blank. Though the project was connected to TFS and the other fields were available, the Work Item ID was blank and still 'read only.' ] (Refresh did not correct the situation. ...Show All

• SQL Server How to list all history/snapshots of a given report

  We are running SSRS2005 and produce multiple reports. Our users need history report data so we set up snapshots executions to run weekly. How do we display the list of these historical snapshots to the users for selection Currently we code: http://myserver/Reports/Pages/Report.aspx ItemPath=/myreports/Available+Floor+Space&rs:Command=Render &SelectedTabId=SnapshotsTab That is not preferred as the user is presented the Report Manager interface and can go use other functionality such as subscriptions etc... that we do not support. Is there (a) a way to suppress the Report Manager controls or (b)another way to list the snapshots executed given a report name( maybe by querying the report server database ) or (c) code ...Show All

• Visual C# Help required to solve circular dependency problem in vb2005

  I am working on an application design that requires two projects to cross reference each other. I found the excellent Formfactory / Interface example/solution (listed below) on this forum. Unfortunately I am not C# literate. I understand and appreciate the method, but my attempt to convert it into vb2005.net has been defeated by the C# syntax. I would greatly appreciate someone (multilingual) providing a translation into vb2005.net Here is the C# solution: The pattern to solve this is abstract class factory , together with the singleton pattern. What you have to do is the make a classfactory for the forms . This classfactory you can place in your main program, which anyway MUST reference your assemblies, thus it w ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Joypad problems

  Hi have just set up C# EE and XNA game studio, no problems there. Compiled and run ok, but I get absolutely nothing from my Joypad, no buttons, no direction, nada..So am forced to use keys which respond fine The joypad works fine in other games, so is XNA only compatible with Xbox 360 joypads TIA Brian If you don't have the latest DirectX SDK you might want to download it and take a look at the DirectInput samples. They'll show you exactly what you need to do to get it running in your game. There's also a ton of resources available on the various game dev sites (you might start at GameDev.net). ...Show All

• Visual Studio 2008 (Pre-release) The certificate must have a private key. The process must have access rights for the private key.

  Hello All, I used makecert to generate a certificate named 'ServiceModelSamples-HTTPS-Server and installed it in LocalMachine\My store on the server. I used the FindPrivateKey utility to find the keyset file and gave full control to NetworkService, InternetGuestAccount and ASPNET machine account. I installed the certificate on my client machine as well in CurrentUser\Root as well as LocalMachine\My. My service is hosted in IIS and I have enabled 'Anonymouse Access' to the virtual directory and checked 'Accept Client Certificates'. I can browse the svc file to view the wsdl from the client machine. However, I get the aforementioned error when I run my client app and make a call to the method using the service proxy. My client ...Show All

• Visual Studio 2008 (Pre-release) Troubles on running WFC Lab 2 on June CTP

  Hi There I have trouble running the " CON002 Hands-On Lab Lab Manual Reliable, Transacted and Instrumented Messaging with the Windows Communication Foundation This lab is designed for use with the .NET Framework 3 Beta 2." On the June CTP of the .Net Framework 3.0. The lab works until taks 4. (the only thing I had to do is changing [ ServiceContract (Session = true )] to [ ServiceContract (SessionMode = SessionMode .Required)] However when doing taks 4 I get a bunch of errors when compiling: Error 1 The type or namespace name 'IRequestContext' could not be found (are you missing a using directive or an assembly reference ) C:\Data\Tests\TradingServiceV2\Cli ...Show All

• Software Development for Windows Vista How to prevent STANDBY and RESUME ?

  Vista has new feature in Power Management. I want to prevent STANDBY and RESUME from app. But WM_POWERBROADCAST message with  PBT_APMQUERYSUSPEND and  PBT_APMQUERYSTANDBY were not sent. I've read "Integrating-with-WindowsPowerMgmt.ppt". There are some explanation about the feature. Calling SetThreadExecutionState() does not work. Calling RegisterPowerSettingNotification() does not work. Does anyone know how to prevent Standby and Resume  Vista is build 5600.     it seems that vista rc1 will not send out the PBT_APMQUERYSUSPEND or PBT_APMQUERYSTAND when system is going to sleep. But it dose send out the msgs in vista 5456. anybody in MS who can give an explaination thank ...Show All