M O J O's Q&A profile

• SQL Server How do I return a TRUE or FALSE using a Stored Procedure?

  How do I return a TRUE or FALSE using a Stored Procedure This is my SQL Server Code: All I need it to do is return a TRUE or FALSE response (in integer, string, I don't care what manner) as to whether or not the given select statement returned with data (in other words, if something met the criteria). The criteria is "Do any records nameKey = 52 and were they posted on today's date " --------------------------------------- CREATE PROCEDURE udspCheckForMilestoneUpdates AS IF EXISTS     (     SELECT *     FROM storyData     WHERE nameKey = 52        ...Show All

• Visual C++ Changed the COM signatures....using ildasm.....

  Hi, I have a .exe COM which I used in .NET but some signatures got changed....so I opened it with ildasm and changed the signatures so that it should return something from the function....This is the error I'm getting now.... The runtime has encountered a fatal error. The address of the error was at 0x79e8aff6, on thread 0xb4. The error code is 0xc0000005. This error may be a bug in the CLR or in the unsafe or non-verifiable portions of user code. Common sources of this bug include user marshaling errors for COM-interop or PInvoke, which may corrupt the stack. Any Ideas.... Thanks, Harsimrat ...Show All

• SQL Server SqlServer2K5_BOL.msi

  In July I obtained and installed the dvd's SQLServer 2005 Developer Edition CTP so I assume this is the June 2005 version and VS2005  Team Suite Beta 2. I tried downloading the above file for Sql server 2005 Books online and it fails saying I need .Net 2.0  (  seems VS2005 installed .Net 2.0 Beta ) I am also having trouble understanding some concepts ( I am relatively new at this ) Why do I even need this SQL Server 2005 dvd   Seems that VS2005 installed SQLEXPRESS  -  When I look at the SQL Server Configuration Manager, I see MSSQLSERVER and SQLEXPRESS among other things( only SQLEXPRESS is running and that is ...Show All

• Visual Studio Team System Web Site and solutions and source control

  We are used to treat asp.net projects as any other projects - in terms of having a project file, association with source control, references / references paths, build options for files, etc. Now with the new and improved WebSite paradigm it's been succesfully dumbed down to the level of a collection of perl scripts, with apparent ugly workarounds like attempt to use a web.config file as a half-baeked project file to store references and stuff; hard-coded "special-purpose" directory names for resources, etc. BTW if someone knows how to defeat this bunch-of-files-in-directory approach please let us know. Now back to the issue at hand ...Show All

• Software Development for Windows Vista Long run business process

  My question is re: how to resume the flow after a queued step. In a simple case, user goto web to create a PO request, since the transaction also need to sent to a legacy system for processing which is queued thru MSMQ. after this is done, then we need to resume back to next step ,say for shipping or mail a invoice to user. How to implement this using WWF. Appreciate any inspiriting thought. In WF the key piece you would need to implement is to write a couple of activties that send and receive MSMQ messages. The receive activity would block the workflow until the correlated MSMQ message is ...Show All

• Windows Forms freezing datagrid for sometime while adding records.

  I have an array of about 1000 items that I want to display in a datagrid . Currently, I created a array object for each item, copy the data to the data row, then add the row to the datatable foreach (items o in c) { object [] data = new object []{c.Name, pdp, countryName, c.PhoneNumber, c.UserDefined, Int32.Parse(c.ContactId), imageList1.Images[1]}; this .contactDataSet.Tables["Contacts"].LoadDataRow(data, true ); } This is taking about 15 seconds to complete 1000 rows. Can anyone suggest a technique to make this process faster. Can all the rows be added in bulk, instead of one at a time Could the ...Show All

• Visual C++ truncation from double to float

  greetings, I am getting a warning for my code that is bothereing me. Using C++ Express I get the following error. warning C4305: '=' : truncation from 'double' to 'float' Here are the pertinent snippets. In header file: float leftIn, rightIn, inches, totalIn, theta, thetaDeg, x_pos, y_pos, target_dist,target_heading, target_bearing, heading_error, target_heading_error/*duplicate */,lClkPerIn, rClkPerIn, wheelBase,TWOPI,RADS; IN constructor: lClkPerIn = 66.6667; I declare this thing as a float. Then it complains about truncating from a double trry lClkPer ...Show All

• Visual Studio Team System VSTS Dev edition and TFS - IDE Locks on Add Item - BEEPS

  When connected to TFS everytime I add an item to the project the IDE locks up in what appears to be a modal error of sorts. Once the item is added to the project I cannot do anything. Anywhere I click in the IDE I just get beeps. It is as though there is a dialog box open but I cannot see it. I have to kill the devenv process... When I reopen the project I have to show all files and include the file that I just added. I can provide a short video if you need an example. Andrew, I'm going to bump this question over to the TFS forum where I think it will be best answered. Thanks, Ian ...Show All

• Visual Studio Team System Unit Test of Webservices in July CTP

  I just upgraded to the July CTP from the Beta 2 and I can't get a unit test to work with a webservice.  Here are the steps I take: 1) Create a new blank solution. 2) Add a new webservice (with the default hello world webmethod). 3) Open the service1.cs file. 4) Right click and select "create unit tests..." 5) Select all the defaults except use C# for the language. 6) The test project is created with the test method. 7) I try to run the test through the test manager. 8) I get the following error:   Failed HelloWorldTest TestProject1 Test method TestProject1.ServiceTest.HelloWorldTest threw exception:  System ...Show All

• Visual C# [VS2005] Building Comment Webpages

  I am reading Inside C#, 2nd Edition and it speaks of a tool in the Tools menu that will build a website from my provided XML documentation but I have found no such feature. Does it actually exist I am running the express version of Visual Studio .net 2005 on my computer but have access to the full version on another. This is available in VS 2003, but not in VS 2005. NDoc is a free tool for generating help files from code comments, but sadly it has not been updated in awhile. http://ndoc.sourceforge.net/ Here is another post in the forums discussing the topic as well: http://forums.microsoft.com/msdn/showpost.aspx postid=565 ...Show All

• Windows Forms datagrid and hyperlink

  I've made a little app to consume RSS file : <img src="http://dyt4concept.com/images/rss.png"> I'd like that title column act as hyperlink not as a simple text In fact when user consume the RSS, the user click in the datagrid, in the link column and go to this link Any idea  thx Regards David I tried, but just couldn't give it the necessary&n ...Show All

• Visual C# What happen... class2 a = new class1 (); ?

  Hi: Id like what happen in PC memory when I do: a) class1 a = new class1 (); b) class2 a = new class1 (); Id like to know the difference and where there is something to read about it. Thanks >Id like what happen in PC memory when I do: Assuming that class1 is a class, a new class1 object is allocated on the GC heap in both cases. A reference to the object is stored in the a variable. >Id like to know the difference Well in b) the variable type is different from the actual object type. class2 may be a base class or an interface implemented by class1. >and where t ...Show All

• Visual Studio Can you save the report to PDF or HTML or any Pictureformat

  Is there a way that you can save your report to PDF,HTML or any prictureformat. I have a windows verision and want to distrubute my report. /Anders Hi there, The String fileNameExtension parameter of the Byte [] returning LocalReport.Render() overload is redundant in the version [which I suppose] that you have, too (if it's the same with my version, namely " Microsoft Visual C# 2005  55603-000-0000016-00273 "). Simply comment this param (and the variable to which it is outputed), and it will work. Regards,           Emil Prager ...Show All

• Visual Studio pass a local property into another target

  Hello, Is there a way to pass a local property into another target For example, suppose I want to call: <Target Name="TestOutput"> <Message Text="Test output $(myVar)" /> </Target> with <CallTarget Targets="TestOutput"> Can I add anything to to this line to create the local property $(myVar) I tried embedding a propertyGroup within CallTargets InnerXml. No luck. I know that you can set/pass params via (1) THe command line, (2) propertyGroups, (3) via the Output property, but none of these let me pass a local param. Thanks, Tim I know it seem ...Show All

• Visual Basic ADO.net DataAccess time SLOW

  Unless I am doing something very wrong, it seems that the ADO.net dataaccess time,IE retrieving a record is extremly slow compared to Classic ADO. Now it takes between 1 and 2 seconds to retrieve the data from the Remote database (Access). Because of needing update data when I select a serial number, I presume and currently use direct access to the remote database. I load a combobox with all my serial Numbers, Currently 15,000 . Then when I click on a SN, the program does a query on the ADO.net dataadapter, retrieves the current record. this take almost 2 seconds. Classic was almost instantly. Am I doing something wrong. Here a part of ...Show All