marcoxxx's Q&A profile

• Windows Forms Change focus Between winform by press Enter

    Change focus Between winform Object like textbox Or comboBox and Column of datagrid   by press Enter key not Tab. we have this code for VB6:        Private Sub Text1_KeyPress (KeyAscii As Integer)          If KeyAscii = 13 Then   ' The ENTER key.             SendKeys "{tab}"     ' Set the focus to the next control.             KeyAscii = 0            ' Ignore t ...Show All

• Visual Studio Team System SMTP Server timeout on Alerts

  Ok.. in trying to get alerts working I have tried to troubleshoot why the TFS is not communicating with the smtp server properly. It continues to timeout. I have done the following to test.   Ran the following code from the TFS using the TFSSERVICE account as the from address with no problems both with UseDefaultCredentials as true and false and works just fine. http://blogs.msdn.com/psheill/archive/2005/11/22/495863.aspx Have also verified this through manually telneting to the SMTP server port 25 and manually entering the from as TFSSERVICE account. Have followed this thread as well... http://forums.microsoft.com/ ...Show All

• SQL Server Upgrade query from Access to Sql Server 2005

  I'm currently upgrading from Access to Sql Server, and I have a broken query that I cannot find a fix for. The original query: SELECT DISTINCT DownloadedNames.* FROM DownloadedSkims INNER JOIN (DownloadedNames INNER JOIN DownloadedInfo ON DownloadedNames.DNID = DownloadedInfo.DIDnID) ON DownloadedSkims.DM_ID = DownloadedInfo.DI_DM_ID WHERE DM_ID=23 AND (dWeek BETWEEN '6/26/2006' AND '9/18/2006') ORDER BY DIID, dWeek I get the error "Msg 145, Level 15, State 1, Line 2 ORDER BY items must appear in the select list if SELECT DISTINCT is specified" when I test the query. If anyone knows what changes I can make to the que ...Show All

• Visual Studio LoadSaveReportException : Invalid Report file path while using dataset and source

  Dear All, I am new to .net in crystal report aspects. I was trying to add a report to my project using data set. I am getting the error : LoadSaveReportException : Invalid Report file path while using dataset and source These are the code I am using: ---------------------------------- prs_lib.ComboData objParam = (prs_lib.ComboData) this .cmbnats.Items[ this .cmbnats.SelectedIndex]; sqlselect = "SELECT * from prs_vreg_period where vcap_date between '" +DateTime.Parse(TxtRepItem1.Text).ToString("MM/dd/yyyy")+"' and '"+DateTime.Parse(TxtRepItem2.Text).ToString("MM/dd/yyyy")+ "' AND vcountry_id = " + objParam.Value +" ORDER BY vnat_number"; ...Show All

• SQL Server Error Executing Parallel SQL Tasks

  I have three SQL tasks executing in parallel in an Integration Services package.   +-B-+ A-+-C-+-E   +-D-+ It starts with task A; then B, C, and D all execute in parallel; and finally task E runs after BCD are done. B, C, and D are all Execute SQL tasks, all with the same connection manager. Here is their code: B) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      FROM temp_B C) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      FROM temp_C D) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      ...Show All

• Visual FoxPro Order a raport by a field from child table

  A have a two tables (parent table and child table). The report wizard allows order just, a raport by a field from parent table, but I need to create a raport, which is ordered by a field from a child table. I don't know how. Please someone tell me, thank you.  A second, why VFP9 don't allow to display a Query result in a Report destination   If you would do that with base tables (I do not recommend) then: select child set order to tag mySortFieldKey set relation to ForeignKey into myParent Better run an SQL that'd would create a cursor with all the filed you want and in any order y ...Show All

• Visual Studio adding a file to a folder fails

  Hi, I have a wizard that adds my own C# file to a project. If I'm adding to the root folder of the project e.g. ConsoleApplication1 then its fine. If I create a folder in Visual Studio e.g. Folder1 then use my wizard I get "Specified cast is not valid". I get the namespace name from the projectitems.Parent object which I cast to an EnvDTE.Project. The problem is because, when adding a file to a folder, the projectitems.Parent is not a EnvDTE.Project object. So what is it Is there a way of working it out Jason ProjectItems.Parent can return either a Project if the item is located directly underneath the pro ...Show All

• .NET Development furious developer -- can't compile hello world using SDK on windows x64...

  This quote from here (http://devforums.amd.com/index.php showtopic=294&st=0&p=781&#entry781) summaries my frustration: "I'm starting to think that MS doesn't want developers to code for 64-bit version of windows on a 64-bit window. They would rather you program on a 32-bit version of windows targetting 64-bit window. WTF Why release a version of window in 64-bit when you can't freakin' develop a native 64-bit program on it Does that make any sense to anyone here Then you ask why there aren't any software written for 64-bit windows Perhaps, because of *** like this Why would a developer want to develop for a platform when he/ ...Show All

• .NET Development Registry reflection

  Hi,        I have ported my application from 32 bit to 64 bit application. Is there any consideration in registry point of view Thanks, Kishore Wani Vikram is correct.  There are 2 registry hives on Win64.  By default the bitness of your process will determine which hive you access. From a 64 bit application there are two ways to access the 32bit registry hive.  Navigating to the Wow64Node, or you can open the registry key with the KEY_WOW64_32KEY access mask. Similar any 32bit applicaiton can access the 64bit registry hive by using the KEY_WOW64_64KEY access mask. Jeff ...Show All

• Windows Forms How to determine if DataGridView rows are accessible?

  Is there  a 100% accurate way to determine if cells of a DataGridView are accessible before trying to access them I have master/detail DataGridViews bound to a dataset. My code, which tries to access cells of the detail grid during SelectionChanges of the master grid sometimes  throws NullReferenceExceptions saying the detail grid columns don't exist. I want to prevent this from happening. I have tried the overly complicated condition below to block access to the detail grid's AuthorID column, when doing so would throw the exception, but it still fails. Also, I would rather not resort to wrapping try/catch b ...Show All

• Visual C++ Fairly simple school project, multiple errors

  I'm working on a toy problem for school.  It involves a binary heap, a few classes that inherit from a base class and some various helper classes.  I'm getting about 60 errors but none are descriptive enough for me to figure out what is wrong.  It compiled fine before I added some of the more recent classes I wrote, but now it's screwed.  I don't want to post all the code because it's so much, but here are the errors.  I know this isn't enough to go on, but if anyone has a suggestion for things to look for, I'd appreciate it.  Thanks: c:\Project4Heap\CarWash.cpp(35): error C2039: 'custType' : is not a member o ...Show All

• Microsoft ISV Community Center Forums Length of an Excel Macro?

  I am writing a macro but I'm not sure if it is getting too long or if there is such a thing as too long. This is what I am asking it to do: 1. open a text file and convert to excel 2. save the full file in a folder 3. delete some colums and records then resave in a new folder then resort the coulms change some data and save in a 2nd folder then close 4. reopen original file and delete different colums and save in a third folder resort the colums, change some data and save in a 4th folder then close Is this too much to ask one macro to do Am I just asking for trouble Should I split it out into multiple smaller macros ...Show All

• SQL Server How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. first thing is how to search the keywords from the tables Second thing after u search the result ,how to link the result to a number related to the result ...Show All

• SQL Server Where is Service Manager in SQL Server 2005?

  I installed SQL Server 2005 CPT on a new machine running XP.  I do not see SQL Server Service Manager.  Has something changed in 2005 over 2000   There are times when it is necessary to stop the database.  The old way you just clicked on the icon in the lower right of the PC (with the green arrow) and selected stop.  I realize I can go into XP Services, find SQLServer2005, right click and select stop, but is there some simpler way, like with an icon,  like there used to be I know this is an elemental question but I am an elemental user <g> Euan is right. With the SQL Com ...Show All

• Windows Forms Copy/Paste Functionality

  Hello, I'm working on copy/paste functionality in my application; I'm trying to figure out a paste into the application, where I paste the text into the current cursor position. How do I get that position, where the cursor or mouse currently is, in the KeyUp event Or is there a better way Thanks. Nevermind, found the Copy/Paste methods... who would have thought it would be that simple ...Show All