Neil Watson's Q&A profile

• SQL Server SSMS-EE: Creating and Using Stored Procedures - Error Messages 111, 156, & 102

  Hi all, I tried to use the SQL Server Managemet Studio-Express Edition to execute the following code statements: --- SQLQuery.sql--- USE testDB DECLARE @procID int DECLARE @procName varchar ( 20 ) DECLARE @procType varchar ( 20 ) CREATE PROC sp_getRecords AS SELECT * FROM Inventory CREATE PROC sp_insertRecord @procID int , @procName varchar ( 20 ), @procType varchar ( 20 ) AS INSERT INTO Inventory VALUES ( @procID , @procName , @procType ) CREATE PROC sp_deleteRecord @procID int AS DELETE FROM Inventory WHERE ID = @procID CREATE PROC sp_updateRec ...Show All

• Visual C# tlbimp.exe and DllImport

  I have a dll file that also comes with a .tlb file.   When I tried to load the dll file, I imported the dll using tlbimp tool.  The dll implemented an interface that exposes some functions... but when i tried to create an instance of the class in my dll file, it throws me : System.Runtime.InteropServices.COMException was unhandled   Message="Retrieving the COM class factory for component with CLSID {9A85C592-4736-45CE-ADE3-200144B78F19} failed due to the following error: 80040154."   Source="PPTranning"   ErrorCode=-2147221164   StackTrace:        at PPTranning.Form ...Show All

• Software Development for Windows Vista Missing Service Does Not Throw Exception

  I am using InvokeMethod to call into a DataExchangeService . However, if the service was not added to the WorkflowRuntime before the activity is executed the workflow hangs and the process consumes 99% of the CPU. WorkflowRuntime. ExceptionNotHandled is not fired. Thanks for forwarding that to the dev team. Where should this exception be caught Through the standard exception flow I thought all exceptions went through the exception flow and then fell out to WorkflowRuntime.ExceptionNotHandled   if not explicitly handled... ...Show All

• Smart Device Development camera guidline

  Will anyone is able to guid me about camera developement I have two questions As WM5.0 support the camera api's but if i have the camera full specifications including driver and camera device api's then which way is easier to implement camera app 1. Using WM 5.0 api's 2. Device dependent api's Please give me the detail answer. I am new for WM thanks in advace Standard WM 5.0 API is the best option as it would work on any compatible device and any camera. As to complexity, it should be roughly the same for both. ...Show All

• SQL Server SQL Server 2005 Reporting Serivces: XML Datasource problem

  Hi, I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: 1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx . this webservice has a method called " GetXMLDocument" that has 1 parameter (sql). This method uses the sql statement to fill a dataset from a SQL Server database, converts it to an xmlDocument, and returns the xmlDocument. Here is a sample of the results: < xml version="1.0" encoding="ut ...Show All

• Windows Forms Can DataGridViewComboBoxCell be able to edit by user (like a normal Combobox)?

  Can DataGridViewComboBoxCell be able to edit by user, like a normal ComboBox If can't, how to customize a cell/column to get this feature Thanks a lot! The DataGridView does not support this by default. You'll need to customize parts to get this to work. Check out the DataGridView FAQ for more details: http://www.windowsforms.net/Samples/Go%20To%20Market/DataGridView/DataGridView%20FAQ.doc   -mark DataGridView Program Manager Microsoft This post is provided "as-is"     ...Show All

• Windows Forms Windows Forms GUI standards

  Does anyone know if Microsoft has any Windows Forms GUI standards Standards such as the size and font of text on buttons, on Window Forms Title bar, message boxes etc... Thanks. You might also want to take a look at this site: http://www.microsoft.com/winlogo/software/tech_req.mspx Read the requirements a software product must meet in order to get the "Designed for Windows XP" Logo. The "Designed for Windows XP" Application Specification contains the details on developing compatible products and the requirements for getting the Logo on your product The docume ...Show All

• Visual Studio 2008 (Pre-release) Installing Windows Presentation Foundation

  I installed WinFX RTC founded at http://msdn.microsoft.com/windowsvista/getthebeta/default.aspx . Then I try to install Windows SDK but a receive an error and installation abort. The error log is here: ----------------------------------------------- 14.08.10 venerdi 13 gennaio 2006: [SDKSetup:Info] Begin 14.08.10 venerdi 13 gennaio 2006: [SDKSetup:Info] SDKSetupDll_DoTasks: Starting 14.08.10 venerdi 13 gennaio 2006: [SDKSetup:Info] SDKSetupDll_DoTasksWithGUI: Starting 14.08.11 venerdi 13 gennaio 2006: [SDKSetup:Info] Config_Products_Detect: Begin detection of product: Microsoft Document Explorer 2005 14.08.13 venerdi 13 gennaio 2 ...Show All

• Visual Studio Express Editions App. performance degrade 2003 -> 2005

  After converting my project from VC++ 2003 to 2005 Express and rebuilding in release mode, I've found that my application's performance has dropped by about 25%. I reviewed all of the project's optimization settings to make sure that nothing got set wrong during the project conversion. I reviewed the documentation for optimization settings differences between VC++ 2003 and 2005, and made sure that I am using appropriate settings for speed optimization. Are there any documents available which might guide me in tracking down what went wrong with my project conversion Any hints or suggestions at all would be welcome. I'm at a complete ...Show All

• Windows Forms Binding nullable integer to textbox from designer

  I'm moving from .NET 1.1 Windows Forms development to .NET 2.0 and I'm checking out the new databinding features. It looks like it's going to rock! So I build a simple base class that has integer, string, and nullable integer properties. I then built a collection class and just inherited off of the generic List<T>. Worked awesome. I dragged a DataGridView onto my form, and set the datasource to my new collection class. I then added a couple textboxes (one for each property in my base class). In each textbox, I set the Text property under the DataBindings property to a property in the BindingSoure that the GridView added for me. ...Show All

• Visual Studio Sub Reports open when clicked on

  Hi, I have been making a VB .NET 2003 app that opens a crystal report with a sub report in it. I noticed if the user clicks on the sub report that it opens in a new tab in the crystalreportviewer. How can I stop this behavior I want the report to only be available as a whole. Thanks in advance. In the viewer DrillDownSubreport events handle that events like e.Handled = True Hope this helps ...Show All

• Visual C++ I got this error when compiling "Error c2784"

  Hi everyone, Can someone help me with my program I've been working on it for awhile and still cant get it to work. Here's the listing: #pragma warning (disable : 4786) //disable warning about truncation of string data #include <iostream> #include <fstream> #include <string> #include <set> #include "masterheader.h" using namespace std; //type definitions typedef multiset <MasterHeader> typeMH; //sets up output file for writing //Postcondition: The output file has been created with // name read in from the keyboard void setUpFiles(ofstream& os); //reads input from input file //Pos ...Show All

• Windows Forms disable double click to see code

  Howdy all. Does any one know how I can disable the ability to double click on a control to view the code (VS 2003) I'm constantly bringing up the code window when I don't need it -- and that can be quite annoying when you're working on large projects. I've alreeady adjusted my double-click speed which cut down the number of happenings, but hasn't stopped it all together. Any ideas Thanks. -rich Indeed it's terribly annoying. If you find a way to overcome this problem please share it with us! Galit ...Show All

• SQL Server Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work ...Show All

• Visual Studio What does it mean for "warning MSB4098: MSBuild is invoking VCBuild to build this project."

  After running "msbuild xxx.vcproj", build is OK but one warning msg like: warning MSB4098: MSBuild is invoking VCBuild to build this project. Project-to-project references between VC++ projects (.VCPROJ) and C#/VB/VJ# projects (.CSPROJ, .VBPROJ, .VJSPROJ) are not supported by the command-line build systems when building stand-alone VC++ projects. Projects that contain such project-to-project references will fail to build. Please build the solution file containing this project instead. --So, what does it mean and how to solve it Thanks in advance. I am getting this exact same error, bu ...Show All