Orest Bolohan's Q&A profile

• SQL Server Scope & Case

  In reworking some CASE statements to enhance performance, I followed Mosha's suggestion to use SCOPE and CASE to have faster queries that are still readable. They do perform much quicker (10x), but the calculated measure doesn't behave the same way. For example, in a calculation to determine a change in a measure from one period to the next and a date dimension that contains 1 year of data over 2 calendar years (October 2005-September 2006), the first year of the hiearchy returns no data. Adding another measure to the query results in values for both measures. This works as expected... CREATE MEMBER CURRENTCUBE.[MEASURES].[Account Change % Old] AS Case When [Date].[Calendar Year Hierarchy].CurrentMember.Level.Ordinal = 0 Then N ...Show All

• Visual Basic I need help with saving URL's into my combo box after i visit them

  I want to know how to save recent web pages visited in my webbrowser. My webbrowser is called WebBrowser1 and my combo box is called combobox1 How about the following. You'll probably want to put some exception handling in there as well but this should be the basis of what your looking for. Public Class Form1 Private Sub ComboBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ComboBox1.KeyUp If e.KeyCode = Keys.Enter Then Dim cbo As ComboBox = CType(sender, ComboBox) Me.WebBrowser1.Navigate(cbo.Text) If cbo.Items.Contains(cbo.Text) = False Then cbo.Items.Add(cbo.Text) End If End If End Sub End Class ...Show All

• SQL Server Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE)

  I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS. I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already instal ...Show All

• Software Development for Windows Vista ToolboxService class and Workflow Designer Rehosting sample

  Hello, Are there any plans to update Workflow Designer Rehosting sample with System.Drawing.Design.ToolboxService class used for part of Toolbox implementation Or maybe anyone could share an example how System.Drawing.Design.ToolboxService class could be re-used with Worklfow Designer control I have not managed to set it up correctly so far. Thanks in advance Edmundas I am also having difficulties with the ToolboxService implementation from the designer rehosting example. After dragging activities into the form, my main menu becomes very slooooooow and the toolbox and workflow designer are not refreshed correctly (screen fragments are not updated, when the size of the Toolbox is change ...Show All

• Software Development for Windows Vista Private members in activity: how and where to initialize them ONCE?

  I have defined a private boolean in a custom acitivty. I need to set it when the Execute method is called, but I noticed that every time I execute the activity, the boolean variable is reset. How can it be possible Is there a method in which I can perform all private fields initializations, sure that they are done only once during lifetime of my activity Thank you very much! Sounds good Thank you very much! Now, I have a second question: why when I override custom activity's Execute method, and set a property (already initialized in Initialize() method) with a new value, when I recall the same activity and read the property, the new value is lost It seems that only Initialize() makes it to " ...Show All

• SharePoint Products and Technologies Add aspx page developed in Visual Studio to sharepoint

  Hi folks Can you tell me if this is even possible..... I have an aspx page which I have made in Visual Studio. It basically has a web form with the usual objects which are populated from a database. Now... I want to have this page within my sharepoint site, so I want to add a link to it on the sharepoint home page and when the link is clicked I want the page to load and look like all the other pages (i.e. with the sharepoint menu at the top, etc... Is this possible, and if so how The closest I have got is adding a web page, modifying it in front page and inserting my page into an IFrame, which I am not really happy to do. Any suggestions PS.... if this is not possible I would love to hear suggestions as to how to work aroun ...Show All

• Visual Studio Express Editions vb express graphics

  Hi I want to do the graphics programing in vb exp.. I have drawn two lines and I want to select these lines by mouse is it possible Vicam, According to your question, I suggest you to use the Graphics.DrawLine method that draws a line connecting two Point structures. The following code example is designed for use with Windows Forms, and it requires PaintEventArgse, which is a parameter of the Paint event handler. The code performs the following actions: Creates a black pen. Creates points for the endpoints of the line. Draws the line to the screen. Public Sub DrawLinePoint( ByVal e As PaintEventArgs) ' Create pen. Dim blackPen As New Pen(Color.Black, 3) ' Create points that de ...Show All

• Visual Studio 2008 (Pre-release) WPF not displaying images

  Hi all Today i sat down and decided to do some more work with WPF and i decided to try some stuff out with various images. But when i went to place a PNG image into my window it doesn't display. To clarify further i can see the PNG image in both the Visual Studio and Blend designers, but as soon as i run my app and the window loads with the PNG on it, i don’t see the PNG any more. Also, this same pattern seems to be happening with various other images that i have. Some work and others don't and all of them are included in the project in the root directory. If anyone can help me out on this that would be great. Thanks Anthony Here is the code if it makes any difference, although as you will see i am not doi ...Show All

• Smart Device Development Reading media serial number using eVB

  I am developing an application for a Windows CE device (HPC2000) that will run on a compact flash card. I want to protect the application from piracy by embedding the ID of the flash into the code for each card I supply to my clients. Has anyone found or developed a routine to read the serial number from within Embedded VB (3.0) ...Show All

• Visual Studio Team System How the web test plugin works

  Hi, I have two web tests and both of them use the same web test plug in which gets the recordnumbers from local database table. I am using a select statement in the webtest plugin for data binding. Both the web tests use the same plugin. I get the recordnumbers from the select statement in the plugin. For example, the select statement returns record numbers A, B, C and D. So when do loadtest with both the web tests, i think each of the web tests work on A, B, C and D. Is that true If so, how can I make the web tests work on mutually exclusive data. i.e I want webtest1 to work on A and B and webtest 2 to work on C and D. How to achieve this Are there any resources on how the web test plugin work Thanks., ...Show All

• Microsoft ISV Community Center Forums How do I display my computer name?

  Hey, How do I, with code, display my computer name Best Regards Cathrine Hi, You could tip into the Windows API. Private Const MAX_COMPUTERNAME_LENGTH As Long = 31 Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Property Get ComputerName() As String Dim dwLen As Long Dim strComputerName As String dwLen = MAX_COMPUTERNAME_LENGTH + 1 strComputerName = String(dwLen, "X") GetComputerName strComputerName, dwLen strComputerName = Left(strComputerName, dwLen) ComputerName = strComputerName End Property ...Show All

• Visual Studio Express Editions Best way to create Data report similar to pivot tables in excel??

  I have a table of data with 9 columns, the important ones being a date, client id, and service code. In excel, I would create a pivot table showing the days of the week (1 column for each day) across the top of the screen and the client id down the left side of the page with multiple service codes for each client id. The data input in each column would be the hrs and minutes taken for each day of the week for each service code for each client id. I would like to generate a similar report from my datatable through VB Express (utilizing SQL Server Express). Is there a way to do this I was thinking possibly a dataview would be my best option, but have no experience with these and could use a boost to get started. I've tried to illustrate my ...Show All

• Visual Studio Sandcastle Help File Builder

  I've created an NDoc-like GUI front-end plus a command-line builder tool for automating help file builds with Sandcastle. It's available at: http://www.codeproject.com/useritems/SandcastleBuilder.asp Using the help file builder provides the following advantages: The GUI interface is almost identical to the NDoc interface so anyone familiar with NDoc should be quite comfortable using it. You can import several settings from an existing NDoc project to start a new Sandcastle Help File Builder project. The builder will automatically locate both Sandcastle and the HTML help compiler by looking in the system path and in the Program Files special folder on all fixed hard drives. Properties are also supplied for you to specify the ...Show All

• Visual Studio Nesting Elements

  I was wondering if someone could help me get past this road block.  I have been working in the Minimal Language template.  What I would like to do is drag an ExampleElement (element1) onto the drawing surface and then be able drag a second ExampleElement (element2) onto element1, so that element2 knows that element1 is its parent on the dd side of the model, as well as having element2 confined to the bounds of element1 graphically.  The end goal of the project that I am working on is to be able to model business processes that have increasingly fine detail at each level of sub-process.  So element1 would be a general process containing element2 (which in turn could contain a finer level of detail). <An example pictur ...Show All

• Visual Basic Visual Studio .NET 2003

  Hello: Where is the best place to ask a question, or report a possible bug, with Visual Studio .NET 2003. My probelm is with the "Propert Pages" of a project in a solution. Thanks. The problem is that when I try to use a macro such as $(SolutionDir) when setting the "Output Directory" (in the Propert Pages for the project, under Configuration Properties...General), it interprets this as a literal string (and creates a directory called "$(SolutionDir)", without the quotes) instead of expanding the macro to something like "D:\usr\MySolutionDir". ...Show All