shahram90's Q&A profile

• Visual C# How to find registered event handlers?

  Hi, I'm trying to determine if an object has any event handlers registered on it. The reason I need this, is to not let an object to register one single event twice. this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // OK this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // Don't let it happen twice   Any help would be great Hi Patrik, and what is here the "anEvent" Is it the event itself or the event handler I just can't call GetInvocationList() on any of events.. ...Show All

• SQL Server Errors during building project with Deployment utility and configuration file

  I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in \bin\Deployment folder.  I am using Sept. CTP. If I set "CreateDeploymentUtility" to false, there are no errors since it doesn't try copying the file. Any reason why this happens Error 1 System.ApplicationException: Could not copy file "C:\test\Source\ETLProcessing\PackageProject\test.dtsconfig" to the deployment utility output directory "C:\test\Source\ETLProcessing\PackageProject\bin\Deployment". ---> System.IO.IOException: The file 'C:\test\Source\ETLProcessing\Packag ...Show All

• SQL Server Script Component -

  Hi, In our office recently installed VS .net 2005 RC and Yukon Sep. CTP. The problem is, create a dtsx package.  Drag and drop a script component in dataflow after a OLEDB source.  Let the script component be transformation type. Edit it, click on scripts in the left hand side tree, double-click on the button 'design script' (right bottom corner).  I get an error: TITLE: Microsoft Visual Studio ------------------------------ Cannot show Visual Studio for Applications editor. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.26&EvtSrc=Microsoft.DataTran ...Show All

• SQL Server SQL 2000 Merge Replication Error

  I have a merge replication publication that has been running for months. This week the Snapshot started failing, reporting that an article was not included in the publication. I checked and found 3 articles that mysteriously no longer show up as being in the publication. When I attempt to add them it reports that it can't add them because there is already an article by that name in the publication. Apparently some table has lost its rows for these articles while another table(s) still has its rows. Has anyone had this problem Is there a solution short of dropping the publication and starting over - a solution that would litera ...Show All

• Windows Forms DataGridView Soring

  I really like the new DataGridView control, however, it always seems to sort columns containing numbers and dates as if they were strings.  The Windows Forms 1.x ListView control did the same thing so what I ended up doing was to create an class that implements the IComparer interface.  How do we handle this in DataGridView The grid& ...Show All

• SQL Server Passing Variables

  I am having a hard time passing variables from the control flow to the data flow process.  The project starts off with a Execute SQL Task.  This task does a select from the sysdatabases table in the master db which creates a list of databases that will be queried for info.  That is stored in a info is stored in a package variable (user::varDBName) that is used to enumerate a For Each Loop and everything is good till this point.   How can the variable be passed into a t-sql statement in the OLE DB Source   Or can the variable be assigned to another variable that holds the sql statement that will be accessed by t ...Show All

• Windows Forms Is using this.object (C#) or me.object (Vb)more efficient?

  Just wondering whether more explicit code:  this.object.Property=true; is more efficient than using just:    object.Property=true; Many thanks in advance, I don't use 'this' because the VS wizards use 'this'.  That way I know if I or one of the wizards wrote the code. ...Show All

• SQL Server Persist Progress tab?

  is there a way to capture what gets written to the progress tab to a table, or is it overwritten on each execution as xml somewhere so it can be saved kind of like an odometer the mission is to be able to audit the results of a load, or even if it doesnt turn out to be a load, then document the run. similarly, is there a way to watch what executes to see what actually runs during a merge join transform, iow, something that exposes ssis to trace how do i find it thanks drew thanks...as much as id like to take credit for it i got the idea from Kimball and Caserta, quite a great book...though i dont know how workable their recomm ...Show All

• .NET Development How to remove "charset=UTF-8" from Content-Type

  We are experiencing problems with calling a Web Service that runs on Oracle HTTP Server powered by Apache. The Web Service returns 400 Bad Request. The explanation I got from the developer of the Web Service is that Apache doesn't accept messages that contains the information "charset=utf-8" in the Content-Type field in the HTTP Header. How can I remove the charset=utf-8 from the Content-Type field I have tried to override the GetWebRequest method for my call to the Web Service without any success. Any ideas Thanks, Simon FYI, found a workaround for the struts/FormFile issue. The issue(s) a) Struts doesn't resolve the file w ...Show All

• Visual Studio Tools for Office How to Read a Date Field from Excel Cell?

  Hello, I am trying to read an Excel cell, which is supposed to be a date field. I need to validate it, and cast it to a DateTime field. This code returns me the format, string format = ((Excel. Range )dataRange.Cells[i, 1]).NumberFormat.ToString();   and this code return the value of the cell. string  value = ((Excel. Range )dataRange.Cells[i, 1]).Text.ToString();   I can use format along with a DateTimeFormatInfo object to parse the string, and convert it to DateTime.  But, since the format can be changed by user, and somehow the format that I get is not neccessary clean (i.e. m/d/yyyy ...Show All

• SQL Server DTS Mail task breaks after SQL 2005 uninstall/install

  When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found. Any ideas on how to get my e-mail task back I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine. ...Show All

• Smart Device Development minimize by code ?

  Hi, how can i minimze a form by code. i still want my form to be on the 'running programs' list. 10X, Just for closure, this thread is answered here . ...Show All

• Visual Studio Team System Team Foundation Server MSSCCI Provider Beta 2 Now Available (Feb 20, 20006)

  The Team Foundation Server MSSCCI Provider Beta 2 is now available here . IMPORTANT:   Beta 2 is not strongly signed, so you'll need to disable strong name validation as mentioned in the README.  You can find details at http://blogs.msdn.com/buckh/archive/2006/02/21/536260.aspx . New in this beta: Support for Visual Studio 2003 and Fox Pro in addition to the already supported VB6 and VC6. Integrated Checkin - you can now associate/resolve bugs and specify checkin notes with your checkin Improved performance - opening controlled solutions, get, checkout, checkin, and compare/diff are much faster M ...Show All

• Visual J# J# is causing problems for me like usual.

  I have just finished the problem before and then saved my work. I always leave the program running for a while after I save to make sure it saves. The problem is J# will no longer let me access my code, because it wants somthing from the USB key that I backed up to. Unfortunatly I do not have the USB key right now and I need to access the code does any one know how to do that. Sorry about all of the question I keep asking. This is a major project and there always seems to be something wrong. Hi, How did u back up ur files. Did you save all the project contents manually or through Visual studio to your USB drive Is the Visual st ...Show All

• Smart Device Development Visual Studio 2005 Downloads ("Deployment")

  Deployment to my target fails unless I first manually delete the previously deployed exe/dll on the target. How to avoid this What is the exact error message you are receiving from the deployment Short of the files being in use by a process, or out of memory on the device, we normally don't see any deployment errors like you describe. ...Show All