Mario Hutter's Q&A profile

• SQL Server Stored Procedure & reporting services

  Hi, I'm trying to create a very simple report. This report consists of 4 fields where 3 already are found in 1 table For example: Table 'Products' consists of: productId - primary key (not in report) productname - (printed in report) createDate - (printed in report) parentId - foreign key which maps to another product and so creating a hierarchy. Not directly printed For re-generating the hierarchy i've used a stored procedure which takes 2 parameters: 1 IN parameter (productid) and 1 OUTPUT parameter which should return the whole product string (e.g. product1 > base product > another product > soap). I think this works ...Show All

• SQL Server Help with Case Statement

  I have the following code in which I need to check something in the ELSE. The problem is how to form it correctly. I could use a cursor I guess to transverse through the records. In the Else, I want to: 1) Check the count of the results of my statement. IF > 1 then check to see if m.original is between lowlimit and highlimit for any of those records found 2) If m.original is between the lowlimit and highlimit, then select Fee1 from FeeScheduleDetails m.original and m.FeeSchedule is out here somewhere, just know this...it's part of the query that you don't see CASE WHEN Len(c.FeeSchedule) < 3 then CONVERT(int, c.feeSchedule) ...Show All

• Visual C# how to make a toolbar button that i can write into?

  i making an editor and i have a toolbar i want to be able to change size (i know how) but like a loot of editors i want to be able to write the siz and be able to click on the size i want i know how to make a contextmenu for the click but how to make so the user can write his own number for the size here is a link about menu-stripe: http://winfx.msdn.microsoft.com/library/default.asp url=/library/en-us/dv_fxmclictl/html/f45516e5-bf01-4468-b851-d45f4c33c055.asp ...Show All

• .NET Development HTTP status 407: Proxy Authentication Required +ISA Server

  Hi, We're getting the follow exception thrown when calling our web service: System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy service is denied.  ). I've found this article, but the problem is we don't want to edit machine.config as a pre-req.  http://support.microsoft.com/ id=307220 So does anyone know how to replicate these attributes through code Thanks. I don't want to do this: NetworkCredential nwkCred = new NetworkCredential("username","password","domain"); myProxyClass.Proxy = new WebProxy("p ...Show All

• Windows Forms Selecting empty values from Database error

  I am using the Microsoft ODBC,Sybase SQL Anywhere 5.0 as back end. I get a error message "No-Data Available" when selecting data rows which have one or more empty values. If the value is null, there is no crash. I am filling my DataSet using an Odbc DataAdapter in the normal manner: This problem comes only in Windows XP. But it works fine in Windows 2000. What is the problem.....   ...Show All

• Visual Studio Team System What is Team System?

  Hi, I heard that Team System is a new tool from MS for the entire life cycle of Project Management... Can some one suggest me any reference towards Team System source or Trail versions Regards, Chakravarthy Specifically, you should take a look at: Getting Started with Team System Learn what Visual Studio 2005 Team System can do for you and the role it plays in increasing the productivity and predictability of the software development lifecycle. ...Show All

• Software Development for Windows Vista [Newbie] How to terminate a workflow from within an activity?

  I have a composite activity (custom class derived off of Sequence) that has a listen + couple of event sinks along with few other things. This acitivity is included in a workflow. What I would like to do is terminate the workflow say upon receipt of some event - say for eg. manager denies request so there is no point in continuing the workflow. 1. How do I do that 2. Are there any un-desirable effects of terminating the workflow in this manner thanks Jay You can dynamically add a Terminate activity. Alternatively you could use an IfElse with a condition to choose to execute the Terminate activity. Regards ...Show All

• Visual C# Check for missing config file.

  Hello, If my application uses values residing in the config file, how do I check before pulling the values out, that the config file present. Thank you. ...Show All

• Visual Studio Team System Missing Build Labels

  I can see the labels created by Team Build from the UI, but can't see them using "tf labels" command. Other labels that I have created manually show up in 'tf labels'. Only the ones created by Team Build are missing. Thanks much in advance. Jamil, Are you using the /owner:* syntax tf labels /server:<your server> /owner:* That should show you all of the labels on that server. By default, if you omit the /owner parameter, you only see labels create by the currently logged in account. See also: tf command line help -Steve ...Show All

• Visual Studio Express Editions Web Panels

  I'm working through the walkthroughs in the Visual Web Developer and am stuck on the Web Panel Walkthrough. I have followed the directions exactly, and when I view the page in a browser, I do not see the menu that shows the available verbs. I have double checked that I didn't miss a step. Are there any things I should verify Thanks, Frank http://msdn2.microsoft.com/en-us/library/sk23dydw - Frank ...Show All

• SQL Server Using CASE in the WHERE clause

  I am attempting to write a stored procedure that will accept a column name in the form of an nvarchar parameter along with a corresponding value to use to filter the returned results. Obviously I can write a CASE statement with the query repeated for each case with the applicable WHERE clause, but after some research I did find that according to some sites, using the CASE statement in the WHERE clause is perfectly legal. However, I have tried the following code, which is basically a cut & paste version of what I found described, but SQL Server keeps generating errors at the first WHEN clause. I would appreciate anyone's guidance getting ...Show All

• Software Development for Windows Vista not able to create globally named objects

  From MS' Windows Vista Soft. Logo doc.: Applications should not depend on globally named objects. Since, globally named objects can be created by any application or service, an application dependent on creating or maintaining such an object could fail. Additionally, a user running under User Access Protection will not be able to create a globally named object. In my app. I created global mutex for a shared resource. If this is not a "good" thing to do in windows Vista, what is the best practice MS recommend Also as of the Feb. CTP release of Windows Vista, the creation of my global mutex still working fine, so it's not ...Show All

• SQL Server Grant on all tables

  Hi, is there a way to grants object privileges on all tables of database to an user like this: grant select, insert, update, delete on <all tables> to usernamedb go thanks!!!! No. You can add user to db_datareader and  db_datawriter roles. This will however provide SELECT, INSERT, UPDATE and DELETE permission on tables/ views / table-valued functions etc. See Books Online for more details on the permissions / roles. Also, you should create a group/role and grant permissions to it instead of directly to the user. This is easier to manage and control.   Alternatively, you can write few lines of code that loops ...Show All

• Software Development for Windows Vista SetState - how to create a Role Based one?

  Hi all, For a current project, I'm wanting to create a Role dependant SetState class (ideally). The situation: 2 roles - user + manager 3 states - A -> B ->C   (for a manager A->C is possible) StateA will listen to the same event (e.g. Approve) for both Manager + User. For Manager - we want to go to C For User - we want to go to B So....my thoughts - wouldnt it be great to have a SetShape that had some Role dependant collection of 'TargetState' properties.....object model seems pretty tight around here. Question: Why is the SetState class sealed I need to respond to the same Raised Event, but produce different outc ...Show All

• Visual Studio 2008 (Pre-release) Specifying Endpoint to use with wsFederationHttpBinding & issuerMetadata

  Hi, From my other posts, you can see that after some struggles, I've got an STS working. I can use it in either of two modes, certificate only (wsHttpBinding, clientCredentialType="Certificate") or the customBinding. I have two endpoints defined in the STS's service element, however, to switch modes, I must change the default endpoint ( address="" ). In the STS:: <service behaviorConfiguration="CertificateModeBehavior" name="ConcreteSecurityTokenService"> <endpoint address="" binding="customBinding" bindingConfiguration="ServiceBinding" contract=&qu ...Show All