chaza's Q&A profile

• SQL Server MDX Query

  Hi, Before I start, all the queries here have been used for my learning process and they may don't make any sense. I've got a little bit confused about the way a specific MDX query executes. Underestanding the following query is simple: (I used AdventureWorks sample database and DW) WITH MEMBER MEASURES.PROFIT AS ([Measures].[Internet Sales Amount]-[Measures].[Total Product Cost]) SELECT MEASURES.PROFIT ON COLUMNS, [Customer].[Country].MEMBERS ON ROWS FROM [Adventure Works] for each member of country hierarchy in customer dimention it calculates the profit. but I don't get how the following query is executed: WITH MEMBER MEASURES.LOCATIONNAME AS [Customer].[Country].CURRENTMEMBER.NAME SELECT MEASURES.LOCATIONNAME ON COLUMNS, [Customer]. ...Show All

• Windows Forms Reading online document and Puting it inside a stream

  HI I'm using a private control to load and print PDF documents inside my windows form I need to pass a Stream as a parameter to the LoadFile control's method. The Stream should store the PDF document with is online (not in the client machine) How can I read a document from the web and put it inside a Stream thanks Not exactly a Windows Forms question. Before we get carried away: any objection against downloading the document in a file first ...Show All

• .NET Development Logging Data Truncation While Using SQLBulkCopy

  Hi, I am using SQLBulkCopy class of .Net 2.0 to copy data from excel to SQL 2000 database. My problem is that I want to log records whose data was been truncated as the field length in the database was not sufficient enough to hold data present in the excel file. For example suppose there is a column called 'Employee Name' in the database as varchar (30) now if I try to insert data using SQLBulkCopy class from excel file having data of more than 30 characters for some rows then somewhere I want a log which helps me to identify that row number 10 & column number 20's data was truncated due to field length. Thanks & Regards, Pritesh Shah Which I would guess the OP woul ...Show All

• Windows Forms dataview count doesn't shows properly.

  Hi I used dataview for a subset of rows , from a datatable. In that subset, there will be zero quantity and non zero quantity rows . and there may situation to move quantity value  from one row to another row.(may be quantity can be moved from an existing row to a newly added row). after that non zero quantity rows has to be deleted. the dataview.item(i).delete works fine for, if I have more than two rows(either non zero or zero). The Problem is if I have Only one zero quantity row and another non zero quantity(newly created. quantity is transferred from that zero quantity to this new row). If I made attempt to delete that zero quantity rows. it deletes both  row.(ie., the dataview.count shows 0 inste ...Show All

• Windows Forms Can c# perform a CTRL+V

  Hi all How can i get my program to perform a CTRL+V. (paste from clipboard) Thanks. Lars The following code gets the name if the active control is a text box.By comparing the name we can determeine which text box Control cnt = this .ActiveControl; if (cnt is TextBox ) { string name = cnt.Name; } ...Show All

• Visual Basic VB .Net Express ? (not VB 2005)

  Is there or was there an express version of VB .Net (2003) available for download. My work PC is stuck at XP SP1 and VB 2005 requires SP2. Stuck That's odd: as a developer, I'm sure you could download SP2. But to answer your question, no. ...Show All

• Software Development for Windows Vista TransactionScopeActivity in WF

  Okay, is it just me, or the implementation of TransactionScopeActivity really realy sucks. Here are the specific downsides - a) A rollback, or any exception for that matter, will cause the entire workflow to come crumbling down to it's knees. In other words, the only way it is really usable, if you always get a commit (get serious). C'mon MSFT, how about a Try Catch Finally Activity b) You always get MSDTC/Distributed Tx, EVEN IF you are working with Voltaile RMs. c) There is something not right about suspending an activity, and then compensating already run transactions on it 3 years later (maybe it's just my discomfort). d) You can't use the activity without having a persistence service in place first. I can't seem to understand t ...Show All

• Visual Studio Express Editions PC - MAC

  A friend of mine tried to download my games from my website but it wont work. I think it is because he has a MAC and I use a PC. It wouldn't even work when I took the files over to his house on a flash drive! I think this is a big problem and I would like to know if there is a way to publish your programs for use on a MAC instead of a PC. Thanks! CrazyEngineerKid I take it that you mean that your published games are VB based games that were published with ClickOnce If that is the case... your friend is kind of SOL so long as he’s running the Mac Operating System as any app you build in VB.NET Express will require the 2.0 .NET Framework... something that is only available on Windows PC’s today. ...Show All

• Visual Studio Problem with window persistance / placement

  I am creating a few windows for my addin with the EnvDTE80. Windows2. wins2obj.CreateToolWindow2() method during the OnConnection of my addin. The issue I have been having is that these windows are not remebering there position when the user closes/reopens the IDE. Most of the time they are marked "Dockable" and they end up undocked above the location that they had been placed in during the previous session. What are the steps I need to take in order to make sure these windows persist there placement/dock-state. Do I need to dispose of them every time the addin disconects Are there any properties that I need to set THis is a very frustrating bug! thanks for your time Russ In order for your tool wind ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectDraw Deprication

  What exactly do Microsoft mean by depricating DirectDraw Do they mean DirectDraw will be completely removed in the next DirectX release If so, what are the alternatives Direct Draw has been depriciated for a long time now... at least 3 years, this means that there will be no more work done on it and in the future it will be removed. I do not know exactly when this is going to happen, but if you have production code you should start to move it over. All of the 2d functions can be done under the directX 3D systems, it will just take a little bit of learning to move your code over. If you are using Managed Code you should have a look at XNA ( http://msdn.com/xna ) as the 2d functions are just as simple as the old directdraw syste ...Show All

• Visual Studio 2008 (Pre-release) Odd aliasing effects with Interactive3DDecorator

  I've been experimenting with Interactive3DDecorator ( https://blogs.msdn.com/wpf3d/archive/2006/12/12/interacting-with-2d-on-3d-in-wpf.aspx ). Truly stupendously amazing. Somebody needs to give that guy a medal! An amazing innovation that has the potential to seriously change the rules of the game, I think. The basic plot summary, for those who haven't seen it yet: fully interactive XAML content rendered on 3D surfaces. However... I've noticed that I seem to get aliased edges along the edges of some content but not others. Text is exceptionally crisp and clean; the interior of controls is good too. But I seem to get aliasing along the outside edges of controls when surfaces are rotated in 3D. The inside edge of the lines along the ed ...Show All

• SQL Server Use an equivalent of ROW_NUMBER() in SSIS package

  Hi, I would like to use an equivalent of ROW_NUMBER() T-SQL function in a SSIS package. I could create a temporary table and use a SQL request with ROW_NUMBER() function but I would like to avoid that and generate this column in the dataflow. Is there an easy way to do that Thanks, Arnaud Gervais. Thanks Darren But I have a lot of deployment constraints and I can't use an adding component in my project. I would like to have an easy way to do that with transformation or script tasks in my package. Do you have another solution Arnaud. ...Show All

• Visual C# Sorting times stored in strings...

  This might seem trivial, but I'm trying to sort some data structures based on times, they are stored in military time in a string like: 2:02,2:13,2:34 However when I sort based on string compareto method it orders: 2:13, 2:34, 2:02 Now I guess I could always remove the : and then sort by integer's, but is there another way to do this easily ...Show All

• SQL Server snowflake dimension - Role-Playing table

  I have a main dim table which references some other table tree times by foreign keys (defined in the DSV), but i do not find a possibility to create the Attributes three times with each foreign key. Is role playing only possible with complete dimensions and not with tables Is it by design not possible to use a single table multiple times in a snowflake dimension Is the only workaround a named query LG, HANNES ...Show All

• Architecture Share Outlook Calendar across 2 home computers

  Is there such a thing as a simple question I have two home computers running Windows XP Pro SP2 linked via a hub for file sharing. Both are running an independant version of Outlook 2003. We would like to have a family calendar that we both share and are able to view and update. We are not running Exchange. Is there any way for this to be setup Any help gratefully received. Eddie There is no way to share a calander as outlook uses pst files to store the entire info. A pst file can only be open by one instance of Outlook at a time. There are lot of third party software that u can find on the net that lets u do the same but from outlook there is no way of sharing a pst file b/w 2 computers. Check ...Show All