Anmol Ranka's Q&A profile

• SQL Server Registering AdventureWorks

  The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:\ProgramFiles\Microsoft SQL Server\90\Tools\Samples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection P ...Show All

• Visual Studio Team System Renaming column names in Query

  Is there a way to rename a column name in a query I have a different Priority field in our WorkItem type called DashPriority but as far as the User is concerned it is Priority. When I add Dash priority to the a Work Item Query it displays "DashPriority" as a column header. I am sure most people want to rename these column headers but I can't seem to find where to change them. I do not think there is a way. I did a quick look into code but I do not see any apparant way to enable users to specify different friendly name in query result headers. We have reference name & friendly name for this purpose. Just curious, supposing we provide such feature, where (in UI or otherwise) do you think is best place for your to co ...Show All

• Visual Studio Express Editions How to open a specifided folder in the windows explore?

  How do i open a specified folder in windows explore - if its possible :D Hi, try System.Diagnostics. Process .Start( "c:\MyFolder" ) or, for some of the predefined folders: System.Diagnostics. Process .Start( Environment .GetFolderPath( Environment . SpecialFolder .MyDocuments)) Andrej ...Show All

• .NET Development Using XML with GridView

  I have a xml file that I'd like to display in gridview, but am having trouble getting it to work. When I hard code it, it works fine, but I want to modify the xml file and refresh the gridview. When I try to dynamically bind the xml file to the gridview, I get nothing. The gridview simply doesn't show on the page. I'm not sure where this question is suppossed to be asked, but since there doesn't seem to be a forum for web forms or gridviews in particular, I'm guessing this one. Anywhere, here's the code xmlDoc.Save(MapPath("XmlDocument.Test.xml")); DataSet oDs = new DataSet(); oDs.ReadXml(MapPath("XmlDocumentTest.xml")); GridView1.DataSourceID = oDs; GridView1.DataBind(); Can anybody explain w ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Normal Map colour directions.

  Hey, I've been tyring to track down a couple problems I've been having with rendering normal maps. First of all, I have these shaders that I have programmed previously that take a tangent space normal map and function 100% correctly. If I move those shaders and normal maps onto an object in Game Studio I find a number of issues. The normals in the normals map seem to receive the light from the wrong directions, the flat surface areas are lit correctly though. So I was wondering if which directions the normal map need to be, Red left or right, Green up or down. I've tried a number of different arrangements and orderings of my Normal, Binormal and Tangent matrix. The second problem is I find that the Binormal and Tangent data changes d ...Show All

• Visual C++ Asynchronous Sockets in C++?

  Hello, I want to use asynchronous sockets in pure C++. Is there anyone to tell me how to do it or at least show me a basic example The external libraries are appreciated too. Thanks... Winsock definitely http://msdn2.microsoft.com/en-us/library/ms741394.aspx ...Show All

• Visual Studio 2008 (Pre-release) Item Activation in ListView

  Hi, I was hoping for some kind of ItemActivated event in the ListView class, but cannot see one. I want to be able to detect users double-clicking or otherwise activating an item in the list view. What is the simplest way to achieve this I tried the ListView.MouseDoubleClicked event but that of course fires anywhere in the ListView. There is the ListViewItem.MouseDoubleClicked event but that only works for double-clicking, not for pressing enter on a selected item. Thanks, Kent Boogaart Hi Rei, Ironically, you posted that right as I was finishing a post for my blog: http://kentb.blogspot.com/2006/12/listviewitemactivated-event-in-wpf.html I believe my solution to be a little cleaner as it ...Show All

• Gadgets Gadget creep

  Just an observation, but... Has anyone else noticed that Gadgets move of their own accord when Sidebar loads For instance, if Sidebar is closed by DEP, Gadgets randomly creep to the left when it restarts. Then there's the order on the Sidebar itself. If you shutdown/restart or exit and reload Sidebar, the attached Gadget order changes occasionally. I'm not sure this is the same issue - I'm pretty sure I didn't see a six-pixel shift in my test, that would have been much faster and more noticable drift. Thanks for the follow-up, and I will look into it as well. ...Show All

• Software Development for Windows Vista Hosting STS in IIS7

  Hi, I'm trying to host my STS (based on the original one from STS sample) in IIS7 (on Vista) with no luck. Sending my token to the RP fails and I have "There was a failure making a WS-Trust exchange with an external application. No suitable endpoints were found for the service at address http://www.fabrikam.com/TokenService/STS.svc/sts ." in the Event Log. Here are endpoints for the service: < endpoint address = " sts " contract = " Microsoft.ServiceModel.Samples.SecurityTokenService.IWSTrustContract " binding = " wsFederationHttpBinding " bindingConfiguration = " SelfIssuedSamlBinding " > </ endpoint > < endpoint address = " mex ...Show All

• SQL Server can SQL Profiler ('05) look into User Defined Functions (UDFs)?

  particularly table valued UDFs that may cause other udfs, etc. what settings/events do I need to see inside and get each statement or at least each seperate UDF that is executed internally ...Show All

• Visual Studio Express Editions Wav

  How do i add a wav sound to my windows form, thats starts up automatically Very similar to the Windows XP Tour. well you simply add the external file and set it to "copy to output" I think... or copy locally. So in your solution explorer, right click your project, go to add > existing item, and select the wav file. Once done, you can either use the SoundPlayer class to play the file (but I believe the wave file has to be within a certain number of seconds otherwise it won't play). To play the file: Dim theSoundPlayer as new System.Media.SoundPlayer(Application.StartupPath & "\ fileName.wav ") theSoundPlayer.Play() and thats it! if you had a longer wave file then I'm not sure exactly how yo ...Show All

• SQL Server SQLDumper errors in event log

  Hi All, I see a lot of errors in event log. I am running SQL Server2005 on Windows 2003 server,  The details of the error posted below.  Somebody please tell me the cause and remedy for this error.  Thanks in advance. Error: ------------------------------------------------------------------------------------------------------------------------------ Event Type: Error Event Source: SQLDUMPER Event Category: None Event ID: 5000 Date:  9/18/2006 Time:  10:10:09 AM User:  N/A Computer: <> Description: EventType sql90exception, P1 sqlservr.exe, P2 2005.90.1399.0, P3 434f82e9, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 00000000, P9 a1a ...Show All

• Internet Explorer Development IE7 and page-break-before

  I have some code that uses page-break-before: always that works fine in IE6, but in IE7, the page-break-before is ignored. Was there a change in this behavior that I have not seen documented Thanks again Microsoft! As a web developer, I love to hate your browser. I code everything in Firefox and test it all in Internet Explorer before publishing it of course. This is when I find out how much Internet Exploder messes up. Please. Invest some time into Internet Exploder. BTW, Firefox has an automatic spell checker built into the textareas on web pages. ...Show All

• Visual C++ Import Native C++ dll in Managed Project

    I have some code which needs to be native that I am trying to include in a managed c++ project via a pluggin. It can't be added to references. The syntax for loading it manually, [DllImport("ArmWrp.dll")], is fine, but the functions cannot be found. Here is the simple pluggin, it is compiled with the unicode setting: // ArmWrp.cpp : Defines the entry point for the DLL application. // #include "stdafx.h" #ifdef _MANAGED #pragma managed(push, off) #endif BOOL APIENTRY DllMain( HMODULE hModule,                        DWORD  ul_reason_for_call,          &nb ...Show All

• Visual C++ crt_time.cpp(27) : error C3861: 'exit': identifier not found

  Hi All: The story so far: This is the third time I've tried to Install C++ 2005 Express. It is Not Very easy to install. Also diffcult to compile. The sample program source is from: http://msdn2.microsoft.com/en-us/library/a442x3ye.aspx Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50727.42 for 80x86 Copyright (C) Microsoft Corporation. All rights reserved. crt_time.cpp crt_time.cpp(27) : error C3861: 'exit': identifier not found crt_time.cpp(40) : error C3861: 'exit': identifier not found F:\PROGRA~1\MID05A~1\VC\bin>snap REM CRT_TIME.CPP 4:01 PM 6/24/2006 // Sample from: http://msdn2.microsoft.com/en-us/library/a442x3ye.aspx // http://lab.msdn.microsoft.com/productfeedback/viewfeedback ...Show All