saerbawejim's Q&A profile

• Windows Forms datagridview to microsoft excel

  I have a winform application which the most of them have a datagridview in it, I need the data shown in datagridview can be exported to microsoft excel but no generate an excel file, just open microsoft excel and show the same data that datagridview shows. Has someone experienced something like that before Thanks Joseph so helpful!! i need to give some format the excel file before painting with the data, and also add some rows with some customized text, have u done that before ...Show All

• SQL Server Question to ytd()

  Hi, Ihave a Time-Dimension with 2 hierarchies: (a) Year - Semester - Quarter - Month and (b) Year -Week. Than I have a calculated member in my Cube like: CREATE MEMBER CURRENTCUBE .[MEASURES].[Sales Volume KG (kum.)] AS Sum ( ytd (), [Measures].[Sales Volume KG]), FORMAT_STRING = "#,#.00" , VISIBLE = 1 ; When I browse the cube and I use the (a) hierarchy on the colums, all works fine; I get the accumulated sums over Semesters, Quarters, Month. When I use the (b) hierarchy, in each cell I get the normal week-sum and not the accumulated. What's my mistake Thanks Hans   Hi Hans, Based on the info for the [Date] dimension above, maybe something like this will work ...Show All

• Windows Forms Control dynamically added to panel is not generating events

  I have a splitter container (SC) that has 2 adjacent panels (P1) and (P2). P1 has a DeviceTreeView control that generates events that are handled by the top level easily.However, in P2 I want to dynamically create different views so I create panels (Px) dynamically that I can switch back and forth from (works fine - events to change panels are triggered from the tree in P1).The problem arises when I put controls into the different panels, Px. The controls are not handling events that they have been configured for. The events are being handled at the container level and never get to Px.This is a windows application written in c#. The events for the controls are being associated with handlers that are in Px and are added (+=) directly after ...Show All

• Visual Basic Program to execute on one machine only

  Hello, My problem is that I want to deploy my program onto a 'thumb drive' and sell it that way and I need the program to only run off that drive. It is a small program that can easily be copied and run by anyone so I thought that if I could somehow 'lock' it to the small USB drive then that would solve my problem. Because some games require a CD to be in a drive before they will run I figured that that would be something that I could do, my problem is finding any help in how that might be accomplished. Can anyone point me in the right direction Thank you very much Bill Langston making the usb drive read-only would only keep people from writing to the drive, it would not keep them from copying the program contained ...Show All

• Visual Studio 2008 (Pre-release) Using an image as a repeating background

  I want to use an image as a background for my canvas but I just can't get it to work. The image should be tiled -not stretched - and in it's original size. Heres the XAML: < Canvas Width="300" Height="300" > < Canvas.Background > < ImageBrush Stretch = " None " TileMode = " Tile " ImageSource = " Background.jpg " /> </ Canvas.Background > </ Canvas > It just won't tile... Any ideas Thanks! Right - basically, we tile the Viewport area, and by default the Viewport is 0,0,1,1 RelativeToBoundingBox, meaning the entire destination area. As you correct determined, setting the Viewport to the ImageS ...Show All

• Windows Forms Access to the path 'e:\System Volume Information' is denied.

  whenrever i am trying from root path of drive i am getting following error other wise its working fine Access to the path 'e:\System Volume Information' is denied. how to solve this problem foreach ( FileInfo fInfo in directory.GetFiles("e:\", SearchOption .AllDirectories)) { // do some work } thanks As you've found, GetFiles() is pretty unforgiving because it assumes that you’ve got nearly unrestricted read access to all of the files and directories you are trying to access and doesn’t offer an option to override that. In order to not break down in this manor, you might be better served by writing your own code at a slightly lower level that can handle a single directory failin ...Show All

• SQL Server Sum of distinct count measure values returns same as distinct count. Need advise.

  My cube has distinct count measure called UU. I need to create calculated measure that would be a sum of daily UU numbers: Sum(Descendants([Calendar].[Month].CurrentMember,[Date]),[Measures].[UU]) Unfortunately, it returns the same result as UU on any level of my calendar dimention. Trying to investigate this I found that for some unknown reason these two queries return the same result: WITH MEMBER Measures.Vis AS SUM ( Descendants ([Calendar].[Year - Quarter - Month - Date]. CurrentMember ,[Date]) , [Measures].[UU]. Value ) SELECT Measures.Vis ON 0 FROM [MoveOnline] where [Calendar].[Year - Quarter - Month - Date].[Month].&[12]&[2006]; SELECT Measures.UU ON 0 FROM [Mo ...Show All

• Visual Studio Web Client Software Factory: I cannot create a module with name Menu

  Hello, I've been evaluating the posibility of migrate my project to Web Client Software Factory But i found the first incovenient when i try to create a new Business Module with name Menu, in Web Project the folder for the new module is not created Is Menu a reserved word Note: The Module Class Library is created but the folder in Web Project for the aspx is not Thanks in advance Hi Collarad, This forum is mostly for GAX and GAT related questions. For factory specific questions please post to the factory specific forum where you will get help from each factory team. The forum for WebClient SF is being hosted in CodePlex. thanks, -Victor. ...Show All

• Visual C++ CListBox And GetText

  In my project(Visual studio 2005, MFC, Uincode character), I add some string to a CListBox, In the case no owner draw set, it work well; but if I use owner draw set variable, and in my MyListBox DrawItem function, I use GetText to get item string, it always get the Error data no I add to. Why How I can get the right string; I think besides the LBS_OWNERDRAWVARIABLE style, you have to specify the LBS_HASSTRINGS style too. In this case "the list box maintains the memory and addresses for the strings so that the application can use the LB_GETTEXT message to retrieve the text for a particular item" [MSDN]. For more information see MSDN. I hope it helps. ...Show All

• Visual Basic <STAThread> when there's no sub main

  hi, working on vb2005, i have Application Framework checked, and use the ApplicationEvents to handle Single Instances. How would i apply attribute <STAThread> if i dont have a sub main, i start on the main form directly using application framework. i guess that related to this question would be, in which cases would i need to set this attribute and why is it good. do i need to set it in order to later obfuscate the code thanks ...Show All

• Visual Studio Team System Accidentally deleted the only licensed user!

  Do not ask why. The fact is that I accidentally deleted my account (the only licensed user) from the Server Licensed Users group. I am not able to connect to TFS now. I am planning to reinstall, but that takes much time. I tried to found a Server side admin tool, but it seems there is no such tool. Is it possible to add users to the licensed group using a command line tool Thanks. I've since learned that: This bug is fixed for the next release (can't remove the last member of licensed users) but not for our upcoming Service Pack 1 For V1, it needs to be a member of the "Service Accounts" group So, try the TfsSecurity.exe line again logged in as (or runas'ing as) one of your service accounts (for exam ...Show All

• .NET Development Delayed Datareader column error

  In a live application which i created, i noticed that after a day or two, i get a datareader error, specifically the error which returns a column name as it's message. i.e if i had written reader["col_name"] i get col_name as the error message. The problem is that i read 5 column names in a single read, and the messages vary, it not always the same column name. However, whenever i restart the server, the problem goes away for another day or two. Recently i increased my max pool size because i was having pooling issues, this had an effect on the datareader error in that it now occurs every 2-3 hours instead of the 1-2 days. pls i need help on this one Thanks Nothing really stands out as ...Show All

• SQL Server SQL Server Error 15404

  I am trying to learn replication and using Agent jobs while attached to my corporate domain. Trying to use my personal domain account to run jobs or replication, I keep getting: SQL Server Error 15404, Could not obtain information about Windows NT group\user 'MyName\MyDomain', error code 0x5 [SQLSTATE 42000] (ConnIsLoginSysAdmin) What might be preventing SQL Server from getting my account information from the domain Group ploicy Thanks in advance, Richard Changing the SQL Server Agent services (on both the publisher and subscriber) to run under my personal domain account has things working properly. I will have to experiment with other settings and the Local System account to see what exactly w ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Good tutorial

  Hello and happy new year, Excuse me for my english, please. I'm French. I downloaded the last version of XNA Game Express. I'm lost between the different versions. I found some tutorials which make some mistakes with this new version. I'd like to know the best tutorial for the actual version. Thank you for helping me. I am going to move this to the XNA GSE Groups as there are lots of tutorials listed there, Do a quick search of the threads that have been updated over the last 24 hours as there have been about 3 topics started. ...Show All

• Visual Studio Tools for Office VSTO Newbie - Connect to SQL Server Help Needed

  Hello all. I'm looking for some assistence on my current task. I come from an ASP Classic background and have been tasked at working on my companies Notes to Outlook migration. Included in this is much custom Outlook programming. As you could imagine, coming from an ASP Classic background, and now working directly in .NET development is quite a shift.....so please be patient with anything I'm missing as I'm learning along the way....:) My current task is to use VS & VSTO to connect a simple Outlook Addin to a SQL Server Database and execute a Stored Procedure using Visual Basic .NET. Even though I come from an ASP classic background, I can still do my research and find sample code and alter it for my use. But for the lif ...Show All