B.Lee's Q&A profile

• SQL Server PIVOT question

  I have a basic table consisting of several thousand records. Im trying to generate a pivot query for a report. the table consists of records, each of which has a recieved date ( small date time ) and a tranactioncount ( int ) . Im looking to generate a PIVOT to show the show the month and year counts for the files recieved ie YEAR | JAN FEB MAR APR etc 2004 ! 2 34 67 43 2005 | 12 2 3 1 can anybody explain in laymans terms how to do this Thank you in advance To do this in 2000, check out my reply of this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=249991&SiteID=1 ...Show All

• Visual Basic Automate MS Word Doc with VB.Net

  I amtrying to pull info from a Sql Server to populate a word Doc using a VB.Net App any ideas Dim LPC As Word.Document PolNumber.DataBindings.Add("Text", PolicyNumber1, "Policy.PolicyNumber")   Well i binded the data to the textbox but what should i do to make the data show up on the ms word doc ...Show All

• Visual Studio Team System Cannot jump into the source file

  Hello, I get a warning and try to jump into the source file (via link). This brings the following error: "Could not start Microsoft Visual Studio. Try specifying an alternative source coding editor in Applicaton Settings". Does anybody have an idea about the problem Thank you VP What Visual Studio versions have you installed Were any running when you clicked the link Does this this happen everytime you click the link ...Show All

• Visual Studio Express Editions Converting String to Double or Int

  I am working on creating a program that calculates the area of a rectangle. The program has two textboxes and a button. When the button is pressed, I need to convert the strings to numbers according to type (ie if it's a double, i need it to be a double...integer to int) In my class file, I have three constructors 1. Takes two integers <-returns integer 2. Takes two doubles <-returns double 3. Takes an integer and a double <- returns double I tried writing something similar to what is below to try to define the variables but it didn't work. if (textbox1.text.contains(".") double width = Convert.ToDouble(textbox1.text) ...Show All

• Windows Forms Server Setup Package Taskvision 2.0

  On the WindowsForms.Net site there is a new release of TaskVision built on .Net 2.0. The description states the following: Task Vision - WinForms PM The TaskVision application demonstrates a full n-tier application for the management of personal and business related tasks. The sample comes with a ready to run demonstration client, full client source code, and a server setup package for running a private task server . My question is...where is the setup package. The download either does not contain it or I am overlooking it. It seems that we need to wait them release this based on ...Show All

• Visual Studio Team System Trouble when running load test case

  Hi, all When I run my load test case, I meet an error as "Error testsapiload TestProject1 (Computer MSNTC-JUSTIN) Could not access the load test results repository: Invalid object name 'LoadTestBrowsers'. " These cases runs well in another computer that just installed the sqlexpress. In the computer which report the error as above , I have also installed the sql server 2005 for some reason, not just the sqlexpress. Could someone help me to solve this problem Have you ever successfully run against this machine Check to see where the results repository connection string is pointing. Do this by opening the Adm ...Show All

• Visual Basic inheritance picker

  Is inheritance picker available in 2005 Beta express I can't find it I have the same problem overhere. I do not find the Inheritance Picker. I followed first this example ( http://www.akadia.com/services/dotnet_inherited_forms.html ) and after that I followed the MSDN one   ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbwlkwalkthroughdemonstratingvisualinheritance.asp ). But I always got stuck on the point when you had to select the Inheritance Picker. Can someone help us out Thanks a lot! X ...Show All

• Smart Device Development VS 2005 beta2 - Referenced package not found

  I have just installed VS 2005 beta2. I created a smartphone application with a simple textbox and when I try to run (F5) using emulator I get a deploy error. The output log shows: SMP1 -> C:\dev\SMP1\SMP1\bin\Debug\SMP1.exe ------ Deploy started: Project: SMP1, Configuration: Debug Any CPU ------ Referenced package not found. ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Any ideas Hi, try to rename directory C:\Documents and Settings\<user name>\Local Settings\Application Dat ...Show All

• Windows Forms Profiles failing to update a Click Once application

  The scenario: We have a Click Once application deployed to 70+ machines. This deployment site has been active since mid November 2005. There are multiple profiles on these machines totaling easily 140 profiles. There are profiles on each machine that are used more often than others. We push patches to the deployment site regularly, sometimes multiple patches in a day. The application checks on startup for patches. Typically a profile is logged in once a day. So the possibility exists that a profile may be logged in while multiple patches are pushed. The problem: Recently it was determined that three profiles, two on o ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Positioning a sprite.

  This is my first real directX attempt, and it doesn't seem to be going too well. Here's my "render" method, that gets continually called. (C#)             device.Clear(ClearFlags.Target, System.Drawing.Color.Blue, 1.0f, 0);             device.BeginScene();             Bitmap grass = new Bitmap("c:\\grass.bmp");             Texture texture = new Texture(device, grass, Usage.None, Pool.Managed);         &nbs ...Show All

• SQL Server How to Select Delimiter in 'Results to File'

  I want to use custom delimiters for different queries when I send the results to files. However, that choice seems to be missing from the menu in Management Studio: Tools>Options>Query Results>SQL Server. There is a Genereal tab, Results to Grid tab & Results to Text. What's up Tommy - In SQL Server Management Studio 2005, click on Query on the menu, Results To, then Results to File. ...Show All

• Windows Forms Source path of installation

  Hi, How can I know from Installer class what is path of setup files Thank's Alexei I used this code to find the relative path to the newly installed Assembly, perhaps it will help. string Path = this .Context.Parameters["assemblypath"];   -tdaley ...Show All

• Windows Forms how do I respond to events from a dynamically created control?

  I'm still relatively new to the .Net world so forgive me if there is an obvious answer to this question... I have a form with a dynamically created listview control.  I would like to respond to this listview control's events (i.e. double-click, sort, etc).  However, I don't know how.  Should I consider using delegates   If so, how Thanks in advan ...Show All

• SQL Server Visibility of a matrix column base on parameter selection

  Hi, I have a matrix, with 1 row group and 1 column group and 4 static columns, is there a way to hide the static columns base on the selection of a multi-value parameter Like creating a group for the 4 static columns Is that possible This is an urgent matter, any help would be very much appreciated. Thanks, Cheng You cannot hide individual static columns in a matrix - the closest you can get is to hide the dynamic column group conditionally (which will then also hide inner static columns). -- Robert ...Show All

• Visual C# How to Check that a File is Open

  I have a file that needs to be changed with StreamWriter every time I run the program.  If this file is open in Excel the there is an exception called of type System.IO.IOException: the process cannot access the file because it is being used by another process . at System.IO.__Error.WinIOError(Int23 errorCode, String maybeFillPath) but no exception is thrown when the file is open in WordPad. Is there a way to check that the file is open in Excel before the file is written Ben Enfield ...Show All