Kiryl Hakhovich's Q&A profile

• SQL Server How to add YTD (Calculation) to Time Dimension?

  Is there any you can add YTD to Time Dimension as attribute Or it has to be Calculation Then how do we do this Is this need to base on Dimension or Measure I would prefer this to be base on dimension and show in Time dimension hierarchy. Any inputs on this are highly appreciated.   There are several ways to accomplish this.  If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim. This Dim will only contain one member for the lowest level of detail.  ie. Month or Daily.  You would then cr ...Show All

• Windows Forms Need Help Urgent

  VB.NeT Declare a structure with two members to store each record from the input file The First member should be a date and the second a single precision number. Declare a dynamic array of stuctures. Create the click event handler for the Open Input file button the code in the event handler should display an OpenFileDialog allowing the user to select a&nbs ...Show All

• SQL Server Service Broker

  My service broker seems to be broken... The database was restored from another crashed server but i have tried the ALTER AUTHORIZATION ON DATABASE :: [SPYDERONTHEWEB] TO [SA] ; The error i'm getting is Service Broker needs to access the master key in the database 'SpyderOnTheWeb'. Error code 25. The master key has to exist and th service master key encryption is required. Error: 28054, Severity 11, State: 1. You must restore the service master key encryption of the database master key of the crashed database: USE [SPYDERONWEB] ; GO OPEN MASTER KEY DECRYPTION BY PASSWORD = '...' ; ALT ...Show All

• Visual Basic Password Verification

  Hello Friends, I am new in this forum. I am implementing one appication. I need a form which will verify a user against his password. I am using VB 2005 Express Edition & SQL Server Express Edition. Can you send me a code snippet for this Bye... Prasanta Well you simply get the password the user has entered (and the username) then query the database for that usrer and check the password value from the database with the value of the entered password. ...Show All

• Visual Studio Fatal Error HXC2064: Unable to initialize the full-text index engine. Reason code 205.

  Hi, I cannot compile Help 2.0 files anymore. Whether I use NDoc or HelpStudio, I got the following message : Fatal Error HXC2064 : Unable to initialize the full-text index engine. Reason code 205. I have found this FAQ http://helpware.net/mshelp2/h2faq.htm#HXC2064 and tried to register the listed dlls without success. The targeted assembly is small and do not contain tons of comments. Any ideas Gildas Hello Gildas - were there any changes to your machine that you can account for between when the compiler used to work and when it stopped working Did you install any new or updated products that you can recall Tha ...Show All

• Software Development for Windows Vista How do you make IMemberCreationService available?

  I started a new C# console application, added the System.Workflow references and a Sequential Workflow (code) item. When I tried to open the workflow to add activities and I got this error message "The service 'System.Workflow.ComponentModel.Design.IMemberCreationService' must be installed for this operation to succeed. Ensure that this service is available." Confused, I added a WorkflowConsoleApplication project in the same solution and I could see the workflow diagram and add activities. So I checked that I have all the references tha tthe WorkflowConsoleApplication has and I'm added the System.Design, Transaction and Web namespac ...Show All

• Visual Studio Express Editions Moving to next TextBox without using TAB key

  In DB Express, how can I automatically move to the next TextBox to enter more data without having to use the TAB key or the mouse between each entry, when the entries are all only one character Hello I am sure this is not the best technical solution, but below is something you could add to the textchange event of the box.  You could modify to fit your needs... Hope that helps. If TextBox1.Text.Length = 1 Then TextBox2.Focus() End If   ...Show All

• Visual C# C# equivalent for C++ GetLastError()-method?

  Is there a C# equivalent for the C++ GetLastError()-method (defined in winbase.h) The normal .NET way of reporting errors is to use exceptions rather than returning status codes. If you're using interop, you can make an external call to GetLastError (I don't have the details to hand, but there are bound to be plenty of pages on it). Does that help Jon ...Show All

• Windows Forms Passing credentials to internet deployed winform application

  I have a winform application in C#. I have deployed it in the virtual directory. I have created a stub application which will run on the client and download the main application from the server. I am using the same concepts as given in "Death of the browser" article by "Billy Hollis" in MSDN. The stub application use "Assembly.LoadFrom(URL)"& ...Show All

• .NET Development SQL UPDATE - "No value given for one or more required parameters"

  I've used this structure in several other C# database programs with success, until this app.  Now I'm receiving this: "No value given for one or more required parameters." The key is SAMS_ID. The data is text, no numeric fields.  The code I used is below.  I've tried removing the single quotes from around the date field and also from around any fields that contain numbers but still receive the same error. Anyone know what I am forgetting private void buttonEdit_Click ( object sender , System . EventArgs e ) {     string strEditConnect = "" ;     if ( buttonEdit . ...Show All

• Visual Studio Express Editions Debug assertion failed: (unsigned)(c+1) <= 256, file isctype.c, line 68

  I have compiled a debug version of Thunderbird using VC++ Express. I intermittently get the error in the Subject. When I kick into the debugger, the stack trace seems to indicate that the range check is actually failing in the _security_check_cookie() routine. Here's the stack trace: msvcr80d.dll!1023c92d() [Frames below may be incorrect and/or missing, no symbols loaded for msvcr80d.dll] msvcr80d.dll!1023cd81() > xpcom_core.dll!nsCRT::strtok(char * string=0x040db607, const char * delims=0x0371f398, char * * newStr=0x0371f398) Line 172 + 0xa bytes C++ Here's where the application code got to - it is just trying to return fr ...Show All

• Visual Studio Express Editions Evaluate Code Stored in String

  How can I evaluate / execute code that I have stored in a string I have many textboxes named: tb1, tb2, tb3, etc. I want to run code like this: For i = 1 to 3 temp1 = "Me.tb" & i & ".Value" temp2 = [EVALUATE or EXECUTE](temp1) Next Any suggestions / helps Please also let me know which libraries need to be included. Any help is appreciated. Thank you! Take a look at the MSScript control. I would like to see exactly what you are trying to do. MSScript is quite powerful but it takes some learning. Its not hard, just takes a little practice. You need to make an interface of wh ...Show All

• Visual C# Passing a string from a C# program to a Win32 C++ dll?

  I week or so ago a few of us on this forum were trying to figure out some problems with using functions within a C# program that were made in a C++ dll, and thanks to some very helpful guys here, we were able to figure it out. However, I am now having a problem trying to pass a string from my C# program into my Win32 dll function. I have tried everything that I can think of, but since I am not all that adept at C# programming, I haven't come up with the answer. In fact, I can't seem to even properly pass a simple char , however int s and long s work fine. I'm hoping that due to my inexperience with C# that one of you C# experts will point ...Show All

• Windows Forms Can a Listbox do this?

  Hi, Is this possible for a listbox When the listitems of the listbox are selected and right-clicked, a context menu appears. Then, when the user right clicks on the empty space inside the listbox, the context menu will not appear even though an item is still selected. Also, is the mousedown event used to detect left or right clicks Yes, that can be done with codes (good thing, I have exactly what you need). 1. Create a context menu, don't assign it on ContextMenu property of your listbox. 2. Copy and paste this C# function to your Form's class: private int GetClickedItemLocation(ListBox lb) { &nbs ...Show All

• .NET Development String.Format 10.0000 to 10.00 but keep 10.0001

  Hi, I'm getting doubles with 4 decimal places, however when the last two digits are 00, I want to format to .00 but if the 3rd or 4th decimal place contains a value different to 0 I want to leave the 4 decimal places. Is there an easy way to do this with String.Format or would I have to evaluate the values and use the appropriate string formatter Thanks, Tom The default number of decimal places for InvariantInfo is 2. So you have to change it.. See http://msdn2.microsoft.com/en-us/library/system.globalization.numberformatinfo.numberdecimaldigits.aspx ...Show All