XpyXt's Q&A profile

• SQL Server function naming and execution

  Hi, I am converting a database from Oracle to SQL-Server 2005 and in that context I needed to implement a function in the database. My database default uses the dbo schema and the function is there too. I define a function called "Translate" and wanted to use it like this : SELECT translate(Phonenumber, '0123456789 ()+-', '0123456789') as Phonenumber FROM Customer but what pussled my was that in order to make this work I had to prefix the translate method with "dbo." like this : SELECT dbo.translate(Phonenumber, '0123456789 ()+-', '0123456789') as Phonenumber FROM Customer as all "objects" I'm using resides in the dbo schema - why must I prefiks only the function and not the table ...Show All

• Visual Studio Express Editions linking

  This will probably sound like a stupid question, but how do I link library files to a project I looked in the Visual C++ Express Edition help files, but they didn't really help me much. thanks i mean that that method will only work on microsoft compilers, pragmas by thier very nature are compiler specific, check the visual studio docs topic on #pragma for more in depth details. ...Show All

• Visual Studio 2008 (Pre-release) How To: Attach event handler to element in DataTemplate?

  This question/problem is a little bit esoteric, but hopefully someone has seen it before... I need to attach an event handler to the Loaded event of Image elements within a DataTemplate. The Loaded event handling method is in a utility class, so I can't use XAML to attach the handler. In a Window's Loaded event handling method I call this method in the utility class : FrameworkElementFactory factory = listBox.ItemTemplate.VisualTree; while ( factory != null ) { if ( factory.Type == typeof ( Image ) ) { factory.AddHandler( Image .LoadedEvent, new RoutedEventHandler ( OnImageLoaded ) ); break ; } factory = factory.FirstChild; } There are two problems, one is not too bad (just odd) and t ...Show All

• SQL Server Selecting first non-empty time dimension member and previous period

  Even though this works, I feel guilty for using hacky MDX. A book I have recommends using Generate to compute this, but I couldn't seem to get it to work - SELECT NON EMPTY { [Measures].[Page Views] } ON ROWS, { TAIL(FILTER(([Time].[Date].[Date]), NOT ISEMPTY([Measures].[Page Views])), 1), HEAD(TAIL(FILTER(([Time].[Date].[Date]), NOT ISEMPTY([Measures].[Page Views])), 8),1) } on COLUMNS from [ZCube] Is there a better (and presumably more performant) way to do this Hello. Is this not possible  to solve with constructing a second named set pointing to the last day with data Call the Named Set  RecentDate Tail(Filter([Time].[Time_Calenda r].[ Day ]. Members,(Time.[Time_Calendar].Currentmember ...Show All

• Windows Forms "Foreign" msi files in a Setup project

  Hi there: Quick question: my application uses SMO, and I need to install that on the user's machine. I got the download from Microsoft in the form of a .msi file (the Microsoft SQL Server 2005 Management Objects Collection download from http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en ) . Is there any way for me to incorporate that msi file into my setup project I tried going through the prerequisites (I already have .Net 2.0 and Sql Server Express in there), but it is not dynamic enough to allow that. I could try and package the SMO assemblies one by one (the dlls were already added as dependencies), I'm just not sure how to force them to be installed in the correc ...Show All

• Visual Basic DirectoryServices (Active Directory)

  I've got an existing program that retrieves a list of computer names on the domain via Active Directory. I need to update the program to retrieve computer descriptions from Active Directory along with computer names. I can't figure this one out and after googling high and low I've found no solutions. Any help would be greatly appreciated. Here is a code snippet demonstrating the retrieval computer names: Dim myActiveDir As New DirectoryServices.DirectoryEntry("LDAP://microsoft") Dim mySearcher As New DirectoryServices.DirectorySearcher(myActiveDir) Dim mySearchResult As DirectoryServices.SearchResult Dim alDomain As New ArrayList mySearcher.Filter = ("(objectClass=computer)") For Each mySearchResult In ...Show All

• .NET Development Best way to localized applications in .NET 2.0

  Hi, I would like to ask you what is the best way to localize applications in .NET 2.0 and how Microsoft do it in Vista Wojtek There isn't a high percentage of .NET applications included with Vista. Generally, with Visual Studio, you set a Form's Localizable property to true and you can then add text for each language you want to support in the resources. The Designer generated code will get the text from the resources with a ResourceManager object and will get the text that matches the users currently set culture or the text marked as the invariant. When formatting/parsing data you can either use the default settings (which is to accept the user's culture settings) or override that by p ...Show All

• .NET Development Parsing IPAdress

  HI, I get an "invalid IPAdress exception" when I try to parse IPAddress entered in a textbox. IPAddress addr = IPAddress.Parse(text1.ToString()); But my program works fine when I parse IPAddress as follows. IPAddress addr = IPAddress.Parse("128.250.23.155"); Can anyone tell me why this is happening and how I can fix this problem Thanks in advance. hello, textbox.Tostring() is wrong because it return its type rather than Value by defualt. You need to write this : IPAddress address = IPAddress.Parse(textBox1.Text); It'll work fine. Cheers ;-) ...Show All

• Visual FoxPro VFP 6 - Auto-numbering with the characters

  I'm trying to write the code to get the desired result: - CN060901, CN060902, etc... Am lost with the existing code (as below) and wld appreicate if you help to correct my existing codes (highlighted brown front). CN060901 stands for:- 06 - Year 09 - Month 01 - Serial number (dn_no from the ".dfbnos" table) **dbfnos is the table name. **dn_no is the field name in the table (.dbfnos). It is the auto-numbering, starting from 01. . Anyway, the date format on the form is 28/09/2006. [CODE] if empty(thisform.pf.pg1.invno.value) select dbfnos goto 3 && Remarks: For Credit Note select dbfbcn seek TRIM('CN' + right(str(dtoc(df_date),4),2) + right("00"+alltrim(str(month(df_date))) ...Show All

• Visual Studio NDoc05 and namespaces in assemblies

  Hello, I find out that NDoc05 (it'd be best to use a free tool to generate my C# documentation) parses and produces documentation files for only the first namespace it founds in my assembly. Ex : myassembly.dll : - a.first - b.second I get documentation for only "a.first" namespace. Thanks for any feedback. I tried other tools like Natural Docs and Doxygen but they have their own flaws towards my tests :-( Barbara Have you tried Sandcastle ( http://www.microsoft.com/downloads/details.aspx FamilyId=E82EA71D-DA89-42EE-A715-696E3A4873B2&displaylang=en ) in conjunction with the help file builder ( http://www.codeplex.com/SHFB ) Both are free. The help file builde ...Show All

• SQL Server Dataset Results

  I have created adataset to make a drop down list for a parameter. As shown: SELECT distinct [Table] FROM [Database] The results i get back are A, B & C. What i am trying to do is show a result as a different word. i.e instead of displaying A is shows in drop down list as Apple, B shows Banana. etc. Can anyone help please. Thanks The parameter can use two columns of the returned dataset, one for the value column and one for the display column, getting this back from the query and binding it to the appropiate properties in the parameter setting should help. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• .NET Development tcplistener and winxp service

  i have a windows service that creates a tcplistener socket and waits for incoming connections. this service should allow connections before and after a user logs in and out, but it seems to not be working correctly. i keep getting this message, any ideas No connection could be made because the target machine actively refused it Aaron Sulwer wrote: private void ListenToServer() { EventLog .WriteEntry( "clientListener.ListenToServer" , "ListenToServer starting" ); IPAddress localhostAddress = Dns .GetHostEntry( Dns .GetHostName()).AddressList[0]; Int32 iPort = 63000; TcpListener tcpList = new TcpListener (local ...Show All

• Smart Device Development Button Changing to Picture - C#

  I am programming a game in C# using Visual Studios 2003 .Net Compact Framework. I would like to be able to either change a button to another color when clicked or if that is not possible change it to a picture and have the button disapear. Advice appreciated- Just create a custom button that shows images: http://msdn.microsoft.com/library/ url=/library/en-us/dnnetcomp/html/ImageButton.asp frame=true ...Show All

• Visual Studio Tools for Office I want know how many workbooks are open from a excel application,but i know only its process id

  Hi, iam having one application in which with the help of the excel process id provided by system.diagnostics i want to choose that paricular excel application and i want the no of workbooks ,or worksheets attached to it, Can anyone help on this issue Regards Prasad. Hmm, Generally, when Excel process starts up, it registers its Application object in the Running Object Table (ROT). Later, one can retrieve this object using Marshal.GetActiveObject("Excel.Application"), cast it to Excel.Application and use it to retrieve the desired information (e.g. to get the number of open workbooks you can use something like the code below object oxlApp = Marshal.GetActiveObject("Excel.Application" ...Show All

• SQL Server PERSISTED Column In View

  I have a view that calls a User Defined Function. I want to index this calculated column if possible, but trying to do so gives me an error saying that I have to mark the column PERSISTED. I see how it's possible to do this when creating tables with calculated columns, but is it possible to do this from within the view itself Thanks for the reply, Adam. Yes. I do have a clusterred index on the view already. Adding a non-clustered index on the calculated non-key column isn't working, though. It gives a message about the column: "Cannot create index or statistics '[Index Name]' on view '[View Name]' because key column '[Column Name I Want To Index]' is imprecise, computed and not persist ...Show All