goh6613's Q&A profile

• SQL Server Storing query results in SQL table

  Hey guys/girls, I was wondering if there is a way to store the report query results into a SQL database for use within an application. I would like to have the query information used in the report updated to a SQL table for later use. The other catch would be to deploy the information to a separate datasource location than the report is using (because the information will be stored in a different location than where the report is gathering information. Thanks! BJ YOu are missing two parts in the frou part name, you additional have to prefix the linked server name and the database name you want to pull data from / insert data into. (Just see the above mentioned samples for doing this) HTH, Jens K. ...Show All

• Windows Live Developer Forums How to deactivate an order item?

  Hello, Let's suppose I would like to deactivate a certain order item vs. deleting it from the order. (for it to be there in case I decide to reactivate it!) Does anyone now if this is possible Thank you, Orest Hi, I don't think it is possible as there is no such method as "PauseResumeOrderItem" in the doc. Julien ps: oups, didn't see someone answered already. :) ...Show All

• SQL Server Replicating Schema Changes

  Hi there, I'm using Sql 2005 merge replication and I have noticed something, I'm not sure if this is true or not:... My publication is set to replicate schema changes (replicate_ddl = 1). Now, I have noticed that schema changes are only replicated if the current snapshot is valid. Is this right If so why My next question carries on from the first. If I'm about to run a TSQL script on my publisher that will add a column or two to a published table, how do I ensure my snapshot is valid inorder for the ddl changes to be replcated Should I be using: EXEC sp_mergearticlecolumn @publication = <publicationname> , @article = <article name> , @force_invalidate_snapshot = 1 , @force_reinit_subscriptio ...Show All

• Visual Studio Team System /analyze:WX-

  Hello, I have a solution with C# and C++ projects. In the tfsbuild.proj, I have RunCodeAnalysis=Always and in VS I do not run static analysis. In the C++ projects, some static analysis failures are treated as errors rather than warnings. I see that /analyze:WX- allows me to control this behavior. So my question is how do I configure my build to pass the /analyze:WX- option to C++ projects only Thanks for your help. Luke Have a look at the following thread that discusses the AdditionalVCOverrides property: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=763569&SiteID=1 . You want to put something like the following into this property: <Tool Name="VCCLCompilerTool" EnabledPREFa ...Show All

• Windows Forms cause a property to display "builder" button to browse for folder ?

  I'm writing a custom control. One of its properties is a directory name. I'd like the property sheet to display a "build" button that--when clicked, displays the standard Browse for Folder dialog. I have no idea how to do this. Any help getting started is appreciated. I don't know if you can call the folder browser directly, so you might need to research that some, but you can do what you want by: Creating a custom editor for your property derived from UITypeEditor (Look at help for this guy for a good sample) public override UITypeEditorEditStyle GetEditStyle(System.ComponentModel. ITypeDescriptorContext context) { return UITypeEditorEditStyle .Modal; //tells the system ...Show All

• Visual Studio Team System Visual Studio Shutsdown Frequently

  I have recently installed visual studio team system in my computer. And it frequently shutsdown when I'm working. I'm not sure why this is happening...for a qucik fix. I running this command devenv/resetuserdata in visual studio command prompt. And it will be working well for a day and then next day the same problem. It will start shutting down frequently. Any help is appreciated... Hi David, I have noticed somewhere in this forum that this might because of virus. So I installed Norton Antivirus software on my machine. Now my visual studio doesn't crashes and works well. Kalai ...Show All

• SQL Server Question Regarding Scenario On DataMining

  Hi to all I want to know how achieve the following scenario, I will highly encourage if anyone knows the solution please mention it through steps. The scenario is I have a table named “CreditCardTable ” with following schema , the table is pretty much what one expect from a simple credit card application that will present form to user who fills the application of credit card and data going to be filled into the table. Later an analyst will review the data and will be accepting or rejecting the Credit Card along with some other fields as seen in the schema. -----Schema -------- CustomerName Bigint Age int DOB DateTime LimitAssigned Bigint Analystname varchar Salary varchar Gender bit Qualification varchar Country va ...Show All

• Software Development for Windows Vista Workflow Extensions RC5 not working?

  I have installed RC1 of the .NET 3.0 framework ok on my Windows XP x64 workstation, but the Workflow Extensions RC5 for Visual Studio 2005 don't seem to work. They install the SDK but no Workflow options appear in VS2005 The previous CTP (July) worked ok If you run the MSI for the WF extensions from the same directory where you have a setup.exe file (like the Windows SDK installer) then when the WF extensions are extracted, the wrong setup file gets run. When you run the installer, you should not get the SDK install dialogs, but a unique WF extensions dialog. Simply rename the Windows SDK installer to something else and you should be good to go. Matt ...Show All

• Windows Forms closing form, and all modals on top of it

  Hi, I have an application that connects to a server. The server might send an event that should cause my app to go offline. However, the user could have at that particular moment a wizard (in the form of a modal dialog), which also could have other modals or message boxes on top of it. When I receive the event, I want to be able to close the wizard along with all its modal 'children'. There was a solution, in having the modals listen for a particular event, and close when they received it. However, as I said, I could be using message boxes also. So I can't have those listening for the event. I need something like running through the forms of my app, and see if they're on top of the given form. Then call Close() if that's the ...Show All

• Software Development for Windows Vista ActivityStatus with WorkFlowView

  I'm using a WorkFlowView to visualize the workflow and a button to run it. I add to the WorkFlowRuntime the sqlTrackingService and put the property IsTransational to false. SqlTrackingService sqlTrackingService = new SqlTrackingService ( "Server=Servidor;" + "Database=WFF;" + "User ID=User;" + "Password=User;" + "Trusted_Connection=False" ); workflowRuntime.AddService(sqlTrackingService); sqlTrackingService.IsTransactional = false ; workflowRuntime.CreateWorkflow((compilerResults.CompiledAssembly.GetType( string .Format( "{0}.{1}" , this .GetType().Namespace, this .WorkflowName)))).Start(); workflowRuntime.StartRuntime(); W ...Show All

• Windows Forms Creating a color chooser

  How to create control like the one in MS Office,from which the user choose a color Or how to fill a combobox with different colors there is a project at codeproject.com which provides a class you can use if you want a colour combo box. search for cComboBox it will give you all the named web colours. The code isnt perfect and does miss a couple of colours, due to some spelling mistakes, but if you search through the 'getcolorfromname' and 'getnamefromcolor' (or simaly named) methods you can correct them ...Show All

• Windows Forms Accessing another program's menucommands programmatically

  Hi, I am using VB.Net 2005 and don't have access to Visual Studio Tools for Office (hence my post is not in that forum). I need my vb.net program (as distinct from a vb macro from within Word) to "hook" into MS Word, locate a specific menuitem and cause that menuitem action to occur. I think <menucommand.invoke> is intended for this purpose, but can't work out how to access the menus to do so. Gaining access to MS Word via my program is not difficult - I've done this with Excel in the past so should be able to work that out ok. It's identifying the menu and menu sub-item which I'm unsure of. Any help, greatly appreciated. Thanks, Brian ...Show All

• .NET Development select data from database (MySQL) but it show as ??????

  i have develop webservice app with MySQL (tis-620 encode) but when i select data that contain thai language it display as but for number and english data it display correctly i want to know how i can get correct data (display thailanguage correctly) thank! i have reslove this problem the reason is i use ODBS to connect mysql then it can't get result in thai language. After that i have download MySQL.NET (download from MySQL.com) install > add reference (in vs.net) then i can get resault in thai !! thank ek ...Show All

• Visual Studio 2008 (Pre-release) Segmenting the Xaml

  Hi All, I'm currently developing a multi form Xaml aplication and was wondering is there any way of moving the styles and templates out of the xaml file into a separate styles file. A bit like css which I can then reference through the different pages of the interface I know that I can move some of the global styles up into the App.xaml but this means that the app will need to Tree walk the styles hierarchy which seems to have an initial performance hit because the app needs to find it. Also is the best way to do a common page header through a header control which you use on all pages Thanks in advance for the advice. Andy Think I have found part of the answer, you can use a WinFX Resource dic ...Show All

• .NET Development adding Window Media Player into IE Toolbar

  Hello: I am facing a problem in adding a Window Media Player Control into IE ToolBar. I found a project written in C# on Code Project site that can add a text into IE toolBar. But I can't add the window Media Player into IE. The Project I found constitutes of 2 projects BandOjLib and SampleBars window Application C sharp where the development is happening in it. So what you do in SampleBars project will be embedded into BandObj Project after compilation and start without debugging both BandObj and SampleBars respectively. When I am adding the Window Media Player into TOOLBOX, then to drag it into window Form => it gives me this error: Assembly generation failed -- Referenced assembly 'AxInterop.WMPLib' does not hav ...Show All