cgraus's Q&A profile

• SQL Server What other associated tools SQL Server 2005 Intergration Services can work with?

  Hi, all, Thank you very much for your kind attention. I am having a question which is: What other associated tools/environment SQL Server 2005 Integration Services (SSIS) can work with (like we know SSIS can work with other components of SQL Server 2005, Excel,XML files etc.), so what other tools it can work with Thanks a lot in advance for any guidance and advices for that. With best regards, Yours sincerely, This may help some regarding coding of custom objects, from http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx Programmability In addition to providing a professional development environment, SSIS exposes all its functionality via a set of rich APIs. These APIs are both managed (.NET Fram ...Show All

• Windows Forms IM-like windows forms applications

  Hi, I want to develop a simple, instant messenger like- application where there's a main windows with nicknames and pop-up chat window when you click the nickname in C#. I can create a click event to instantiate a new chat window form, but I don't know how to manipulate the chat window forms so I can have only one chat window with each nickname and transfer data between main window and the chat window. Any suggestions will be appreciated. Thanks for the help. I've managed somehow to check previous instances of the child chat form by using the OwnedForms property of the main form. As for the data passing, I just used simple public variables. Thanks again for these articles. ...Show All

• SQL Server How to: Mutiple select statements where 2nd uses column value for each record from the first

  To clarify, I'm trying to create a hiearchial grid that will display projects and their sub projects. The page the sproc is servicing is a search page where a user can display all projects by a customer or they can enter in a projectID and return info that way.  Thus you'll see If else in what I have listed below.  I highlighted in red the 2nd select statement I'm trying to get to run.  One problem is I'm getting an error: Msg 156, Level 15, State 1, Procedure sp_GetProjects, Line 33 Incorrect syntax near the keyword 'ELSE'. Think this has something to do with me trying to run 2 select statements in an IF.  Secondly, I'm not sure exactly what syntax I need to use to accomplish what I'm trying to do.  A ...Show All

• Visual Studio Tools for Office URI Formats are Not Supported

  Software:  VSTO SE, Visual Studio.NET 2005 Solution Platform:  MS Word 2003 Template I'm using the following code to open the SaveAs dialog with file name created in prompt, and set to the path of a common web folder.  However, the error I get back says that "URI Formats are Not Supported".  Please advise as to how I can edit this code for the save to web folder. Thank you, for any assistance you can provide. sample code: Private Sub FileSaveWebFolderWithNamingProtocal() Dim eRom as string eRom = " http://www.eromaddress.org/erom/foldername/subfoldername/ " ChDir(eRom) With Application.FileDialog(Microsoft.Office.Core.MsoFileDialogType.msoFileDialogSaveAs) .InitialFileName = varia ...Show All

• Visual Studio Express Editions How to download MSDN Express Library?

  I have manually downloaded individual [off-line] installation image [*.iso] of Visual Studio Express Edition 2005. But i coudn't find any link to MSDN download link for the MSDN Express Edition. Does this mean that i have to visit MSDN site each time i have a query Or does all the package [*.iso] has their own help associated with each application environment There is no link to MSDN Express Edition at http://msdn.microsoft.com/vstudio/express/ now, from where should i get the whole MSDN Express Library for reference when i'm not connected online This is quiet funny to me ... i coudn't find it! I searched almost all the pages regarding Visual Studio Express Edition 2005 [vb,c++,c#,j#]. I'll be very happy if someone get's me somethin ...Show All

• Visual C++ Excluding files in xdcmake?

  Hello, I'm currently writing a .NET Class Library in VS 2005 for use in cross-language development, and I've come across a small problem. I've been using the XML comment flags to generate an XML documentation file to accompany my library, which is working out fairly well. However, I have to include a number of header files from a different project which all support a somewhat different commenting style. So, trying to compile my project with these headers included creates a number of warnings in those associated header files (actually, 'a number' is a bit of an understatment - in the thousands is more like it). This is proving to be a bit of a nuisance as it's become very hard to separate documentation warnings applicable to my code vs. t ...Show All

• Visual Studio VS2005 Add-In (Include an existing file in a project)

  Hi all I would like to know how to include an existing file in a project using an VS2005 add-in. I'm using C# to create the add-in. I've tried posting this in other forums but didn't get any responses. I tried a using the "AddFromFile" and "AddFromFileCopy". This will only add new files. I've an existing file already in the project directory. Normally using the IDE you would click on "Show all" and the files not included in the project would apprear nested in the SolutionExplorer. Then you'd select the "faded white" file not included and right-click on the file and choose "Include in Project" this will then include file into the project or solution. ( If you have source control this will ...Show All

• Visual FoxPro Better incremental search.

  Hi all; I am looking for an example of how to do a better incremental search than just using a combo box. I need the search to: - Allow back space. - Not be limited time (The user shoudn't type fast in order to search) - Show the entry being picked as I type. Any one can give me a direction, or an example Thanks. I am looking for an example of how to do a better incremental search than just using a combo box DEFINE CLASS cboqfill AS combobox SELECTONENTRY = .T. STYLE = 0 coldexact = "" NAME = "cboqfill" PROCEDURE handlekey LOCAL lcSofar , lnSelStart , lnSelLength , lnRow ...Show All

• Visual C# Do Loops in C#

  Im new to C#, just busy moving from Visual Basic. I find the language nice, and have been coming on well so far, however at the minute i wish to use a loop; I was wondering, does C# not support the 'until' specifier when 'do looping' If possible I would greatly appreciate anyones help, maybe you could explain a little to me about loops in this language Common mistakes maybe ... Also when using a 'while' I have and error explaining something within the function cannot be void, however I am not at my own PC right now and do not have the exact error message to hand. Thanks for any help. JWH This reply is a great help, however one last question would be...Does a 'Do/Until' loop not exist in C# Tha ...Show All

• Visual C++ Program runs slower when compiled with Visual Studio 2005 (in Release with optimization)

  Hey, I have a performance problem with the new Visual Studio 2005. My code (which is a genetic algorithm) is 3 times slower when compiled under Visual Studio 2005 compared to when I was compiling it under Visual Studio 2003. With Visual Studio 2003, it used to run in 3.0639 seconds, and now it runs in 9.0031 seconds. I run both code in Release. I tried every optimization option, and adding the /D_SECURE_SCL=0 compiler command to the project options with only minor differences. Is there any other way to get back to the speed Visual Studio 2003 It is a bit absurd to upgrade to a new compiler and get lesser performances. Thanks a lot!!! Antoine Atallah I didn't mean that I disliked the new new, I just wanted ...Show All

• Visual Studio 2008 (Pre-release) Killing a Timer

  Hello all, I have a method that is using a timer as a dealy to call another function: void sb_Completed( object sender, EventArgs e) { // create the timer PauseTimer that calls pauseMethod in 3 secs DispatcherTimer pauseTimer = new DispatcherTimer ( TimeSpan .FromMilliseconds(3000), DispatcherPriority .Normal, new EventHandler (pauseMethod), this .Dispatcher); } void pauseMethod( object sender, EventArgs e) { // kill the timer pauseTimer.Stop(); } // I get this error: Error 4 'System.EventArgs' does not contain a definition for 'pauseTimer' C:\Projects\TickerApp2\ I assume it is because the timer is out of scope... So, can someone please help me to kill the timer ...Show All

• Visual Studio Team System Default TFS event subscriptions & certain actions are not updating

  Hi, What are the default event subscriptions that get registered with TFS installation In other words, as soon as I'm done with a fresh install of TFS, what subscriptions should be available in TfsIntegration.dbo.tbl_subscription The reason why I am asking is because when we add a new Area in Team Explorer, it gets recorded in the TFSWarehouse.dbo.Area table, but is not available for selection for work items. Also, adding a new member to a TFS group does not make that person available in the work item dropdowns. We had to make some modifications to the tbl_subscripton table to work around the issue of Active Directory lookup failing for a domain user upon firing an event, so I want to make sure that we have the proper TFS subscrip ...Show All

• SQL Server Excel with ADO problem

  Hello, I connect to an Excel file with ADO and I get the sheet names and after that I read the table. if the column is all integers or strings there's no problem but if the column is composed of integers and strings then only the strings are returned,others are returned empty. What's the reason Thanks Hi, did you try this here: http://support.microsoft.com/default.aspx scid=kb;EN-US;Q194124 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server How do I give a user access to SQL Server?

  Hi all I tried using my administrator account to add SQLServer as an ODBC Connection, but for some reason when it tries authenticating it fails and the reason is that the user is not trusted to use that connection. Yet on my account i've created on my domain works perfectly. I've added a new user in SQL Enterprise manager, but i still get that error. How do I set the user to be trusted to use the connection Any and as many assists on this would be great. Kr33 [edit] - Hmm, actually, I may be misunderstanding the question.  I'm going to move this question into the Data Access forum which hopefully can provide better support: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=87&SiteID=1 S ...Show All

• .NET Development .net 2.0 WinForms Application suspends for 6 min at startup

  Hi fellows, currently I do have a very strange problem with getting a .net 2.0 application to run smoothly. Used OS: Windows 2003 (1.0/1.1/2.0/3.0), Windows 2000 (1.0/1.1/2.0) The Project has been converted from a 1.1 WinForms project to 2.0 by Visual Studio. After compiling the project and all dependencies I start the executable. There is some activity on CPU and memory for about 30 seconds (loading static data). After that the whole application becomes totally unresponsive; the application main window (which already raised the "Load" event) is only an empty rectangle on the screen. The application stays in that state for about 5 to 7 minutes and then recovers and shows the mainform. Code-wise there's nothing left to co ...Show All