Gurpreet Singh Gill's Q&A profile

• SQL Server Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. Your variable @q must be of type ntext, nchar, nvarchar to be used with procedure sp_executesql. Change your variable from the current varchar to nvarchar. ...Show All

• Visual Basic COM Object BeginInvokes at Program Close?

  We're writing a program where we have a COM object that is created and used several times through the runtime of the program. I'm finding, though, that I get this bizzare error after closing the program. I've verified that this error comes after an Application.Exit() call, and the stack trace doesn't involve any of our code, so I have no idea how to diagnose this (if I could just supress it, I'd be fine, since the program can finish closing after I hit F5 when the exception comes up in the debugger). Yeah, I had tested that and it didn't change it, but... I found when I was digging through some of my collegues code that he wasn't disposing of a dialog that had a COM object on it. We didn't think much of it at the time, probably, because w ...Show All

• Visual Studio Express Editions Crawling text on form

  I need to make some text crawl across the bottom of my form. What's the best way to do that and set crawl speed Thanks ! You can do it in a couple of ways. 1. Use and existing marquee control - there are a number available for free which will give you canned functionality to use. A simple web search on VB.net + Marquee control will reveal some. Example http://www.freedownloadscenter.com/Programming/ActiveX/Marquee_Label__Net_Component.html 2. Write your own functionality. This involves a timer event and a label. What you will do is set the timer interval property and in the timer tick event modify the .left property to move the label. You can either increase the value to move it to t ...Show All

• Visual C# CAN I MODIFY THE WEB.CONFIG IN RUNTIME?????

  HI I HAVE A QUESTION, I WANTO TO MODIFY THE WEB.CONFIG IN RUNTIME WITH A ASPX, AND I WANT ADD MORE TAGS THE WEB.CONFIG....... IS IT POSSIBLE THANK YOU FOR YOU HELP......... hi Derek well, in my application i can read the web config and modify also but i have a problem when i give it the rout or path to file, the problem is that i have not permission for overwrite or keep this file do you know for what ...Show All

• SQL Server Filtering Measures by Measure Groups

  I'm trying to create scripts to convert foreign currencies. I would like to create the script so that the measures are not hard coded but would be specified by MeasureGroup, something like the following: Filter([Measures].AllMembers, Measures.CurrentMember.MeasureGroup = "Policy Measures") Is it possible MeasureGroupMeasures (MDX) Returns a set of measures that belongs to the specified measure group. Syntax MEASUREGROUPMEASURES ( MeasureGroupName ) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Initialize(), LoadAllGraphicsContent(), Unload()???

  Hi Guys, Just wondering if anyone could explain to me what is meant to happen in the Initialize and LoadAllGraphicsContent() methods in the skeleton source code. In particular I am unsure about what goes into the normal constructor and what goes into these two methods and what is the difference between each of those methods. Are these methods called only once at the start of the program or are there many calls to these methods Thanks for any help offered Jim Perry wrote: Initialize is called once at program startup. You can load any non-graphics content there - sounds, data, etc. LoadAllGraphicsContent is called whenever it's needed, when the graphics device is recreated for some reason, which mea ...Show All

• Visual Studio Team System Advice on moving TFS to new domain - easier to simply reinstall?

  Hello, I have a Team Foundation server built out on a Win2003 dedicated machine. Currently, this machine sits in our development/QA domain named Ecomqa. I have full control of this domain, so have (and can) set up domain admins, etc for testing purposes. I installed TFS on this machine purely as a trial for our team to learn how to use and mess around with. Right now there's really nothing to lose on this server if TFS disappeared - although reinstalling takes time (i.e., there's no project data, etc worth saving right now). The TFS was installed with an Ecomqa domain admin account. The issue is, all of our team's user accounts lie on another domain called BIZ, which we have no control over. BIZ does not trust Ecomqa, but Ecomqa t ...Show All

• SQL Server SQL Server 2005 on Vista RTM problems

  Hi there, I'm trying to install SQL Server 2005 Developer Edition on my Vista Ultimate laptop, but it won't fully install. The database engine seems to be running, but I really need Management Studio (client tools) and Books Online. But this feature just won't install. I've even enabled the administrator account and tried it there. It also keeps reporting that IIS isn't installed, no matter what I do. http://localhost/ does show a nice IIS page though. This is my error log : === Verbose logging started: 20-11-2006 9:04:13 Build type: SHIP UNICODE 4.00.6000.00 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe === MSI (c) (C8:8C) [09:04:13:937]: Resetting cached policy values MSI (c) (C8:8C) [09: ...Show All

• Windows Forms Retrieve data from a selected row in DataGridView

  Hello, I'm using a DataGridView where I select a full row of data. I already selected: MultiSelect = False SelectionMode = FullRowSelect I need to fill up several textboxes and a picturebox with the information contained in the selected row. So far, I think I have to use the property SelectedRows of the DataGridView, but I haven't managed to have any success. Any ideas Thanks ICC If Not Me .DataGridView1.SelectedRows.Count = 0 Then 'There is only a selected row at index 0, when the grid is loaded, 'there is no selected row, you can force it to prevent 'error Dim i As String = Me .DataGridView1.SelectedRows(0 ...Show All

• SQL Server Facts with infinite measures

  Hello! I was wondering if there exists convenient ways to handel infinite measures in SSAS. In my exmple there are facts describing software licenses. Normally, licenses grant the right for a specific amount of installations. However, as for something like a site or enterprise license, the allowed number of installations is unlimited. Of course this can workarounded by a separate measure counting those unlimited licenses but it adds more complexity and inconveniance to analysis. Thanks in advance for ideas, Regards, Alex Hello Mosha, I will do my very best to make it more clear. Here is an example source table "Licenses" from the data warehouse: DimOwner | DimSoftware | [Allowed Installations] | [Al ...Show All

• Visual Studio Team System Unsupported Media Type error while running a webtest containing webservice

  Hi, I've a webtest which has a web service request. The header and the string body have been specified and the parameteres to the webservice is passed from an Excel file. The data which I pass are just numerics, characters. When I run the webservice, the test fails and the error it displays "415 Unsupported Media Type" Any idea on how to resolve this Regards, ...Show All

• Visual Studio Express Editions How to get Serial number on usb flash drive

  I am unable to get the serial number on usb flash drives. I'm using vC#.net, but I don't know what to use for get it. I need your help, please! Thanks all..! I've got an article on exactly this subject at http://home.hot.rr.com/graye/Articles/USB_SerialNumbers.htm It describes both a Windows Management Instrumentation (WMI) method and API method. It also has both a VB.Net and C# downloadable source code example solutions. ...Show All

• Visual Studio How Can I generate the Help file for Dependency DLLs. ?

  I have all the assemblies in one bin folder. now I want to generate the common .chm files for all the assemblies as well as thier dependencies. I got lot of reference which generates the standalone .chm file and I am able to do so successfully but not found any source which helps to generate help file for dependencies and link it to common .chm files and give us only one .chm file. Regards, alok Hey Anand, Good news. I am able to generate the .chm file with respective <summary>. I realized that we have to change the .xml file name in sandcastle.config file in <!-- Copy in comments --> <component type="Microsoft.Ddue.Tools.CopyFromIndexComponent" assembly="ProductionTool ...Show All

• .NET Development How can I convert picture to another format?

  I want to change the format of a picture to another format (ex: *.jpg to *. gif, *.bmp to *.gif . . .) with C# language but I don't know how can I do. Please, show me. thanks!!! check this hope it helps you... http://www.codeproject.com/csharp/imageconverter.asp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help needed Clipping a triangle vs Camera

  Hi, 2 questions a)How do I check if a triangle consisting of 3 Vector3's is inside the cameraview (based on ViewMatrix and ProjectionMatrix of the camera) b)How do I calculate the position on the 2D screen of a single Vector3 (also based on ViewMatrix and ProjectionMatrix of the camera) a) Transform the vertices by the view and projection matrices, which will give you Vector4 positions in homogenous coordinates. Check if each vertex is off the left of the homogenous unit cube by testing whether (x < -w), and if they are off the right by checking for (x > w). Likewise for the y and z values. If all three are off the same side of the cube, reject the triangle. Some links about homogenous coord ...Show All