Martin Danner's Q&A profile

• SQL Server LoadReport() - SoapException - Help needed

  Hi Experts, getting the Error: Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport when calling LoadReport(). I can access the ReportServer and ReportManager through Browser and get perfect results. I also can querying the WebService through a DataSet (XML-Data-Provider) in a Report Project. VS 2005; SQL SERVER 2005; IIS6; Windows Server 2003. RS is configured on DefaultWebSite(Port 80) rsExec = new rsExecService. ReportExecutionService (); rsExec.Credentials = System.Net. CredentialCache .DefaultCredentials; rsExec.Url = http://pserver01/ReportServer/ReportService2005.asmx ; // Render arguments byte [] ...Show All

• SQL Server MIN and MAX strange results

  I want to get the MIN and MAX value of a table column from a specified period of time. I execute a query and it return the result. The problem is that the values returned by MIN and MAX are not always correct!! This is the result table Date Statement From To 1 2007-01-03 00:00:00 Invoice 1 2 Correct 2 2007-01-04 00:00:00 Receipt 1 1 Correct 3 2007-01-04 00:00:00 Invoice 10 9 Wrong 4 2007-01-05 00:00:00 Receipt 2 5 Correct 5 2007-01-05 00:00:00 Invoice 100 99 Wrong 6 2007-01-08 00:00:00 Invoice 124 175 Correct 7 2007-01-09 00:00:00 Invoice 176 224 Correct 8 2007-01-10 00:00:00 Invoice 225 265 Correct From =From Statement Number To= To statement Numb ...Show All

• Windows Forms Delete all the files while UnInstall

  Hi All I created a setup project for a windows application with lot more files with respective directories. The DLL files and other few files are not being deleted while doing uninstall/Remove from setup. How to remove these folders and files while doing uninstall/remove. Some time I thought we can call a batch file to remove all the directories and files but for this we need to know where our application is installed (e.g C:\Program Files\MyApplication ). It would be grateful if any helps.... Thanks The best way to save the installation folder is to create a registry item that contains the value [TARGETDIR], like that in the brackets and case-sensitive. That will res ...Show All

• SQL Server Getting result in single query

  Hi I have table like following Col1   Col2    Col3  Col4 Col5 x          y         Z          T         30 x         y          Z          T         40 A        B         C         D        20 A    ...Show All

• Visual Studio 2008 (Pre-release) Binding DateTime - formatting issue

  I'm working on a Windows machine which has got CurrentCulture set to "en-AU" but CurrentUICulture set to "en-US" This is causing binding to flip dates around such that 7/2/2007 becomes 2/7/2007 - not good! I've tried setting the CurrentUICulture to CurrentCulture but am guessing that a separate thread is displaying the xaml as the binding still fails. One option is to attribute xml:lang, or the Language dependency property, but this would cause US users to see an Australian date format for example. Is there a way to set the CurrentUICulture to the CurrentCulture so that WPF sees the change And on a side issue, why would the two cultures be different Thanks in advance, Graeme Graeme, ...Show All

• Visual Studio ItemAdded, ItemRemoved, and ItemRenamed events not firing when moving a file

  I'm working on VS 2005 add-in that needs to capture details as files are added to, removed from, or deleted from C# projects. I can successfully got ItemAdded, ItemRemoved, and ItemRenamed events when user added, removed or renamed files. But I found the problem. For example, I have for following files and folders in Solution Explorer: --Folder1 -- File1 --Folder2 -- File2 I selected "File2", drag it to "Folder1" and drop. No events I got !!! The same situation when I cut "File2" and paste in the "Folder1"! Can anybody advice me, how can I track events when file moved into another directory Please help! I filed a suggestion to the VS team ...Show All

• Visual Studio Sandcastle - System.NullReferenceException related to interface implementation

  Firstly, I should note that I have found the solution to the problem I am about to describe, and that what I am querying is if the behaviour I have found is a bug. I am receiving the error message below from BuildAssembler during the processing of several of my assembly's type information. Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Ddue.Tools.CSharpDeclarationSyntaxGenerator.WriteNormalMethodSyntax(XPathNavigator reflection, SyntaxWriter writer) at Microsoft.Ddue.Tools.CSharpDeclarationSyntaxGenerator.WriteMethodSyntax(XPathNavigator reflection, SyntaxWriter writer) at Microsoft.Ddue.Tools.SyntaxGeneratorTemplate.WriteMemberSyntax(XPathNavigator reflection, Synt ...Show All

• Internet Explorer Development IE 7 RC 1 and scrolling div. Need Help ASAP!!

  I've got a problem with IE 7 RC 1 and my web site. I open my web site in a tab and then open another tab and go anywhere (Yahoo or Google). I sit on that tab for a while and then go back to my web site. The table expands and looks awful. I've included the link to the one of the pages with the problem. http://www.barryandrebecca.com/favorites.cfm Look at the source and see if you can figure it out. ...Show All

• Windows Forms Screensaver Events and performing functions just prior to ss execution.

  Where do I go to find out about performing functions in .NET just prior to a screensaver execution, and subsequentially a logoff from the app ===================================================== Here's the question I will be asking: Can someone help me code the following Just before the screensaver (Windows XP) kicks in, I want my program to do some basic functions (set a variable, save a record, and close a form). How can I get the form to recognize that the screensaver is about to kick in, (and this particular screensaver will log the user out of the app), and perform the code prior to screensaver execution It's that simple. Is there a simple answer If you have me writing extra classes for this, PLEASE treat me as ...Show All

• .NET Development Windows form that "eat" memory...

  Hi I have built a windows form that use a System.Timers.Timer, the program itself runs just fine. But if I have the program open and check the task manager I can see that the program increase it's memory usage by 4-8kb every 10 seconds or so. What can a thi’ng like that depend on. What should I look for in my code, I mean this cannot be right that the program "eat" memory... The application is built in VS 2003 Best Regards M If you are absolutely sure that the memory doesn't eventually get reclaimed by the garbage collector (it can take a while), try running it with the CLR profiler . ...Show All

• SQL Server sysprocesses versus Dynamic Management Views

  I am using SQL Server 2005. As I understand it, the table sysprocesses has been deprecated and we are supposed to use Dynamic Management Views (DMVs) instead. I need to be able to determine which sessions are connected to which databases on a server. I can get this from sysprocesses.dbid, but I can't find it in the DMVs. I put together this query: select session_id , dbid from sys.dm_exec_connections cross apply sys.dm_exec_sql_text ( most_recent_sql_handle ) There is a column in sys.dm_exec_sql_text() called dbid, but it is null most of the time because the function shows actively executing queries. Also, there is a column in sysprocesses called cmd. This does not appear to be in any of the DMVs. Thanks, R ...Show All

• Software Development for Windows Vista Lasermouse 6000 scrolls too fast

  I have Vista RC1 version 6.0.5600 (32 bit) running on a HP Nx7010 laptop with 1 gig ram. I am using a Microsoft lasermouse 6000. The problem is that the wheel scrolls way, way too fast in the vertical direction. If you have a large document, you only have to breather on the mouse wheel and it's zoomed off about 3 pages (minimum). In the wheel options in the mouse settings of control panel, I've got it set to only scroll 1 line at a time, but it's still stupidly fast. It makes the wheel unusable and you end up resorting to dragging the sliders around. Cheers, Glyn. Ok, I have had the same problem and it has also been driving me crazy. I removed all old mouse drivers, re-booted my machine inst ...Show All

• .NET Development framework 1.1 vs 2.0 is Inconsistent

  When running this code against the 1.1 framework the output looks like <rs:data xmlns:rs="urn:schemas-microsoft-com:rowset"> <z:row HireDate="1992-05-01T00:00:00.0000000-05:00" xmlns:z="#RowsetSchema" /> </rs:data> When running against the 2.0 framework the output looks like <rs:data xmlns:rs="urn:schemas-microsoft-com:rowset"> <z:row HireDate="1992-05-01T00:00:00-05:00" xmlns:z="#RowsetSchema" /> </rs:data> It is the same sql server instance. Does anybody know how to control the timezone and or number digits of percesion returned in the milliseconds part it's almost like the 2.0 framework just drops the ...Show All

• Visual Studio Team System Listing global groups on TFS

  Hi, Is there any API to list the names of global groups on TFS eg, [SERVER]\Team Foundation Administrators, [SERVER]\Team Foundation Valid Users etc. Manasi You can find the list of global groups on TFS for a particular project using "IGroupSecurityService" namespace of "Microsoft.TeamFoundation.Server". You can get the list of valid groups as follows: Microsoft.TeamFoundation.Server. IGroupSecurityService igroup = tfs.GetService( typeof ( IGroupSecurityService )) as IGroupSecurityService ; Microsoft.TeamFoundation.Server. Identity [] ident = igroup.ListApplicationGroups(ProjectURI ); ...Show All

• .NET Development .NET 2.0 runtime error

  Hello Everybody, Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 5000 Date: 2/11/2007 Time: 5:46:04 PM User: N/A Computer: PDOCOWNER Description: EventType clr20r3, P1 patientdocapplication.exe, P2 1.0.2537.30758, P3 458fe3e6, P4 patientdocapplication, P5 1.0.2537.30758, P6 458fe3e6, P7 47, P8 c6, P9 system.invalidoperationexception, P10 NIL. I get the above error in my event log when i try to run Windows Application on client machine which has Framework 2.0 installed. It works fine in my dev machine which has VS2005 installed but bombs when i try to run the app with a Microsoft report a problem dialog box. The app was frist started in .NET 1.1 and then was migrated in middle o ...Show All