Alan S's Q&A profile

• SQL Server Using CTE in data paging

  I explore a possibility of using Common Table Expression (CTE) instead of temporary table in data paging. But the problem is that it looks like I can reference CTE only once in my script. I need to return data for a current page as well as the row count for entire selection. Here is my script: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_name, first_name), first_name, last_name from contacts where last_name like 's%' and first_name like 'm%' ) select row_num, first_name, last_name from names where row_num between 41 and 60 -- 3rd page order by row_num select count(*) from names go It selects 20 records, however it displays an error when it tries to execute select count(*): ...Show All

• Visual Studio Filed to import .ACF files to Access 2003

  I use Visual Source safe v6.0 for developing Access 2003 applications. I can not get Forms from Source Safe for one of the Access database. The error message is "Filed to import file 'c:\~.ACF' into Microsoft Access" Does anyone know how to fix this problem Richard: I think this problem has something to do with the "Access 2003 Plug-in for Visual SourceSafe" which can be downloaded from MS download center ( http://www.microsoft.com/downloads/details.aspx familyid=2ea45ff4-a916-48c5-8f84-44b91fa774bc&displaylang=en ).. I had a same problem when I executed the Access 2003's menu "Tools" -> "SourceSafe" -> "Create Database from SourceSafe Proj ...Show All

• Software Development for Windows Vista gdi image blur effect

  I downloaded the new Feb CTP Windows SDK and the compiler complains about missing GdiPlusEffects.h. This file is included conditionaly when GDI+ version at least 1.1 is detected. Where can this file be found The workaround is to edit GdiPlus.h and change the GDIPVER from 0x0110 to 0x0100: // Define the Current GDIPlus Version #ifndef GDIPVER #define GDIPVER 0x0100 #endif Hi Benny. Thanks for the ping. I re-pinged the people I originally pinged to see what the status was. All that ping-pong to say that...I know we have found the location of the header file in question, just a matter now of its disposition. Will get back to you shortly. Thanks for your patience. Steve ...Show All

• Visual Studio Crystal Report

  please send to me the regestration code of the crystal reports that used on the vb2003. thank you very much ...Show All

• Visual Studio 2008 (Pre-release) Underlining content in WFP RichTextBox

  Hi, I have the absolute start index and the last index of a section of text I would like to underline in a RichTextBox however there seems to be no obvouis way to do this easily. Bonus points if you know how the underlining can be nice and red and wigglely. Thanks, Rob This is the WPF/E forums, but if you're trying to do this in WPF see this post: http://blogs.msdn.com/henryh/archive/2006/08/11/696159.aspx ...Show All

• Visual Basic How to make my App start with Windows?

  Can some explain or point me to some resources on how to make my program start with Windows. Thanks. ok done, and now my program can start with Windows. Thanks. Then another question pop up, how could I remove this registry entry when user uninstall my program using Add and Remove ...Show All

• Visual Basic visual basic

  hi can anyone help me i have just started using visual basic i am doing some work for college i have been ask to design a progra asking the user to enter their name ,address town postcode and phone number i have to create 5 tet boxs foer the information when i click for the second text box should it say text box two http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpgenref/html/cpconNamingGuidelines.asp In This Section Capitalization Styles Describes the Pascal case, camel case, and uppercase capitalization styles to use to name identifiers in class libraries. Case Sensitivity Describes the case sensitivity guidelines to follow when naming identifiers in class librari ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 360 Controller Image in a help context

  Anyone know the legal issues around using an image of the 360 controller in the context of a help screen. IE: What buttons on the controller perform what actions in the game. This is a Windows game so I'm wondering if MS allows for that. Glenn, When I click on your link, it takes me to a Microsoft Connect 'Page not found' page. I see this a lot when trying to vote and I am currently logged into Passport. I think this problem may have been raised a number of times but I thought I would bring it to your attention. Thanks Andy ...Show All

• SharePoint Products and Technologies Error in communicating with Excel Calculation Services

  When attempting to view an Excel spreadsheet in SharePoint, we get the following error displayed in the web browser: Excel Web Access: An error has occurred Checking the Event Log we see: There was an error in communicating with Excel Calculation Services http://uklo2k3d02:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx  exception: The request failed with HTTP status 401: Unauthorized. [Session: (null) User: CAPCO\jtnn]. The user has full admin rights over all systems We are running RTM version of SharePoint 2007, Enterprise Edition Excel Services is enabled, configured and activated on all levels. The location is set as trusted. The rest of the server works perfectly Shared Services wor ...Show All

• Smart Device Development How can I Modify a menu's string dynamically in mobile5.0

  I want to modify a menu's string dynamically in windows mobile5.0. I use the following source code to implement it. but it has no any effect. hMainMenu = CreateMenu (); hMenu = CreatePopupMenu (); AppendMenu (hMenu, MF_STRING | MF_ENABLED, 100, TEXT ("C&ut")); AppendMenu (hMenu, MF_STRING | MF_ENABLED, 101, TEXT ("&Copy")); AppendMenu (hMenu, MF_STRING | MF_ENABLED, 102, TEXT ("&Paste")); AppendMenu (hMainMenu, MF_STRING | MF_ENABLED | MF_POPUP, (UINT)hMenu, TEXT ("&Edit")); hMenu = CreatePopupMenu (); AppendMenu (hMenu, MF_STRING | MF_ENABLED, ID_MENU_OPEN, TEXT ("O&pen")); AppendMenu (hMainMenu, MF_STRING | MF_ENABLED | MF_POPUP, (UINT)hM ...Show All

• Visual C# database connection string

  I have setup my database connection string in the web.config file: < appSettings > < add key ="ConnectionString" value ="Password=MyPassword;Persist Security Info=True;User ID=UserID;Initial Catalog=DatabaseName;Data Source=ServerName" /> </ appSettings > I'm creating a class file to hold all my data access calls: using System; using System.Data.SqlClient; namespace compass.ClassFiles { /// <summary> /// Summary description for DataAccess. /// </summary> public class DataAccess { public DataAccess() { // // TODO: Add constructor logic here // private static string connectionString { get { return ConfigurationSettings.AppSettings("ConnectionStrin ...Show All

• Windows Forms Change file ownership of an output file.

  My program generate a data file, (e.g .txt) What I want to do is RIGHT AFTER the file is generated, it will 1) change the file ownership to an admin account ( i have the admin username and password) 2) change the permission to readonly for everyone(domain user). This ways, I am sure the data file is safe and the data is correct. Thanks, Terrence Hi Terrence, Ownership means the rights to read, to write, to execute etc. Therefore if someone has the R,W,X rights, he equally has the ownership. Then, you can add the RWX rights to yourself besides letting the admin take the ownership of the file. I got the same error message if I tried an unexisted account. But it worked fine when the right account was used ...Show All

• Windows Forms custom shaped forms

  Hi I want to use an image as a mask to shape the forms. I have found some methods but they are not usable because they are slow. Does anyone know some faster methods Thank you for help but I want to set the form region from a (transparent) picture. I want to add skins to my form. I found some methods but as I said they are slow They read an image pixel by pixel and decide whether it is transparent and show/hide that part. Is there an API or faster methods ...Show All

• SQL Server AggregationType.None - how should it work?

  There is measure with the AggregationType None. A cell with this measure is not empty only if coordinates in all dimensions are leaf. It's OK. If the cube has fact dimension and for it dimension a leaf meber is selected, then it is clear, that cell values are build from only one fact table row. But AS doesn't realise it. Why Is it a bug or it is by design Here are my observations from a previous post - but didn't yet receive confirmation from MS: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=616033&SiteID=1 >> Deepak Puri MVP Posts 434 Answer Re: AggregateFunction -- Does "None" Work Edit Post | Delete Post(s ...Show All

• Visual Studio Express Editions Working with ASCII files.

  Is there a way I can open an ASCII file I usually format them with just a "," to seperate the different fields. The goal would be do be able to import these items that are NUMBER,XCORD,YCORD,ZCORD (###,####.####,####.####,0.000) Right now I don't use the ZCORD so it is usually always 0.0000. I'm not sure what I'm going to do with them once I get them imported but I have a few ideas. dustinto wrote: Is there a way I can open an ASCII file I usually format them with just a "," to seperate the different fields. The goal would be do be able to import these items that are NUMBER,XCORD,YCORD,ZCORD (###,####.####,####.####,0.000) Right now I don't use the ZCORD so it is usually always 0.0000. I'm not sure what I ...Show All