thiszhw's Q&A profile

• SQL Server YTD calculations performance

  Hi, I'm having problems with a calculated measure which is being used for returning year to date sales from the product dimension. The problem is that the performance is incredibly slow even on a very small subset of the data, and I haven't actually managed to have the sample query (below) return as of yet (I've had it running for 45+ minutes). The measure is very simple: CREATE MEMBER CURRENTCUBE.[MEASURES].[Sales YTD] AS Aggregate(PeriodsToDate([Time].[Year - Month].[Year], [Time].[Year - Month].CurrentMember), [Measures].[Sales]) I'm using it in the following query which should return about 370 rows: SELECT NON EMPTY {  [Me ...Show All

• SQL Server dynamic report header and detail

  I am building a report which has 7 columns. Mon thru Sun. The header and data columns are dynamic For ex the report looks like Mon    Tue    Wed    Thu    Fri    Sat    Sun ------ ----- ------- ----- ---- ----- ------ 2          2       4          2       4    5       6 0    & ...Show All

• Visual Basic How to Allow Interact with Desktop with ServiceInstaller?

  Hi all, I have a Windows service that needs to be installed with setting "Allow to interact with desktop" checked. How can I set this setting in the ServiceInstaller so this is checked by default after setup I found this article, http://www.thecodeproject.com/csharp/CsWindowsServiceDesktop.asp , that does what I want in C#, but I would like to know how I can add this in VB.net. Hi you all coders ! I'm stuck, service is not interacting with the desktop as expected, it is ticked under services !!! I've put below my code , I really wonder why I STILL have to go under services, untick and t ...Show All

• Visual Studio 2008 (Pre-release) Xbab applications not running from the internet

  Hi there, I am trying to run an xbap application from this URL http://www.valil.com/winfx/Valil.Chess.WinFX.xbap (other xbab apps from the internet are not running either e.g http://www.charlespetzold.com/wpf/JeuDeTacquin/JeuDeTacquin.xbap ) IE 6 gives me an error message and wont let me run the app even though I have added the site as a trusted site. It runs if I get the source and compile and run it locally. It looks like a security issue. Can some one kindly tell me what I need to do get the app running from the internet The detailed error info is as follows: Startup URI: http://www.valil.com/winfx/Valil.Chess.WinFX.xbap Application Iden ...Show All

• Visual Studio 2008 (Pre-release) ComboBox dropdown doesn't scale (bug?)

  I'm finding that when applying a ScaleTransform to a ComboBox, the dropdown window isn't scaling. Has anyone else come across this Michael If you want the dropdown to scale with the ComboBox you will need to restyle the combobox to apply a matching transform. While it would be nice to have a property on ComboBox that allows easy transform of the popup, this is not currently provided for in the standard control templates. ...Show All

• .NET Development Proxy AutoConfiguration Issues.....

  I am having some difficulties getting connectivity to external web sites through a proxy server using .Net Framework 2.0.5727 with Visual Studio 2005. I am also noticing that the same problem exists in the Microsoft Document Explorer, returning the error "Unable to connect to the remote server" for MSDN Online, Codezone Community & Questions search locations. The documentation suggests that the proxy should be automatically configured (unless configured otherwise) to use the IE settings. I have checked the app.config and machine.config and there are no entries specific to proxies (other than the initial settings in machin ...Show All

• Visual Studio Express Editions New Project in VB.NET

  When i create a new project in Vb.NET Express. it creates a folder by name "My Project" I want to know reason for creating this folder and purpose of file under this folder. Regards Jeevan. hi, actualy you can write all your classes in one file without anyfolder or you can write your project in many files and use the commandline compiler to build your project but you have to provide path for every file, but you have to type too much like that so visual studio creat one folder and gather your files names in the .vbproj so you can open it in your IDE and compile it all at one step that will be easier and ...Show All

• Visual Basic Code Analysis doesn't appear in the error list

  Code Analysis doesn't appear in the error list When I run the code analysis, the error list opens.  It tells me how many warnings I have.  But the list is blank. Any suggestions dennist685 Maybe you set the list not to show Warnings by accident. Can you try clicking on the tool bar button with the number of warnings HTH, ...Show All

• Visual C++ Classes and Declarations

  Here is my venture into graphics programming with .NET: public ref class frmMain: public System::Windows::Forms::Form { public : frmMain() { this ->BackColor=System::Drawing::Color::White; this ->ClientSize=System::Drawing::Size(100,100); this ->Paint+= gcnew System::Windows::Forms::PaintEventHandler( this ,&frmMain::frmMain_Paint); } private : void frmMain_Paint(System::Object ^ sender,System::Windows::Forms::PaintEventArgs ^ e) { e->Graphics->DrawLine( gcnew System::Drawing::Pen(System::Drawing::Color::Black),0,0,100,100); } }; void main() { System::Windows::Forms::Appli ...Show All

• Visual Studio 2008 (Pre-release) use xaml pages in asp.net project

  hi folks I created asp.net project and want to navigate through it to xaml page by using hyperlink when I did  it, I got exception "System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."     used VS2005 and MS windows SDK beta2.0 how I can fix this problem   XAML Web Applications are a particular type of application, which are executed in a sandbox If I'm correct, it's not possible to link directly a XAML page in a ...Show All

• Visual Basic Migrating from Ms Access to SQL Server 2000

  Hi, Is there many changes need t o be done in order to change my DBMS. Currently, i'm using Microsoft Access in my VB.net program. however, i need to change the DBMS to SQL Server. So what should i do can i still use back the same coding what namespace should i include Hi there, Firstly, I would consider using the Access Upsizing Wizard to migrate your database from MS Access to SQL Server if you have not done so already. If you've migrated via a different means, then a good start would be having the database schemas for the two databases almost identical (you won't get an exact match because SQL Server 2000 has a couple of differe ...Show All

• .NET Development Framework 2.0 redist beta v2.0.50215 / Framework 2.0 runtime v2.050727

  hello. i am live with a portal which uses version v2.0.50215 .... Is it possible to install on a the live server also the current fullversion of .Net framework v2.050727 without to uninstall temporary v2.0.50215 thanks No. You can only install one copy of .NET 2.0. You will need to remove .NET 2.0.50215 before installing the RTM (2.0.50727). ...Show All

• SQL Server Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get the "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed."  I read the thread which dealt with this er ...Show All

• Visual Studio Express Editions Tables don't show up in Data Sources in VB2005 Express

  After running the wizard to set up a data source to an Access database the tables do not show up in the data source window. What am I not doing right I had the same problem.  Here's the fix I found. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=125279&SiteID=1 ...Show All

• Microsoft ISV Community Center Forums How to build this??

  I'm VBA beginner programmer. I'd like to execute a query in Microsoft Access and then save the result in an excel file with a given name in a given sheet. Is it possible How Running this in Access always put records in A1 cell. strSQL = "SELECT * INTO [Excel 8.0;Database=C:\book1.xls].[Sheet1] FROM Employee" CurrentDb.Execute strSQL Read records in DAO.Recordset in Excel and Range.CopyFromRecordSet can put anywhere of a worksheet. Export always put data in A1, Import can put data in any cell. Furthermore, CopyFromRecordset has this property: if the any column in DAO.RecordSet contain null value, the ...Show All