Sharad Birajdar's Q&A profile

• SQL Server advice/suggestions PIVOT

  Hi all, Please look at the attached - I think it works, but I'm looking for some comments/advice. Included is table creation, samepl data and the t-sql statement. [code] SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[DBO].[ProductPriceComparison]') AND type in (N'U')) DROP TABLE [DBO].[ProductPriceComparison] CREATE TABLE [DBO].[ProductPriceComparison]( [CatalogueItemID] [nchar](8) NOT NULL, [RetailerName] [nvarchar](100) NOT NULL, [RetailerPrice] [money] NOT NULL, [RetailerPriceCheckDate] [datetime] NOT NULL, CONSTRAINT [PK_ProductPriceComparison] PRIMARY KEY CLUSTERED ( [CatalogueItemID] ASC, [RetailerName] ASC, [Retai ...Show All

• Gadgets Access to other objects on page

  Hi, I learn to write a simple gadget, it has a button, when you click this button, it will get the object already existed and alert it. However, seems that getElementById does not work, object returned always null (this object existed). The source code below:  this.initialize = function(p_objScope)  {....      var m_btnDoIt = document.createElement("input");         m_btnDoIt.onclick = this.doIt;         m_btnDoIt.value = "Click me!";         p_elSource.appendChild(m_btnDoIt); ....  };  this.doIt = function()  {            &n ...Show All

• Visual Basic ClickOnce: Application identity is not set.

  I am trying to create a simple ClickOnce program that checks for updates programmatically. I have succesfully published a program using the built in functionallity of the IDE, but this does not give me what I want. Firstly, how do you debug such a program, as when I run the program, it falls over when I try to get the CurrentDeployment object with an error: The application is not installed. Secondly, I created a setup project and installed my program, but I am now getting the error: Application identity is not set. I'm sure this is just a property that needs setting somewhere, but I cannot find it. Here is my code: Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load ...Show All

• Visual C++ copying resource files to newly created dir

  hello, i am trying to produce an .exe which copies some resource files to the current users temp dir , am using the code below and getting a "System.IO.DirectoryNotFoundException" saying my current user dir which should be 'C:\Documents and Settings\xird.DESKTOP.000\Local Settings\Temp\'. does not exist, and sure enough on checking, it does not exist, in fact of the three users on my pc none of us has a Temp folder. I am missing something obvious i am sure but getting abit stir crazy. Any advice would be appreciated. Am on winxp sp2. ta xird // get temp dir path and copy resource files String^ tempDIR = Path::GetTempPath(); String^ path = "app.ico"; String^ path2 = tempDIR; File::Copy( path, path ...Show All

• Windows Forms C# .NET 2.0 Serial Port

  Can anybody shed some light on the 2.0 Serial port object I've been trying to get it to work but to no avail.... I can write to the port with no problems. My problem is with the serialPort1_DataReceived event. It never fires.... I have searched the web high and low and haven't found anything of any assistance. Has anybody found code examples that actually work ! That's usually a handshake line problem. Use RtsEnabled = DtrEnabled = true after you open the port. ...Show All

• Visual Studio Express Editions Making Webrowser

  Hello everyone,i have a few questions about making an WebBrowser in Visual Basic 2005 Express. Question 1 : I'd like to make an progress bar,but wich codes do i need to add to let it work,and let it only be visible when the page is loading. Question 2: Wich Code is Required to open a new window by clicking on : New Window( in the ToolStrip Menu) I just want it to open a new window of my own browser.(see code) And wich one is needed to let ip open an File( See code 2) Private Sub NewWindowToolStripMenuItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewWindowToolStripMenuItem.Click End Sub Code 2: Private Sub OpenToolStripMenuItem_Click( ByVal sender As System.O ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWar demo: .NET Runtime 2.0 Error

  I'm having a bit of trouble getting the SpaceWar demo to run. It compiles fine (I made no changes) but when I try and run it I immediately get a dialog box asking if i want to send a report to Microsoft (I always say 'Yes'). Below is a copy of the Event Log entries generated: Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 8/30/2006 Time: 7:41:21 PM User: N/A Computer: IO Description: Faulting application myspacewar1.exe, version 1.0.0.0, stamp 44f5d7e7, faulting module kernel32.dll, version 5.1.2600.2945, stamp 44ab9a84, debug 0, fault address 0x00012a5b. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data: 0000: 41 00 70 00 ...Show All

• SQL Server If statment within Where clause

  Im using Business Intelligence with SQL 2005 to build reports Could one use a If Statement in a WHERE Clause My parameter contains: All 1 2 3 (In a dropdown) When the user selects '1', the WHERE clause should include the variable, but when 'All' is selected '1', '2' and '3' should be included SELECT CustomerName, CustomerTel FROM tbl_Customer WHERE ((IF @Varialbe <> 'All') (CustomerCode IN (@Variable)) END) can this be done Hi pyro, I have tried with query like this. Just try like this Remove your where condition in the query.In your layout use IIF condition. ...Show All

• .NET Development Treeview adding node problem in Framework 2

  I have a user component called 'SiteJobs' which housed in my main application windows form. It basically consists of Treeview as main display object, and accept a string object which corresponding to job campaign. It has public method called 'AddJob' , as code below public void AddJob ( string campaign ) { if ( campaign == "" ) return ; TreeNode newNode = new TreeNode ( campaign ); newNode . Name = campaign ; tvJobs.Nodes.Add(newNode); lblCurrentJob . Text = "Job: " + campaign ; int index = tvJobs . Nodes . IndexOfKey ( campaign ); if ( index !=- 1 ) tvJobs . SelectedNode = tvJobs . Nodes [ index ]; if ( OnNewJobIsEntered != null ) On ...Show All

• Visual C++ Changing Static properties.. Is this impossible?

  Hi there.. I have been trying for days now to change the property of visible on a static text control in my application to false during runtime. I have researched this and researched this, and even posted on Expert Exchange, but no one seems to know how to do this.... I'll post the answer I was given on EE.com, and hopefully someone here will know more about it. I have only been programming in C++ for a week now, so forgive me if this is a stupid question.... I have several static text controls setup in my application (DirectX pong game) to report various stats that assisted me in creating the game and diagnosing troubles that may arise setup in a console.rc resource in my project. These are displayed in a control panel beneath the ...Show All

• Visual Studio Sharepoint Webpart

  Hi All... How can I develop a webpart for Sharepoint using Dev Studio 2005 I see there's an addon for 2003 - when installed it lets us use a new template for a web part library. But when we try to install that addon under 2005, it says the Dev Studio's not installed... Perhaps 2005's is all set to do this - if so, where does one start This depends on for which version of Sharepoint you want to write you web part. If you are developing for Sharepoint 2007, you can use the standard web user control. In Sharepoint 2007, web user controls are treated/the same as web parts. If you're developing for Sharepoint 2003, however, you can install the following code snippets for VS 2005. They are not as ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ATI MOBILITY RADEON 9200

  Hi, Just to let you know that in my laptop, the change graphics.AllowMultiSampling = false ; makes the game works. It would be interesting to make a check before the game starts and receive the information about the requirements for the computer that it is running the game in order to work properly. Something similar to if (graphics.IsCompatibleXNA==true) Best regards Thanks, Please feel free to submit that as feedback to the team. See this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=682921&SiteID=1 ...Show All

• Visual Studio Tools for Office publish vsto project and connection to word dll

  Hello I am working with vsto 2005 (.net 2.0) . I created a default dot file that opened with custom task pane but i missed some information about the way the documents (base on this dot) knows about the dll. I know about the manifest file and about the property at the doc but i am getting problem when i opened the documents if the dot file is not at the same plcae it was when i first created the document. How can i force the document to know about its DLL Thanks in advance Sharon :-) In addition to Cindy's response, if the document cannot find the assembly, it can be because the assembly is referenced by a relative path which is correct for the template, but wrong for the document. See http://msdn.microsoft.com/ ...Show All

• Windows Live Developer Forums Using the DashBoard Control from v3 in v4

  I noticed that the dashboard navigation control in v4 looks different than the one in v3. Does anyone know of an easy way to get it back to the original format without having to implement my own custom version of the dashboard (navigation arrows, etc...) Regards, Beezle From my knowledge there is no way to go back to the V3 dashboard. You'll have to hack up the current V4 dashboard to make it look like the V3 if your really daring ...Show All

• Visual Studio Team System Associating work items and changesets

  I am trying to use < UpdateAssociatedWorkItems > true </ UpdateAssociatedWorkItems > however, I can't find any documentation on how it works. I am trying to add build to the bugs that have been resolved so that they can show up in the "associated work items" and "associated changesets". I am not sure how I need to flag my bugs/tasks so that UpdateAssociatedWorkItem would work. Please help. This should all just work by default... That is, changesets should automatically be associated with builds in the same team project (it's a bit more complicated than this, but to a first approximation this will be true). Work items should also be associated with builds, so lo ...Show All