D.P.'s Q&A profile

• SQL Server Open table + NULLs

  In SQL Management studio, if I right-click on a table and click "Open table", it brings up the table, similar to return all rows in 2000. But if I go to the last row, and edit data in a cell and the word " NULL " is that cell because there is a Null value there, it actually keeps the word null in there as in "NULLnewdata". Am I doing something wrong Three things. 1.) Ctrl-0 (read control-zero) = NULL 2.) Saying that that's the expected behavior is a cheap Cop-out. Enterprise Manager 2000 did it just fine. There is NO REASON that the "new" "improved" product can't c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rendering model over all others.. (overlay effect)

  Hi, Im working on a small 3d app for myself, in the app you can move the models around just like in any 3d editing program. I really like the controls in 3d studio max and i was wondering if anyone could point me in the right direction of how i can render the axsis arrows over the everything else in the screne like in the pics below... http://img346.imageshack.us/img346/9995/e11wm.jpg http://img346.imageshack.us/img346/6326/e28ll.jpg The placement of the arrow models and the rest is fine its just how do i get them to always be rendered ontop or overlayed of everything else in my scene One extra quick question, whats the bes ...Show All

• .NET Development programmatic access to sqldatasource dataset

  i'd like to take advantage of all the benefits of the new sqldatasource control to do quick queries & bindings, but also retain the flexibility of the previous ways of data access (i.e. sqlcommands/sqldataadapters) to fill datasets. is there a way to have programmatic access to the dataset that is filled after a sqldatasource queries a db i dont want to display all the columns queried in my gridview, but i want that data available for further manipulation without having to run another query. am i going about this the wrong way, or have i just not stumbled upon the solution thanks, david nope, no l ...Show All

• .NET Development No connection could be made because the target machine actively refused it

  Trying to connect to a local host TCP port 3380 (the port number chosen arbitrarily): 10.1.10.176:3380 I got this error message: No connection could be made because the target machine actively refused it What shall I do to convince the target machine not to refuse it the next time I used a sock.Connect(serverEndPoint); statement. Thanks HI Guys It's very easy. please first understand, what will to do try. u try send a byte of data server to Client cliet to Server. So those two type of work, whether one is Do the Job as the receiver. So We must Start that Receiver , rather than start the Sender. if u confuse. Please start Server ...Show All

• Visual Studio Team System Data meta-model

  Hi, Is there a metamodel of the data used by vsts especially about the process template definition .. (ProcessTemplate.xml) If not, could you tell me wether task definition is generic for wss,reports, etc or specific to each. Thanks and sorry about my english :) You can find documentation on the process templates in the Visual Studio March SDK CTP ( http://vsipdev.com ). Buck ...Show All

• Visual Studio Team System TFS / MS Project Bug

  When assigning resources in MS Project to a task (existing or a new one), MS Project just shuts down. No warning and no error messages are displayed. It happens every time for every user who is creating a project schedule. This does not occur when I use excel. One difference I did note is that in Project I added reasources via the Company Directory and their names showed up in the assign resources column as the full name. In Excel they showed up as the Windows login name. I don't know if it makes any difference. Jeff For my part, I tried to capture information when it happened and was unable to do it - when the error did occur, no infor ...Show All

• Smart Device Development Receiving all com ports or searching for device

  Hello, is where a function in .net compact framework what listens all avaible com ports or searches for a plugged hardware I want to communicate with the serial port and need the com port of my plugged hardware. System.IO.Ports.SerialPort.GetPortNames would return names of COM ports available on your device. Searching for devices (e.g. by opening all ports one by one and attempting communication with particular device) is up to you to implement. ...Show All

• Windows Forms File Download - Security Warning??

  Visual Studio 2003, VB.NET, IIS6 , Windows 2003 Web Server. My deployed app works fine!, however every time I try to open the app http://myServer/PilotPro.exe I get the following message in a IE dialog box: File Download - Security Warning Name: PilotPro.exe Type: Cor Remote Loader, CorLoad, CorLoad1,2.67MB From: pilotPro.myServer Run - Save - Cancel I do not want the user to actually download the exe - I want them just to click on the desktop IE icon I have setup. What is going on How are you deploying your app If you have a shortcut pointing to a http location I think Windows first ...Show All

• Windows Forms Windows XP and MainMenu control

  My MainMenu control is not rendering correctly on windows xp (with the newer shell controls).  Buttons, status bar, the drop downs themselves all render properly just not the actual main menu bar.  It renders with the control control instead of the menu color.  Is there something I'm doing wrong or can someone else confirm (or deny) this issue for ...Show All

• Visual Basic MonthCalendar control question

  I'm using VS 2005 beta 2 I want the MonthCalendar control to return the single day selected. I have MaxSelectionCount = 1. What I get back though is this: "SelectionRange: Start: 5/5/2005 12:00:00 AM, End: 5/5/2005 12:00:00 AM" How do I get the single day date Despite what the documenation says, the MonthCalendar control does not have the .SelectionStart nor the .SelectionEnd property. Thanks! The MonthCalendar control does have a SelectionStart and SelectionEnd properties they are just not visible in the designer. If MaxSelectionCount = 1, then both the SelectionStart or SelectionEnd proper ...Show All

• Visual Studio Team System TF80071 after choosing TFS Project occured

  I receive the error within MS Project 2003 SP2 (German) TF80071: Team Foundation encountered an error while  accessing  the work item database. .. after i choose an existing TFS-Project. The connection to the server is OK, no error about wrong mappings etc. I'm using TFS Team Explorer Beta 3 and Project Server 2003 with SP2 German. The project is an Enterpriseproject stored on the server and not as an .mpp Any ideas Do you get the same error TF80071 from an .mpp file   What about from Excel   This seems like a permission sync problem with the work item database but we need more info ...Show All

• SQL Server T-Sql Preformance

  I have a Stored Procedure that I need to make run more efficiently. I am calling the SP from a page that displays the data as a report. I have tried to change the SQL to several queries into temp tables and selecting the data from the temp tables, but the page does not display any data. I then put all the queries together and the page works if it doesn't timeout. I realize the query below is not efficient but I am uncertain how to speed it up further. I have copied the SQL below. Can someone point me in a direction Hello, Well, I don't think there's a silver bullet for you, but immediately I would consider the following to improve perf ...Show All

• Visual Studio Team System How to delete WorkItems?

  Hi, Is there any way to delete a workItem created by mistake Thanks An actual delete (obliteraing from the database) of work items should be available in a future release. ...Show All

• SQL Server Client Requirements if ReportViewer is used for Web Forms

  Dear Anyone. Does the client machine require any additional software updates if it tries to access a page that contains a reportviewer control Aside from .Net 2.0 Thanks, Joseph the file is RSClientPrint.CAB and you can find it in [MSSQL install dir]\MSSQL\Reporting Services\ReportServer\bin Eg: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin (thanks to http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=569402&SiteID=17 for help) You can deploy it centrally with a GPO / Logon script. ...Show All

• SQL Server Can the SQL Server 2005 be installed on Windows 2003 SP1?

  I recently attempted to install Windows 2003 SP1 on a machine on which someone had previously installed SQL Server 2005.  The build number for the SQL Server 2005 installation is 9.0.1116.  (BTW, which CTP is this build number ) The installation of the service pack seemed to go okay, but I soon got calls from users reporting that they could not log in to the instance.  I investigated, and discovered that the SQL Server service had not started.  We were unable to start the service, and had to remove SP1. This was the message I found in Event Viewer: Event Type: Error Event Source: SQLDUMPER Event Category:&n ...Show All