Bastian W.'s Q&A profile

• Visual C# Immediate window in C# VS2005 - how to loop through collection

  I've got an error during loading data into DataTable - "Constraint violation...Relax constraints.". I need to loop in immediate window to find DataRow that HasError. I tried: foreach(DataRow dr in dtab) if(dr.HasErrors) Console.WriteLine(dr["ID"]); but it failed: Invalid expression term 'foreach'. Is there any way to achive it Billberry You can I think, but only in VB, not C#. See: http://www.devx.com/tips/Tip/15231 type=kbArticle&trk=MSCP Bilberry ...Show All

• SQL Server ---Problem of realization replication through WEB---

  Hello There is a following mistake at replication through WEB A security error occurred I try to go through IE which user has specified in the master of creation of the subscriber, in a diagnostic mode https://Servak/Replication/replisapi.dll diag And all works, all certificates fulfil correctly who did not collide{face} in what business WHERE TO DIG The name of the server on the certificate and the one you are using in the URL do not match. Hence the error. It could also be that the the certificate is issued to machine.domain and you are using only machine in the URL. Please use the domain name and try again. Match up the names on both and retry. Let me know if you continue to ...Show All

• SharePoint Products and Technologies How to customize DispForm for Document Library

  Is it possible to customize DispForm for Document Library I cannot see display form in Supporting Files tab at Document Library properties window. If I create new display form, how to replace default form with it. Hi Ir_Vin, Open your Site with SharePoint-Designer. Double-Click your Document-Library. Double-Click Forms. Double-Click your DispForm.aspx. Make your changes (e.g. attach to another Masterpage) save (Yes, save to Site-Definition) Ready. Hope this helps Ronny ...Show All

• Visual Studio Team System TFSWarehouse shows data but reports come up empty

  Hi, The built-in reports (e.g. remaining work, related work item, etc.) that come with the project template show 0 for number of work items. I checked the warehouse database tables and do see the changes to the existing tasks. I've enabled the security permissions in the Team project, the SQL Server reporting services and the Windows share point service admin, but still don't see improvement. The number of work items shown in the reports is 0 no matter if I use VS2005, the report site or the project portal to bring them up. What else can be missing What can I try Thanks. Hi, thanks, I figured it out. The default fields used by the reports are not the same as those used in the work items, so the report ...Show All

• Visual Basic Reference to Microsoft.SQLServer.ManagedDTS.dll error

  I am using VB.NET 2002 and we have set up a test environment running SQL Server 2005. I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET. However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced. The exact message is: A reference to 'C:\Programs Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll' could not be added. This is not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure that the file is accessi ...Show All

• Visual Studio Help Integration Generated Setup

  Hi, I have created a setup program using Help Integration Wizardin Visual Studio.NET 2005. I have created a *.HxS file which I use in Help Integration Wizard. When I use this setup to install Help Files in Visual Studio.NET 2005 it correctly installs it. After uninstalling this setup when I try to run this setup programm again it runs fine but help files are not installed, though one sees the Help Topic in drop down box of Filter. When one chooses that filter it does show a hour glass icon doing something but than it come back showing no help file collections. I have no other instance of help system installed except Visual Studion.NET. Can anyone please suggest what should be done to get Help Setup working correctly Thank you. ...Show All

• Visual Studio 2008 (Pre-release) Generic exception handling strategy

  Hi, What is the recommended approach for exception handling on the WCF tier The SDK and some of the threads on this forum are stating that separate data contracts should be created to represent the various SOAP faults. Then, I am supposed to mark up the OperationContract methods with the "expected" faults (by the way, the documentation says that I can mark a service contract itself with a list of expected faults, but the compiler is claiming that it's only available for methods -- is the documentation out of date ). Then, in my service operation, I am supposed to wrap my calls (to business logic layer, let's say) in a try/catch block and provide mapping between specific exceptions and SOAP faults in the relevant "catch&qu ...Show All

• SQL Server run a DTS

  Hi, I am trying to run a DTS that export the table to a different server as an excel file. In the DTS I specified UNC path for the file to be exported. Now, I login the SQL Server with a network user MyUser and run the package manually and I see the excel file is created in the remote server. I want to do the same thing with a SQL Agent Job task. I created a stored procedure and put my DTSRun all in it as follows; dtsrun /S MyServer /U MyUSer /P MyPass /N MyDTS . I also create the job and make the owner and “RunAs” MyUser and run the task I get the following error. Apparently since MyUser is a network user, it could not login to SQL Server as I defined in my DTSRun. Is there any way I can get this DTS run under that u ...Show All

• Visual Studio 2008 (Pre-release) Can you use WSHttpBinding with a WCF hosted on IIS

  I am looking at the example of how to host WCF service on IIS I dont see any WSHttpBidning or BasicHttpBinding, which kind of threw me off for a while The example looks a lot more like ASP .Net, than the WCF service I previously compiled Can you use WSHttpBinding with a WCF hosted on IIS By default, does the WCF Service hosted in IIS use Basic or WS bindings Since I dont see any bindings, how do I know if I am really running a .Net or a WCF I am not sure which sample you are referring to... most of our samples are IIS-hosted. Have a look at http://msdn2.microsoft.com/en-us/library/ms751519.aspx You specify the bindings in the config file. ...Show All

• Visual Studio Express Editions Just a quickie

  In a previous post I asked how to get a button to stay at the bottom of the form after the form was resized, this question is a follow on . If I place, say, three buttons and a textbox in a panel, then enter the code to keep the panel always at the bottom, would the Buttons and Textbox stay with the panel Panel stay at bottom code I think this would be better than Button One stay at bottom code Button Two stay at bottom code Button Three stay at bottom code Textbox stay at bottom code Thanks for the answer Dave, Maybe next time try to be more concise, these long answers just confuse me. Graham ...Show All

• SQL Server Handling errors returned by SSRS

  We are displaying the report in our reporting application but we do not want to display errors from SSRS to the user. We want to handle the errors and display a user friendly message. How can that be done . We are making URL access to the report server. Thanks. Hi, I have my report viewer control and reporterror event to handel all the exception.Do we need to call the reporterror event in my code or automatically it will be called when error occurs Thanks, Ranjan ...Show All

• Visual Studio 2008 (Pre-release) Using PersistStreamTypeWrapper with an ADO.Recordset

  I'm currently trying to use the built-in COM+ interop with WCF. I've created a very simple C++ COM object and used the ComSvcConfig tool to create a SVC endpoint for it. The proxy creation worked fine and I'm using a simple console application to invoke a method called GetBasicRecordset which returns an ADO.Recordset with 2 rows. It works fine and the method returns an instance of the PersistStreamTypeWrapper type, which exists within the proxy class. I looked at the SDK and they make reference to a System.ServiceModel.ComIntegration.PersistStreamTypeWrapper but I'm not sure how to use it in this situation. The object returned from WCF has a dataStream and CLSID properties. The CLSID matches that of a Recordset and the dataStream is a Byte ...Show All

• .NET Development .NET Framework 2.0 Service Pack Release?

  Not sure where to post this, so here seems as good a place as any. As it stands now, there are at least several critical fixes that would (most likely) be addressed in a .NET 2.0 service pack release, including a vital sockets implementation fix which is available as a hotfix. I'd heard rumblings that this was supposed to have happened by the end of 3rd quarter of 2006. Does anyone have any projections as to when/if .NET 2.0 SP1 will be made available Don't have an answer to your question, but you should bounce that issue off of an MSDN support call. You might be able to get a hotfix pre-release. I had a similar issue a few years back in .Net 1 and the company I worked for could have received a hotfi ...Show All

• SQL Server types of records in sysobjects

  I have a question about the xtype field in the sysobjects view. What do these characters mean I think I've found lists, but are they complete What is the difference between FN and FS BOL = Books On Line ( http://msdn2.microsoft.com/en-us/library/ms130214.aspx ) or Start-->programs-->Microsoft SQL Server 2005-->Documentation and Tutorials-->SQL Server Books On Line Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Visual C# Blocking Console closure?

  I have a Windows Forms app with Console playing a part. I now run an almost debugged code from an exec that is generated after the Build command. I need to prevent Console from accidentally being closed by clicking on the tiny button located at the right upper corner. I cannot figure out if it is possible to do. The corresponding button on the form is blocked but it does not prevent the form from being closed by clicking on the button on the Console. I want to immobilize it too. I do not the app being closed accidentally in any event. Thanks. Figo Fei - MSFT wrote: What i meant is if you want to hide the close button of the form you'd set the form's controlbox. And about console, I think you'd get the handler of it ...Show All