dbcuser's Q&A profile
SQL Server Filtering on a date comparison in a dimension table
I'm trying to create a Customer Count measure. Each customer has a open date and a close date in the Customer dimension, so I need to filter the count based on this date range. For each time period the count should include customers where Open Date is <= the current time period and CloseDate >= the current time period. The measure needs to work for any time granularity (years, months, etc.). I think this query is close but it is returning a 0 count for each month: With Member [Measures].[Customer Count] As Count ( Exists ( [Customers].[Customer ID].Members, Filter ( [Customers].[Customer ID].[Customer ID].Members, [Customers].[Customer Open Date].CurrentMember.MemberValue <= ...Show All
Visual Studio Express Editions pass HTML string into XML collection for use
hi, i am new to c# xml. i wanted to try this. i have a string that contains HTML code. e.g. Hi, Load it in the XmlDocument class: XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml(System.IO.File.OpenText("C:\text1.txt").ReadToEnd()); cheers, Paul June A. Domag ...Show All
.NET Development Error message when running application
I built a program with VB.net (via VS.net 2005) and I've created the setup via InstallSheild 12. However, after the installation is completed (successfully no less...) I get the following error message: CS Importation has encountered a problem and needs to to close. We are sorry for the inconvenience. The error signiture is as follow: EventType : clr20r3 P1 : cs importation.exe P2 : 1.2.3.4 P3 : 45e6f1ab P4 : cs importation P5 : 1.2.3.4 P6 : 45e6f1ab P7 : 1e P8 : 1a P9 : pszqoadhx1u5zahbhohghldgiy4qixhx I've been looking for days through different forums for a solution, but I can't find any. I don't even get the P10 signature ike most people do. Can someone Please help me!! hmmm.... I've tried that once a ...Show All
Audio and Video Development XPath Error
I'm getting an error when using the xpath expression below. <par begin="id('BTN_MENU')[state:actioned()=true()] and id('MENU')[style:x()='-450px']" I want to evaluate the values of two different elements, but cannot get it working. Any help appreciated. Try this: <par begin="(id('BTN_MENU')[state:actioned()=1] and id('MENU')[style:x()='-450px'])" ...Show All
.NET Development What components end up in the compiled EXE ?
If I have a program that references 3 dll's that I made, is there any indication of those DLL's in the final, single, EXE after compilation I want to be able to find out what components make up a RUNNING exe program, but if all that information disappears on compilation, I won't be able to find out. Any ideas The referenced DLLs are not merged with the exe regardless of the namespace. If you want to construct a single .exe containing all referenced assemblies then you can use ILMERGE from Microsoft to do it. Even using ILMERGE you will still only create a .exe with all your own DLLs in it, it will still refer to other DLLs that are part of the BCL. ...Show All
Windows Live Developer Forums Dynamically load API JS file kills IE6
I'm trying to load the veapi.ashx file dynamically, but I'm having a big problem with IE6, please test the following code out in IE6, you will need to clean your cookies and cache, to do that in IE6 you need to go to Tools --> Internet Options -->Delete Cookies & Delete Files.. and close all your IE, and start IE6 with these code.. <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script> var map=null; function include_js(file) { var html_doc = document.getElementsByTagName('head').item(0); var js = document.createElement('script'); js.setAttribute('type', 'text/javascript'); js.setAttribute('src', file); html_doc.appendChild(js); js.onre ...Show All
.NET Development SslStream and AuthenticateAsServer
I'm trying to create authenticated SslStreams, with a certificate created with OpenSSL (which is read from file). I can read the certificate without a problem from within C#. The problem is my code hangs whenever I call AuthenticateAsStream(). My question is, I'm creating (and signing) the x509 certificates myself. Will this cause problems with AuthenticateAsStream What exactly does AuthenticateAsServer do Thanks, Josh I realised that I wasn't matching the AuthenticateAsServer() on the server side with an AuthenticateAsClient() on the client side. The problem I get now is the following exception: System.NotSupportedException was caught Message="The server mode SSL must use a certificate with the ass ...Show All
Windows Forms BindingSource.AddNew resulting in InvalidCastException
I have a BindingSource component bound to a strongly-typed DataSet. If I call the AddNew() method of the BindingSource to add a new row, I get an InvalidCastException : Unable to cast object of type 'System.DBNull' to type 'System.String'. I've set the NullValue property of all the columns in my DataSet to '(Empty)' but when adding a new row, DBNull is still returned. I could fix this by changing each column's DefaultValue property to "", but I don't want to do this because the Access database which stores the data does not allow zero-length strings, I want the default value to be DBNull but to appear as an empty string when databound. What do I need to do to achieve this ...Show All
Windows Forms Null Dates in DataViewGrid - Solved
I am connecting to a datasource using Ole Db. The returned dataset has date values which are null. The DataGridView shows these as the date: 12/30/1899. Is there some way to make the row show an empty date If not, is there some other workaround for this It just looks odd to users to have 12/30/1899 showing up in many places. Thanks in advance, Greg I found a workaround for this as follows: (If anyone knows a better way, please let me know.) private void grdNAF_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewColumn oCol = grdNAF.Columns[e.ColumnIndex]; DateTime oDT1; DateTime oDT2; if (oCol.Name == "colPaymentsEndDate& ...Show All
Visual Studio Which Files in Source Code Control
I am using SVN for my source code control as not everyone where I work has access to VSS. The benefits of VSS that I found was that it automatically chose which files to include under the source control. I am using TortoiseSVN and recently Ankh SVN as it is an addin. However, I can't work out which files should be versioned. Just like this guy here . When I open my VB solution I see the following: Test - My Project - AssemblyInfo.vb - modMain.vb - modWord.vb - frmMain.vb Now it obvious that the last 3 need to under code control. However, even though I have added Test.vbproj and Test.sln to the SCC, the top three don't appear to be under control. Which files should you put under control What about the extra directories that get created ...Show All
Visual Studio Express Editions Double Buffering in Express VC++
Hi! I've got problems with dubbel buffering in Express VC++. It apperas that the designers are turning off the double buffer property of a windows form during compiling. The 2003 version was enabling users to set styles. Now the compiler is giving error messages such "the canditate method is not reachable" or something like that, if I want to set the styles manually. Is this a bug or is the double buffering temporarily turned off Any idea Regards Modeller. Peter Ritchie, I would like to thank you very much for bringing the method call into my attention. I did not pay attention that double buffering is a protected member until I read your second post. It will take sometime to get u ...Show All
Visual Studio 2008 (Pre-release) Deserializing A SAML Token Received From An STS?
Having received an RST message, an STS serializes a SAML token into the body of the RSTR message returned to the client. In that the RST and RSTR support was pulled from WCF, it would appear that the SAML token need be deserialized on the client side for caching and reuse. Documentation concerning the SamlSerializer, SecurityTokenResolver, WSSecurityTokenSerializer and SecurityContextSecurityTokenResolver classes is sparse, however, and attempts to do so consistenty result in: "The SecurityKeyIdentifier that was found in the SamlSubject cannot be resolved to a SecurityToken. The SecurityTokenResolver must contain a SecurityToken that the SecurityKeyIdentifier resolves to." Little seems to have been written concerning th ...Show All
.NET Development Problem generating Convert.ToString + dataRow using codeDom
Hi, Yes struggling with the codeDom but getting there, Could somebody help with these ones Person.Name = Convert.ToString(myRow["Name"]); THanks a lot as usual You're a VB junkie but your code is in C#. I'll assume you want C# code. Here is the code I'd use. //Prologue CodeCompileUnit unit = new CodeCompileUnit (); CodeNamespace ns = new CodeNamespace ( "Testing" ); unit.Namespaces.Add(ns); CodeTypeDeclaration declClass = new CodeTypeDeclaration ( "MyClass" ); declClass.IsClass = true ; ns.Types.Add(declClass); CodeMemberMethod meth = new CodeMemberMethod (); meth.Name = "Foo" ; declClass.Members.Add(meth); // Pre-existing variables Cod ...Show All
Visual Studio Express Editions Registration Key
How or where do I get the registration key Thanks, After you download and install the Express product you can choose "Help->Register Product" which will launch a webpage for you to receive your registration key. Let me know if this helps. ...Show All
Visual Basic Help - Shared MDE - Exclusive Access message box
Dear firends, I did some research and found several articles about this issue but none helped to resolve. I have a MS Access 2003 database having 3 files: 1. MDB - Back End file (contains: data) 2. MDE - Front End file (contains: forms, reports, queries, VBA) 3. MDW - Security file (contains: users and groups) All 3 files are located on a server. There is a shortcut placed on user's desktop. The shortcut points to MDE file and includes /wrkgrp for the MDW file. All the users are in same custom group in MDW file having Admin permissions. When the first user logs in, everything is fine. Then any consecutive users logs in, they get message box saying: "You do not have exlusive access to the database at this time. If you proceed ...Show All