041661K's Q&A profile

• SQL Server Can I use else if... like this?

  hi, In SQL Server, does it have this: if... else if ... else if.... else.... It seems I have to do it like this: if.. else... begin if .... else begin if...... end end i think you can do it this one works well USE pubs IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15 BEGIN PRINT 'The following titles are excellent mod_cook books:' PRINT ' ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END ELSE IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') > $15 BEGIN PRINT 'The following titles are expensive mod_cook books:' PRINT ' ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END ELSE IF ...Show All

• SQL Server SQL Server Session State - using a 1.1 database schema for 2.0 session state storage

  The 2.0 version of ASPSTATE is slightly different than the 1.1 version in that one table has one additional column and another table uses a different data type and size for the key. The 2.0 version also has a couple additional stored procedures. We'd like to manage just one session state database if possible so we're trying to figure out if Microsoft supports using the new schema for 1.1 session state access (it seems to work, but our testing has been very light). Is there any official support line on this If not, can anyone comment on whether or not you'd expect it to work and why Thanks. You can use the 2.0 ASPState database schema for both 2.0 and 1.1 ASP.NET applications. "Some o ...Show All

• Microsoft ISV Community Center Forums Allowing the user to pick a cell in excel

  Hi, I would like to allow the user of my program to choose which cell that should be the starting cell for my program. How can I do this with a macro. This is how the code should work: It searches the worksheet for a specific text-string(This part have I fixed). If it fails to find that cell I want a pop up window to be visible where the user is asked to point out which cell that should be used as starting cell. The, by the user selected cell address should then be assign to a variable inside the code. Anyone that knows how to do this \Jonas Hi, I think giving you my utility file is more helpful. I am kind of too lazy to look into the whole thing. Basically this utility file give you all the example of some useful stuf ...Show All

• Visual Studio 2008 (Pre-release) How do I configure "Sign", "SignEncrypt" for the secure communication?

  Hi Community, I saw this entry in the forum http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=321312&SiteID=1 It mentions that I can use security mode = " Message " > < message clientCredentialType = " UserName " defaultProtectionLevel = " EncryptAndSign " algorithmSuite = " Aes256 " /> Is defaultProtectionLevel attribute been changed If it is changed to what and where Thanks, - Pankaj. Thanks Michele. I am trying to create options from client side. I want to say from client side that just do "Sign" or "Encrypt" or "EncryptAndSign". I want to do this for message level. I need to make a WCF client ...Show All

• Visual Basic VB.NET console application doesn't want to work as a scheduled task??!!

  Hi all experts, I'm experencing a very strange error. I created a windows console application to check all the process on server and if there is one or more process doesn't work, the application sends out an email. I deployed the application on the server and when I run it by double click the .exe, it works fine. If I add it as a scheduled task, it never gets the list of process correctly. Could anybody help me out Below is the code piece of get process list. ' GetProcesses For Each proc As Process In Process.GetProcesses() Try If proc.MainWindowTitle.Length > 0 Then Console.WriteLine(proc.MainWindowTitle.ToUpper().Trim()) procs.Add(proc.MainWindowTitle.ToUpper().Trim(), pro ...Show All

• SQL Server Aggregation Storage Question

  Hi, I have built a cube in which the aggregation storage is about 45 GB, the cube size is 2 GB. When I look into the data folder in the directory where Analysis Services is installed, I just see the size of the folder corresponding to the database as 2GB. I am not able to understand at what location the aggragations are stored, can some one please help on this. Also is there a way to change the location of where the cube data is stored, let's say I want to change the storage location to a different drive on the server, how can I accomplish that. Thanks Edward, Thanks for the response.... I now understand that the aggregations that I see in the wizard are essentially estimates howeve ...Show All

• Software Development for Windows Vista background windows flickers on top of fullscreen application in vista.

  Hi, I'm working on a game for it to be vista compatible. It obviously works fine on previous OSes including XP. A user can actually start game and play it but the problem is that when game launches and goes to fullscreen, background windows such as open windows explorer flickers on top of the game screen. The flicking goes away once the user alt-tabs out and alt-tab back in. At the same time, when the screen flickers, there are two mouse cursors(original window cursor, and game's modified cursor image). I can move the window cursor and game's cursor sometimes follows window cursor movements. When I click mouse button, it seems to click on the flickering background window and goes out to window(same as alt-tab) Another symptom is that when ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3D10 date

  has D3D10 an official launch date yet and the video cards with D3D10 support, how much are they gonna cost (aprox.) Direct3D 10 will launch together with Windows Vista. The price for Direct3D 10 hardware should be the same as for new graphic cards in the past. ...Show All

• Windows Forms how to write my own add methode ?

  i imported a dialog into my project, you know the one with two buttons "OK","Cancel" now my program will add more controls onto this dialog form at run time problem is it's quite messy to possition those controls with the right relative distance one with another so i decide to write a procedure for this purpose and i think this procedure should be placed in the dialog class which have a control property with already an add method i am new to OOP so i dont know weather it's overide or else my idea is to have polymorphism feature with different signatures it will behave differently btw: anyone knows if there's already such a function in the .net framework thanks in advance ...Show All

• Visual Studio Express Editions Maximize preview...

  HELP... i dont know how to maximized the size of the printpreviewdialog ... Dim ppd As New PrintPreviewDialog ppd . Height = Screen . PrimaryScreen . Bounds . Height ppd . Width = Screen . PrimaryScreen . Bounds . Width ...Show All

• Software Development for Windows Vista Help for Vista compatibility

  We are trying to run an application as a standard user but Vista is still asking for elevation. We need support and it seems hard to find answers. - Does someone can gives us help - Is it possible to find which part of the code cause this elevation Is it possible to test on windows XP the Vista Compatibility The standard user application can't run properly where can I find help Thank you for the quick response. Hi, The application isn't check as "Run as Administrator". I have some logs that I got with app verifier. I will post it below, can you take a look - <avrf:logEntry Time="2007-01-19 : 06:11:30" LayerName="LuaPriv" StopCode="0x331B" Severity="Error ...Show All

• SQL Server SSRS to set display properties at Internet Exporer Level

  Hi All, I have report which correctly outputs the PDF Export as well as when it displays it in the Reporting Services it is correct. When it is deployed at the report server(IE) the view seems to differ a bit. As the report is a combination of Table adjacent to a matrix the IE view makes the Matrix move in the next line. Any thoughts on how can i control the display properties at the IE level only as the other views seems to be working fine. Regards, Vikram Hi , I have tried that but it seems to introduce an extra space between the table and the matrix as they need to be just adjacent to each other. Secondly do you have any idea if this is a limitation of RS to affect only th ...Show All

• Visual Studio Tools for Office How to work with Excel Rows and Cells?

  Hello, I am new to VSTO and VS 2005. I have a challenge to develop a prototype of an Excel sheet which will allow my testers to create test cases using some inputs from external source like a XML file or a VBScript. Scenario is like this: I need to develop an Excel sheet which connects to a XML file and some script file. It parses these files and loads some values in a TreeView control. I did this using UserControl and displaying this in TaskPane. Then I created Range to hold the value selected in TreeView. However, when I select a value from TreeView, it is copied in all the cells of defined range. I want to control this. I want to copy the value in selected cell and row or the cell which is active in defined Range. ‘Environm ...Show All

• Visual Studio Express Editions Open Specific File

  Hi all, How can i open a file without using the OpenFileDialog and i know the location to display a text file into a rtf box Any Help will be appreciated, Thanks in advance MW200675 I think the problem lies in the space in the fileName. I encountered the same problems and still could not fix it. Any suggestion ...Show All

• Visual Basic Variable Declaration Shortcuts

  I am working on a project for a customer and the previous developer had used shrotcuts like ! , % , $, # when declaring their variables. I have never used these before and cannot find any documentation on these. Has anyone ever used them before Hi, These are also available in VB.Net. If it is recommended that we all stop using them then I will continue to use the Convert CLASS. Code Block Dim myNum As Object myNum = 8.0! 'Single. myNum = 9% 'Integer. myNum = 10& 'Long. myNum = 11.0# 'Double. 'Why was F decided to be used for a sin-gle Why not G as the 1st letter of the 2nd syllable 'Why was R decided to be used for a dou-ble ...Show All