sax0n's Q&A profile

• SQL Server Nested set show leaves of parent

  Hello, I have the following code which will show all bottom level leaf nodes of the hierachy: SELECT name FROM tree WHERE rgt = lft + 1; I'd like to be able to filter results by a node. For example in a tree such as: Products ReleaseProduct Release1 Release build 1 Release build 2 Release 2 Release 2 build 1 Release 2 build 2 Build Product Build 1 Build 2 If Build 2 is chosen (any node with no children) I'd like to just show the Buuild 2, if ReleaseProduct is chosen Release build 1, Release build 2, Release 2 build 1 and Release 2 build 2 will be shown and if BuildProduct is chosen I'd like to display Build 1, Build 2. I understand the prinicipals but my SQ ...Show All

• SQL Server COnfiguring Number of records per page?

  Is there a way I can specify how many records per page should be displayed > This is a very basic functionality that needs to go in the deployment at any cost for us ...any ideas. thanks hi there. i encountered the same problem, and i tired doing what you said, applying it to a table. however, it does the same thing. it only displays the first record out of 20 ...Show All

• Windows Forms Where should I put the global variables?

  Hi all, First step, I created a simple "Windows Form" Form1 project. There is Form1.h, and I have many functions like click(), paint(), buttom_down()...in it. How to pass the variables between these functions Should I use global variables or they are not recommanded For example: The program tries to get the screen size and pass into image display function I will have scr_width, scr_height, img_src_width, img_src_height, img_scr_width, img_scr_height, Bitmap^ img... What is the good way to set up them And the second step will be, I separate the buttoms and display area, should I use two Forms If so, how do I pass these variables between so many functions in two Forms Thanks! ...Show All

• Visual Studio Tools for Office RSS feed in Outlook

  How can I see if a MailItem is a RSS item using the object model // Johan Yeah, I'm having great fun. As you saw on my post on Outlook Code I hade to write an addin in VB6 for a client. Going back to VB6 after doing .net since the first beta really sucked. I just had to do something not so 1997 to wash away that awful VB6-smell from my fingers. I'll look in to Outlook Spy! Thanks for the tip and all your help! Btw. This is probably super simple, but how do I get hold of the currently selected item (mailitem, postitem or what ever) Is there something like the Selection-property in Word and Excel ...Show All

• Visual C++ C1001 INTERNAL COMPILER ERROR when using boost/random library

  Hi all, I am attemping to use VC++ v6.0 with boost/random library 1.33.1 for my Monte Carlo simulation but I am running into "C1001 INTERNAL COMPILER ERROR": MonteCarlo.cpp y:\fsf\proj\boost\1.33.1\common\include\boost\random\uniform_01.hpp(29) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 1794) Please choose the Technical Support command on the Visual C++ Help menu, or open the Technical Support help file for more information Error executing cl.exe. This is the uniform_01.hpp file (I highlighted line 29 in red): #ifndef BOOST_RANDOM_UNIFORM_01_HPP #define BOOST_RANDOM_UNIFORM_01_HPP #include <iostream> #include <boost/config.hpp> #include <boost/limit ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Missile Command - XNA Remake

  Max Damage Studios is now making its release of its Missile Command XNA remake public. You can go directly to our downloads page to grab it. This project was mostly a proof of concept written in a very short, around 10 hours, amount of development time. We made use of a few of the DirectX SDK Tools such as XAct to get the final result. All audio work was done in our studio. There are only 11 levels in version 1.0 currently, but perhaps someday we shall extend that and produce another version. But we are moving on to our next project for now. I can't edit the above post because the forum is being strange...but here's the correct linkage for the sound pack: Max Damage Studios - Audio Page ...Show All

• .NET Development How good is ADO.NET vNext CTP now?

  Hi to all, Some years ago I have made some experiences with ‘ADO.NET vNext CTP’ predecessor ObjectSpaces. Some while ago I also made my experiences with an O/R mapper (EntityBroker) from THONA Software & Consulting Ltd.. No I will give ‘ADO.NET vNext CTP’ a chance. How good is Microsoft now Is ‘ADO.NET vNext CTP’ better than ObjectSpaces And when YES which changes Microsoft has done Use anyone from you ‘ADO.NET vNext CTP’ Productive J Regards, cyberjoe ...Show All

• Visual Studio Express Editions Getting the date from Datetimepicker issue

  I have a form that has a DateTimePicker control on it. The user can select a date and this date is saved to the database when the form opens. I am using the followng code to save it to the DB: anyRow( "ContractListStartDate" ) = ContractListStartDateDateTimePicker.Value When the form is reopened the correct date is displayed in the control. SO everything seems to work fine. However if aI put a line of code in such as below: MsgBox(ContractListStartDateDateTimePicker.Value) 0 is displayed. Why is this. What I am ultimately trying to do is find the number of days between today and the selected date, but I always get 0. It seems when I read the dates from the DateTime Picker textbox I am always reading zero even though the textbox shows t ...Show All

• .NET Development Future XSLT/XPath features in .NET Framework

  In effort to prioritize our goals we composed the list of random features each of them may add value to set of XSLT tools offered from Microsoft.   1.        XSLTc (Compiler for XSLT stylesheets, that generates .NET assemblies) 2.        Performance improvements in the XslCompiledTransform 3.        Compilation XSLT to JScript (like AjaXslt) 4.        Compilation XSLT to C++   5.        XSLT 2.0 in the XslCompiledTransform 6.        XSLT 2.0 in the MSXML 7.        XPath 2.0 ...Show All

• SQL Server Programmability of parameter bar(layout/items)?

  Hi all, does anybody of you know how to code and customize the parameter bar of the SSRS reports I know about putting code behind expressions but how is it with parameters How is it possible to... 1. define the layout of the parameter bar and the positions of the parameter items 2. make the parameter items user-specific Is it possible to define a report with the report designer and hand over data (parameters) by code-behind or a referenced assembly Thanks a lot for any help Best Regards Marc Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer). If the parameter selection needs to be as dynamic as you describe, the best ...Show All

• Visual Studio Tools for Office Word MAil Merge Automation

  I am trying to implement mail merge into our application using .NET as mentioned by c_shah. But the problem is, I am not sure what format the word document needs to be in. (ie., how to create mydoc.dot that is used in that example) I tried word's inbuilt mail merge functionality to create a template document that can be used from our application. But every time I try to do that, word requires me to enter the datafile. If I enter the datafile with dummy data, it immediately substitutes the data in its appropriate location. How do I save it as a template with no data in it so that I can later use it from my code to do mail merge Your help is greatly appreciated.   etrast wrote: I have a ...Show All

• Visual C# DLL Returns object {string[]}

  Greetings, Calling a DLL method that returns an array of strings, but I can't cast to string[]; object o = myMethod(); string[] s = (string[])o;    //generates "Unable to cast object of type 'System.String[\*]' to type 'System.String[]'. (I had to put the \* in, without the \, it treats it as a different [\*] as a different char) The Autos window shows the data properly; [1] "String1" [2] "String2" Hi, It might be problem with the dll function myMethod() return value, it seems. Can u please send me the dll and .h file to 'gopi_ch@googley.com' , so that i can test, if the problem is not solved still. Thanx, Ch.T.Gopi Kumar. ...Show All

• Visual Studio Express Editions Move It

  How do I make a button on my form to be always 10 pixels from the left side of the form and 10 up from the bottom, when each time the form loads it resizes to match a picture in a picture box Thanks Nobugz/Dman, Niether solution worked, but I think it's my fault ,the problem is that I want the form to be the same size as the picture box (which when the the form loads can be various sizes) what I need is to transfer the width/height of the new image which is decided in form one, to be transfered to form two, but this is not happening,why Me.Width = frmImage.txtWidth.Text Me.Height = frmImage.txtHeight.Height Me.btnAccept.Anchor = (AnchorStyles.Left Or AnchorStyles.Bottom) ...Show All

• Visual Studio Express Editions TabControl Help...

  Hi everyone, some of you have helped me with opening a new form NewEvent neform = new NewEvent(); neform.Show(); which i understand just fine but i was wondering how do i open up and new form with the tab control on it, and make it so that when it open it will open straight to that tab instead of click on the tab for example say you have 2 tabs "tab1=Meeting, tab2= Things to do". and then you go to File>New>Meeting or File>New>Things to do, and it will go straight to that tab, also while im here is it possible to open a file for example "Help>How To..." and it will open a pdf file ( HowTo.pdf ) just wondering so it will save me having to ask another question. thanks for anyhelp ...Show All

• SQL Server Msg 4712: cannot truncate table

  Hello, I am running SQL Server 2005 SP1. Whenever I issue a 'truncate' query to the DB engine it fails if the table to be modified is currently referenced by a foreign key constraint. A code snippet (T-SQL) that demonstrates the problem is beneath. Does anybody know a fix-it Thanks in advance, Intenion Hi, Maybe a documentation update would be welcome for the 'truncate table' topic in Books Online. Thank you for your answer, Intenion. ...Show All