redneon's Q&A profile

• SQL Server Different results with sproc as opposed to simple SELECT (parameter values)

  Could someone please tell me why the following SELECT statement... SELECT ID, SpecimenNr, ScientificName, Locality, Taxon FROM petrander.QueryView WHERE (InstitutionCode = 1) AND (Collectioncode = 1) AND (ScientificName LIKE N'%le%') AND (Locality LIKE N'%Fakse%') AND (22 IN (ParentID1, ParentID2, ParentID3, ParentID4, ParentID5, ParentID6, ParentID7, ParentID8)) ...gives me 9 rows back, but embedding the exact same statement in the following sproc... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [petrander].[DynamicQuery] @taxparent int = NULL, @museum int = NULL, @collection int = NULL, @binomen Nvarchar(254) = NULL, @locality Nvarchar(254) = NULL AS SELE ...Show All

• Visual Studio Team System TF30169: The New Team Project Wizard was unable to download the process template (NEW PROJECT)

  Hi, I have been working on Process Templates for a while and uploading new versions have working very well. A few weeks ago I installed BETA on SP to test Custom Controls within the process template forms. The TFS BETA was installed on a test server with it's own TFS installation, and not on my developer PC. - Visual Studio 2005 Service Pac 1 Beta - Visual Studio 2005 TFS Service Pack 1 Beta But when I discovered I couldn't upload process template for regular TFS servers (without SP1 Beta), I removed VS 2005 completely (I think) with SPs and Team Explorer from 'Add and Remove programs", and reinstalled the full package. I'm able to upload the new process templates successfully, but Im getting an exception when tring to cre ...Show All

• Windows Forms ConfigurationManager

  I'm trying to teach myself about ConfigurationManager. I am using VS2005 Standard Edition & C# & .NET v 2.0.50727 I have added to the op of my unit: using System.Configuration; using System.Configuration.Assemblies; My Problem " ConfigurationManager " is not listed in intellisense. When I try to use it as a Type, I get the error "The name 'ConfigurationManager' does not exist in the current context" I am totally puzzeled! Anyne know why I can't use Configuration Manager. Is it supported by the StandardEdition Thanks ...Show All

• Windows Forms checkbox in a combobox

  Hi, I want to have a checkbox in a combobox in VC# .... similar to what has been explained in the article . http://www.codeproject.com/combobox/checkcombo.asp . I desperately need help. Thanks in advance. Saania You'll need to roll your own. None of them will be too easy nor too hard. The combo box supports user draw so you could set DrawMode to user draw and then manually draw the control. You then have to override the default processing such that clicking on the checkbox would check or uncheck the box rather than collapse the combo. Alternatively you could create a custom control that consists of a text box and spinner. Whenever the user clicks on the spinner display a CheckedListBox ...Show All

• Visual Studio Tools for Office The default behavior to click and open a ".dot" file

  I developed a word template, mytemplate.dot, using VSTO. When an user clicks the "mytemplate.dot" file, I see two different behaviors on different machines: 1: The word starts with "document1.doc" as the default word document name. 2: The word starts with "mytemplate.dot" and tries to update the template. The second behavior is not what I want. How to avoid the second one progrmatically with VSTO Thanks, Yuhang. You can't change the second behavior, as this is a problem with the profile's Windows configuration. To see what I mean, right-click a *.dot file in Windows explorer. When things are configured according to the installation default, NEW should be bo ...Show All

• SQL Server Setting up Query Notification and Performance issue

  We are in development stage of an application which uses Query Notification feature of SQL Server 2005. When the development started what the development team did was, they just Enabled broker on the database by SET ENABLE_Broker statement and they started using Query Notification. Now the application is in testing phase and when we test with many user, the performance is really slow. What i want to know is , when we use Query Notification what all are the setting to be done at the database level. Is this setting enough. And also how can i tune this system. any useful link is appreciated. thanks in advance Madhu     I'd recommend first to investigate the performance problems and find the cause. The BOL has a tro ...Show All

• Visual Studio Express Editions How to make a instant messenger?

  Hey everyone! I was wondering how I would go about devloping a instant messenging program in VB Express 2005 also maybe making it possible to have it where you must sign in inorder to chat, Thanks! I am not much of a network programmer but this is how I make my applications talk with each other. Setup a free e-mail address with some random provider. Use the computers host name as the "screen name" Dim ComputerName As String = System.Net.Dns.GetHostName() Send an E-Mail to the address you created with the following properties Subject:(ComputerName) Contents:(The Instant Message) _____________________________________________________________ Set a timer to every 2 ...Show All

• Visual Studio Testing a web site Using Visual studio 2005

  Hi, i m using visual studio 2005 build in feature to test the website, adding the new test to the solution by going in the test menu is gud.. but when i right click on the test and say new test, i dont find any web.test in the dialog only two options, which i get are orderedtest and unit test. i m using visual studio 2005 team suite but cant find the web.test .... do i need to download this addins or whts the solution... Hi ameyayashu, Your question is not related to GAX/GAT, please post it to a Visual Studio forum. thanks, -Victor. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3d multiple model help

  i have 2 models in my game loaded. where one of the models is a gokart and camera follows it from behind. the second model is the track. when i controll the kart the kart moves but the track model stays still. how do i overcome this. this is the code for drawing the track model.(just the track model not the kart) private void DrawModel( Model m) { Matrix [] transforms = new Matrix [m.Bones.Count]; float aspectRatio = graphics.GraphicsDevice.Viewport.Width / graphics.GraphicsDevice.Viewport.Height; m.CopyAbsoluteBoneTransformsTo(transforms); Matrix projection = Matrix .CreatePerspectiveFieldOfView( MathHelper .ToRadians(45.0f), aspectRatio, 1.0f, 10000.0f); Matrix view = Matrix .CreateLookAt( new V ...Show All

• .NET Development how can i manage different framework versions with vs2005 ide

  i have currently vs2005 running on my machine. i want to install .net framework 3.0. then how can i configure my ide to run with version 2.0 later for my production . Visual Studio 2005 is designed to run on the .NET Framework 2.0. The .NET Framework 3.0 installs the .NET Framework 2.0 behind the scenes and also adds some new technologies (such as Windows Presentation Foundation, Windows Communication Foundation, Windows Workflow Foundation and some others). You can safely install the .NET Framework 3.0 on a system with Visual Studio 2005 and it will not interfere with the IDE. If you would like to use VS 2005 to develop applications that specifically target the .NET Framework 3.0, you will need to install one or more of the following ...Show All

• Visual Studio Sandcastle - How to prevent generation of C++ and VB syntax?

  Hello, Is there a way to prevent generation of C++ and VB syntax Thanks a lot! Jose Have you tried removign it from the sandcastle.config file <component type="Microsoft.Ddue.Tools.SyntaxComponent" assembly="..\ProductionTools\BuildComponents.dll"> <syntax input="/document/reference" output="/document/syntax" /> <generators> <generator type="Microsoft.Ddue.Tools.CSharpDeclarationSyntaxGenerator" assembly="..\ProductionTools\SyntaxComponents.dll" /> <generator type="Microsoft.Ddue.Tools.VisualBasicDeclarationSyntaxGenerator" assembly="..\ProductionTools\SyntaxComponents. ...Show All

• Windows Forms How to Validate a Serial Number or PID in MSI Setups Created in VS.NET ?

  I have been searching all over the net, and I can't find this information. I want to validate a PID before the installation proceed (as most of the microsoft setups). I want to do this in C# but I can't find the pieces of the puzzle. scenario: call a web service when the user hits next, if the returned value is Ok the setup may continues otherwise not. That easy. Thanks for any help! mario Visual Studio doesn't have any support for custom actions in the UI sequence. It seems to very common for people to start building setups with Visual Studio only to find out that it doesn't support what they want to do, and in fact Visual Studio probably has fewer features than most other install tools that build MSI files. There's a reaso ...Show All

• Gadgets Looking for an experienced Gadget Developer

  Hello all, I am looking for an experienced Gadget Developer. Please have examples ready to show of your previous work creating gadgets. Interested parties please email me at the email in my profile. Thanks. ...Show All

• Visual Studio How to add a file and project reference

  My project creates a class library and a website. I am using the sample that installed itself and modifying it as needed. My samplesolution.vstemplate has the following entry to create my solution: < ProjectTemplateLink ProjectName = " APP_BL " > Projects\ClassLibrary\ClassLibrary.vstemplate </ ProjectTemplateLink > < ProjectTemplateLink ProjectName = " $WebSiteName$ " > Projects\WebSite\WebSite.vstemplate </ ProjectTemplateLink > There are certain dll's that I would like to reference in both the APP_BL library and the website that gets created. I also would like to reference APP_BL in the website as well. I have been unsuccessful in trying to implement Microsoft.Practices.RecipeF ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bug where it becomes impossible to save your files

  Hi all, Has anybody encountered a bug where somehow XNA game studio express doesn't allow you to save your files I've encountered it once (and I forgot the message it popped up unfortunately), but I thought it was a one-off thing. Then a co-worker told me he got it quite regularly when starting and stopping programs. Just wondering if this is something that more people are experiencing. At the time I had two XGSE's open, one with my (saved) project, and one with a temporary spacewar project. Unfortunately when I was trying to repro this bug, I couldn't get it to do this again. My co-worker gets it when editing files while the program is running. Cheers, Nick Waanders This occurs in C# Express correct This ...Show All