Steven P.'s Q&A profile

• SQL Server How can I format the Date in the SQL Table using a SQL query

  Hi I have a SQL table that contains date in this format :- 2006-07-02 16:20:01.000 2006-07-02 16:21:00.000 2006-07-02 16:21:01.000 2006-07-02 16:22:00.000 2006-07-02 16:22:02.000 2006-07-02 16:23:00.000   The date above contains seconds that I dont want, how can I remove those seconds so that the output looks like :- 2006-07-02 16:20:00.000 2006-07-02 16:21:00.000 2006-07-02 16:21:00.000 2006-07-02 16:22:00.000 2006-07-02 16:22:00.000 2006-07-02 16:23:00.000   Your help will be highly appreciated. Rod Colledge wrote: That will change the data. If you only want to change the display, then try this ; select replace(convert(varchar(20), columnName, 102), '.', '-') + ' ' + left(convert(var ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiple monitor problem

  Hi everyone, I am writing a Direct3D application that run in multiple-monitor mode. If I leave DirectX window on primary display, everything is OK (CPU% is about 1%). As soon as I move DirectX window to second display, CPU usage jumps up 100% even though I have not drawn anything in the windows. Any help would be appreciated. If your D3D device was not created to use the adapter connected to the second monitor then Windows will try to show your 3D content by transferring the results from the first adapter's memory to the second one's. This operation is of course too slow and is all done via the CPU. Read on Multimon support in the SDK docs to see what options you have to deal with multimons in D3D. ...Show All

• Windows Forms Application.EnableVisualStyles and .DoEvents()

  Hi All; I've got a groovy little windows app (VB.Net 2003) going with some tab controls and tab pages. I'm also attempting to EnableVisualStyles but am not able to display the tab's text when using EnableVisualStyles. I have Application.DoEvents following as suggested in several different threads I've found on the web that are mentioned to combat the bug in 1.1 framework. Can anyone offer further suggestions Code as follows. Thanks, GRaab Public Sub Main() Dim mainForm As mdiServiceCare = Nothing Try Application.EnableVisualStyles() Application.DoEvents() mainForm = New mdiServiceCare Application.Run(mainForm) Catch ex As Exception MsgBox(ex.Message) End Try End ...Show All

• Visual Studio Sandcastle: File names

  I need to have references from other documents to the html.files that are created with sandcastle, so the names of the html files needs to be consistent every time i Build a new help file.. I was thinking of using the namespaces as file names.. In the Output/html folder,how do I change the name of the files from using GUIDs to namespaces The filenames with GUIDs are added in AddGuidFilenames, could I simply extract the namespace from the api/@id attribute and use that as file name or is there a better way I've had a couple of similar requests for the help file builder. I'll be adding a project option to allow selection of either GUID filenames or "friendly" names based on the member name. ...Show All

• Software Development for Windows Vista CoCreateInstanceAsAdmin and isolated COM

  the facts: - Application uses isolated COM, the installer does not write anything to registry (hence it can run under non-admin account under XP) and I want to keep it that way. - Application needs to write to HKEY_CLASSES_ROOT to change associated file types. This is only performed on request and it is not working on Vista Beta 2 unless the application is executed with elevated access rights. Browsing the available material, I have found that the CoCreateInstanceAsAdmin function should be able to run a COM object in separate process with full access rights. My question is whether the API would work, if the created COM object is isolated (e.g. has no record in registry, just in the manifest of the main exe) Thanks, V. ...Show All

• Visual Studio Team System using msscci w/vs2003 after running the vssconverter

  for a small test I created a new project using VS2003. CHecked it into VSS. then ran vssconverter and migrated those sources to a TFS project. I then installed MSSCCI. Now I open the solution and am stuck at how to get it to bind to my tfs project. I endup with the "change source control" dialog and then the "choose folder in TFS" dialog. I browse to where the project is in TFS but the OK button remains greyed out. In fact no matter what I do, the OK button remains disabled. Also there is a text box labeled "type a namde for the solution folder" but it is disabled also. What am I mising thanks Tim Hello, when working with TFS, you need to have all source controlled ...Show All

• .NET Development Interoperability of using BindingList

  Hi, Anyone has any idea if BindingList<T> type is interoperable if used to accept/return data in web service The WS would be used from java client and I want to make sure issue of type identity does not occure. I would be using concrete type for BindingList (e.g. [WebMethod()] public BindingList<person> SavePerson(Person p){ //code goes here return persons; } I don't want to come across an issue where java can not interpreat BindingList<T> similar to DataSets Thanks Hiten, It is interoperable. BindingList<T> as any List<T> is reflected in wsdl as a ArrayOfT element... that can be then parsed as T[] in java. However, of course, the binding feat ...Show All

• Visual Studio 2008 (Pre-release) cant log in vpc orcas !

  I am using Visual Studio Orcas VPC Credentials: Username: Administrator Password: P@ssw0rd but it wont log me in Please do put that info on the page where we download the VPC. Its invaluable. I had the same problem with the TFS VPC and gave up trying to log in on that and as a result i lost several weeks of possible learning about the product. Now i've got a project with TFS in it and have got to cram as much as possible to be productive. Benjy ...Show All

• Software Development for Windows Vista The Windows SDK for Windows Vista is available for download

  ISO Install: http://www.microsoft.com/downloads/details.aspx FamilyId=7614FE22-8A64-4DFB-AA0C-DB53035F40A0&displaylang=en Web Install: http://www.microsoft.com/downloads/details.aspx FamilyId=C2B1E300-F358-4523-B479-F53D234CDCCF&displaylang=en A lot of people from all over the greater Windows organization have spent years (literally!) creating great content for the Windows SDK Team to bring together for our developer customers. I just heard back from the person in charge of the process that it should be ready within the next several weeks, and that there will be a link to purchase the DVD when it's available. There is a lag between our RTM and the media burn since it has to pass throu ...Show All

• .NET Development Possible to register a C# program to the R.O.T. for OLE automation?

  Hi all, I was wondering if it was possible to "register" your own created c# program for OLE automation This would be the equivalent of accessing something in Excel via OLE. Like: Dim ExcelApp As Object ExcelApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Edit: and just to clarify, I understand how the GetActiveObject works (by looking up the object in the Running Object Table). I guess I need to know if it is possible to register a program with the Running Object Table. If it is an access problem you could try the value ROTFLAGS_ALLOWANYCLIENT during registration to allow processes of other users to see your COM object. Without further information it is quite difficu ...Show All

• Smart Device Development VS2005 Control Library 2.0 User control is disabled in Toolbox, why?

  Hello everyone, I have a vs 2005 solution with 2 projects: 1. Pocket PC 2003 Windows Application 2.0 2. Pocket PC 2003 Control Library 2.0 In the Control LIbrary I just have a User Control which has a textbox and nothing else. Everything compiles perfectly. Now in the Visual Studio 2005 Toolbox I dont see the My custom control but if I right click and select Show All I see the control and it's icon is disabled. Any idea why is this not working properly Thanks a lot. Don't know whether have u tried this.... go to toolbox -> right click -> choose items-> click browse-> select ur compiled control library dll file (the file with all ur controls) -> check whether ur controls ap ...Show All

• Windows Forms DataGridView Master/Slave bug???

  I use a master/slave relation between two datagridwiew object. When both datagridview are on the same form everything works OK. If I put the slave datagridview on a different form, create of a new row on master form and a new row on the slave form fail. The primary Key is not copy from the Master row. Here is the BUG i can't fix. Create one form with a datagridview. Bind to the master table. Create one form with a datagridview. Bind to the slave table. Set the currency manager for the datagridview on the slave form to make sure datagridview are sync. Create a new row in the master table. Open the slave form and create a new row. The key from the new row in the master form is not copy to the foreing field in the new row. I ...Show All

• Windows Forms Uninstall custom action

  Hi, How can I identify in uninstall log file, that custom action for uninstall was performed What can be reaseon that my custom uninstall action wasn't performed My uninstall custom action is following Visual Basic Script stored in file startsh.vbs: Set WshShell = CreateObject( "WScript.Shell" ) WshShell.Run """" & Property ( "CustomActionData" ) & """" ,7, False Set WshShell = Nothing ---- CustomActionData is: [TARGETDIR]deleteShortcuts.vbs startsh.vbs and deleteShortcuts.vbs are installed in [TARGETDIR] folder and property "Permanent" is True. Thanks It doesn't work because TARGETDIR is not valid during a ...Show All

• Software Development for Windows Vista InstallLocation in registry uninstall information is not being written when using VS2005 Deployment Project

  Per Vista test case 19 of Vista Logo Certifications, HKLM\Software\Windows\CurrentVersion\Uninstall\{ProductCode}\InstallLocation can not be null. I am using a simple Setup and Deployment project in VS 2005, and I dont see any option to make that happen. I would have suspected that it would do it by itself. Hello! I put this into the MSI tables using Orca and it still won't write a value in the InstallLocation registry key. Is there any reason why this won't write a value Thanks, Sean ...Show All

• Visual Studio 2008 (Pre-release) msmq binding messages dissapear

  I have a custom msmq binding defined that I had hoped would be compatible with basicHttpBinding: < customBinding > < binding name = " msmqSoap11 " > < textMessageEncoding messageVersion = " Soap11 " /> < msmqTransport exactlyOnce = " false " durable = " true " > < msmqTransportSecurity msmqAuthenticationMode = " None " msmqProtectionLevel = " None " /> </ msmqTransport > </ binding > </ customBinding > I then have an intermediary that receives any Message overr basicHttpBinding and resends it using ChannelFactory to a console app with a service endpoint using the binding shown above. The app consumes the the messag ...Show All