jkolonko's Q&A profile

• SQL Server User return value of a SP in another SP (SQL Server 2000)

  Hi group, I need the result of a SP in another SP. The SP I need to have the result of does not have an output param. It just returns a result. I tried the following code: SELECT @WeightedAverage = EXEC uspCalcWeightedAverage @StartDate, @EndDate, @InMarket, @InProductType, @InWeekDay I get the following error: Server: Msg 156, Level 15, State 1, Line 26 Incorrect syntax near the keyword 'EXEC'. Is it possible to fill a variable with the result of a SP TIA Regards, Sander This will store the result of an sp call declare @WeightedAverage int; execute @WeightedAverage = uspCalcWeightedAverage @StartDate, ...Show All

• SQL Server Datafields in report header

  Hi. I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers". How can I do this Regards, Tomsi   Hi Tomsi,      you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and ...Show All

• Visual Studio 2008 (Pre-release) Object-oriented network database

  Hi, All! I am Ukrainian scientific researcher and developer. I am developing object-oriented network knowledge database which is based on object-oriented database engine. I already implemented .NET 1.1 support. It's very cool that MS devolops declarative object query language for C#. I hope I'll be able to integrate LINQ features into my engine. Now I have to use three fields to store object soft pointers. One for object handle; One for wrapper instance to pin the object instance in memory; and One for instance of user object. I want to hide implementation details from end user. To make this I need some kin ...Show All

• Windows Forms Grab FileName from OpenFileDialog

  I want to grab just the filename from the OpenFileDialog box and not the whole path. How can I do this without creating a function Thanks Ken! That worked perfectly! Wasn't thinking about that one. Thanks for the help! ...Show All

• Visual Studio Team System During a merge, the "Building Change Summary" goes into infinite loop

  My machine hangs while resolving conflicts during a merge. Here's what is happening: I initiate a merge between 2 branches It correctly identifies the conflicting files. I select one of the conflicting files and click on "Resolve" button. The "Resolving Conflicts" window comes up saying that its building a change summary. This process of building change summary keeps spinning.....and my machine hangs. The resolving conflict operation never ends. Note: This only happens for some files and not others. I tried doing this from multiple machines and got the same result. Is this a known problem, bug ...Show All

• Software Development for Windows Vista ASP.NET & Vista

  Hey gang. I am trying to use ASP.NET on Vista and I'm having some difficulty. I created a default.aspx that just says "hello" and it won't even serve the page with IIS 7. Could someone please help me out I'm getting this error: Server Error in 'Default Web Site' Application. Do I need to run aspnet_regiis.exe I don't want to run it because I know IIS 7 is supposed to come with ASP.NET preconfigured I think But just asking. How can I get IIS to default to its "factory default" configuration I tried uninstalling IIS and reinstalling it but it still won't serve a simple .aspx file. Thanks and take c ...Show All

• Visual Studio Express Editions Passing One Var Between Two Forms Using Constructers?????

  I know it has been asked at least 3 Times.... The answers are way to general and assumming an Understanding of OOP to be helpful to me.... Could someone Please post some very simple EXECUTABLE Code that does this using two forms...... two buttons and One variable.... Thanks I'm not sure what you mean about the buttons but if you want to write a constructor in a form that takes an argument it would look like this: Private myObject As Object Public Sub New ( ByVal obj As Object ) ' This call is required by the Windows Form Designer. InitializeComponent() ' Add any init ...Show All

• .NET Development FileInfo LastWriteTime Exception

  When calling FileInfo.LastWriteTime on a non-existent file under the 1.1 framework you receive a DateTime.MinValue object in return. When doing so on the 2.0 framework a FileNotFoundException is thrown.  I believe this is better but represents a change in the behavior of the framework.  I assume this will remain the same in the 2.0 final release. The MSDN help files don't document this change, nor could I find anything in the text file included with the installation. Is there anywhere one could go to find documented differences in behavior between prior framework verions and 2.0 That would certainly help reduce the chance for unex ...Show All

• Visual Studio Express Editions exporting exe to work another computer

  ok trying to send a console application .exe to friend to get their opinion on a small program but they can't run it. they are on a winXP pc like me how can I export an exe file to work on someone else's pc -mike If you're using .NET, they need the .NET framework. If you use C functions, you need the msvcrt dlls. If you use MFC, you need the MFC dlls. As you've posted in the Express Edition area, I assume you're not using MFC ( as you can't ), but you're probably using the .NET framework. Which means anyone who wants to run your code needs to install .NET 2.0 first. ...Show All

• Windows Forms Cannot retrieve application, authentication error.

  Hi, I have enabled Integrated Windows authentication on the deployment location and clicking the Url users would be challenged by IE to enter their domain credentials. Once the user clicks on Install button and after verifying application requirements it would throw an error saying "Cannot retrieve application, Authentication Error". Since IE has challenged the user to enter his domain credentials and for further request click once doesnt seem to use the credentials entered by the user rather it picks up the logged in credentials of the user due to which Authentication error is thrown. How do I make sure if somebody has ...Show All

• Visual Studio User defined reports

  Can the final user modify the .rdlc file to have a customized report Is there (o will there be) a "Designer" external to Visual Studio Short answer: No. There is a "Designer" external to Visual Studio; it is called Report Builder. Report Builder is meant for end-users, but it cannot be used to edit .rdlc files. Report Builder can only edit reports that were created using Report Builder. What is your scenario that requires end-users to be able to define reports Are there others out there with a similar requirement ...Show All

• Visual C# enums, ints and strings

  Is there any way to convert an int value into a string representing an enum value enum ViewMode { View Mode0, ViewMode1, ViewMode2, ViewMode(n) }; int vm = 2; txtViewMode.Text = ... {turn vm into a string, "ViewMode2"} Can this be done Yes it can be done. But why use enums in your case Care to elaborate why you can't use a simple array of strings :) Anyway here's how to do it. Use the static methods of the Enum class to get both value and string representations of all the entries in an enum field: enum Color { Red, Green, Blue }; int val = 1; string str = Enum.GetName(typeof(Color ...Show All

• Visual Studio Team System Unable to change WSS template

  Hi, All, I'm in te process of customizing the CMMI processtemplate to better match our project approach. A part of this customization is changing the WSS template. I altered the standard CMMI site and saved it as template. I then downloaded it and uploaded it to the site templates in the root directory of WSS. I placed the name of the template in te wsstask.xml. When i ryed uploading it it gave an error indicating the wss template could not be found. When I used the title of the template instead of the name the process template uploaded. When I try to create a project i receive an error that the template can not be found or is invalid. Does ...Show All

• Windows Forms How to tell when a form's minimized?

  Is there any way of telling when a form's been minimized I want it to redisplay data on another form, but can't find an "OnWindowStyleChanged" event or similar to trigger it. Override the Form.OnResize method or handle the Form.Resize event, for example: protected override void OnResize(EventArgs e) {     base .OnResize (e);     if (WindowState == FormWindowState.Minimized)    {       MessageBox.Show("You minimized the window.");    } }   ...Show All

• SQL Server retreiving connection strings from machine.config

  Hi, I'm trying to figure out how to retreive connection strings from the machine.config instead of storing the conn strings in a *.dtsconfig file. The reason that I'm trying to use the machine.config is for the simple reason that I'll be able to manage all of the conn strings in one location on each server. (Instead of mutliple dtsconfig files.) Is it posible to utilize the machine.config in SSIS If so, could someone explain how, or better yet, have an example thanks for the help! Doesn't seem like a great idea, as you would have read and set the values yourself. Support for reading and assigning va ...Show All