Johan J's Q&A profile

• Visual Studio 2008 (Pre-release) Set a "flags" enum value in XAML

  Does anyone happen to know of a syntax for setting multiple enum values to a property in XAML This would be used in a situation where the enum is a "flags" enum and more than one value needs to be set to the property. This isn't actually a XAML feature - rather, it's a feature of enums in the CLR, and since we simply call the default TypeConverter, we get it for free: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconparsingotherstrings.asp Enumeration You can use the static Parse method to initialize a Boolean type to the value of a string. This method accepts the enumeration type you are parsing, the string to parse, and an optional Boolean flag indicating whether or not the parse ...Show All

• SQL Server MDX Query syntax

  I would like to use the value of a member property in the where portion of an MDX queiry. It is a boolean. I have tried : select {[Measures].[Avg CPA],[Measures].[Click Conv Rate],[Measures].[App Conv Rate]} on columns, NonEmptyCrossJoin([Strategy].members, ( NonEmptyCrossJoin([JobIndustry].members, [Media].members )))on rows from ChartReportingCube Where [CampaignID].Properties("Campaign Benchmark Flag") The actual value in the property I want: Campaign Benchmark Flag is -1 Is it possible to reference member properties in the where clause If so, what is the syntax Hi. First thing I notice in your query is the missing left parentheses in the where clause. Your statement has ...Show All

• .NET Development download a file from http -file type

  Is there any limition on the file type that can be download from http My program can download a doc, pdf, txt, html file from http. However, for some extension such as dwg, it will return a 404 error(file not found). Anybody know why And what I should use to download other type files. Ying ...Show All

• .NET Development SqlReader not working

  I am nearly there, on my thing. Now to get the result For Some reason If i type System.Data.SqlClinet.SqlReader rdr = cmd.ExecuteReader; I get can error saying The type or namespcae name 'SqlReader' does not exists in the namespace 'Sytstem.Data.SqlClinet' (are you missing an assembly reference) I have the following at the top using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; Am I missing something Is it a config erorr The main question, How do I resolve this ALSO.... The query I am running is to select the row, where th ...Show All

• SQL Server Execute phase Memory Error => dtsx finished: Canceled

  Hi, I have a data flow component that retrieves records from a table.  There is about 3 million records.  I do sorts on the records, then use a merge join transformation to join that sorted data with the dimension data.  However, when I pump 10,000 records through this transformation it works fine. When I try 3 million I get this error: DTS.Pipeline: Thread "WorkThread1" has exited with error code 0x8007000E.  I think this is a memory error. I have 1000 MB of memory 30 GB of hard drive space.  I am also running this on a virtual server. Option 1: Don't use merge join transformations and use Lookup's instead Option 2: Stop using virtual server and put it on a real box and and beef up the memory and hard drive. ...Show All

• Windows Forms DataBinding to ArrayList

  Hello, I have a win forms with a treeview and i want to data bind it to an array list on a diffrent class. How do i do it Sorry the windows forms treeview does not support data binding. Maybe this thread will help. ...Show All

• SQL Server SYSAdmin users do not have permission to see records in a view?

  We have a third party application and wish to create a report based upon a view. The strange thing is logged in to the server as a SQL SYSAdmin account, we cannot view the data via the view. SQL Admin accounts are setup correctly and there is nothing different on this particular server. No errors are returned just a blank view with no records. Could this be a permissions problem or orphaned schemas in that particular database I thought SYSAdmin could view and do just about anything and the people who use this particular database would not have the know how on denying permission to the SYSAdmin role. Thanks N As Laurentiu mentioned, it seems like you are filtering the results with the predicate ...Show All

• Windows Forms UserControl with Panel as constituent control

  Hi, I have created a UserControl with a Panel as a constituent control. I require the ability to, in the IDE, drag drop controls into the Panel within the UserControl. How do I go about coding that functionality Many thanks http://blogs.msdn.com/subhagpo/archive/2005/03/21/399782.aspx ...Show All

• SQL Server How to use variables for server connections

  Hello, Today is day two of using SSIS and having some issues adjusting. In DTS I would simply populate my global variables via an Active X step or pass them in at the job line. I am having a hard time being able to do either or in SSIS. Really all I want to be able to do is pass in a server name to the Connection of an execute SQL task from a scheduled job line. Same goes for any variable really ... how do I pass them in, and how do I assign them to specific areas of a task Thanks! Yeah that is more of what I am looking for ... so I guess that brings me to my next question. How do I do that For example ... I have a variable called DBList. I want this variable to have database names passed in, w ...Show All

• Visual Studio Integration between Visual SourceSafe 2005 & Microsoft SQL Server 2005

  Hi; I would like to know if i can Configure VSS 2005 to work with Microsoft SQL Server 2005 Best regards, Bryan, Thanks for your post. So the issue in this thread was configuring VSS to use SQL Server 2005 as the storage mechanism for VSS. This is not the same issue that you pose where you want to use VSS as the source control mechanism for SQL Server Managment Studio 2005. You may well be able to do that but that is beyond my expertise. I would recommend that you post this question on how to do this or if it is possible based on the documentation that you have read in the forum for SQL Server which is: MSDN Forums SQL Server SQL Server Tools General Hope that helps, Karl Hilsmann Visual Studio Proj ...Show All

• Visual Studio Visual studio does not respond

  Hi, When I try to debug my project, visual studio stops responding with a message " Visual Studio is busy and is waiting for an internal operation to complete" This happens only when I am debugging TreeView_AfterSelect event. Can anyone suggest why this may be happening Thanks! Language -- C#. It is a windows application and I am using Visual Studio 2005 OS version -- Microsoft XP Professional version 2002 service pack 2 ...Show All

• Windows Search Technologies WDS 3.0 RTW fails to start

  Hello, Install of WDS 3.0 RTW in WinXP ended OK. As it did not start automatically, I started it manually, and found that the Windows Search service is not running. Windows Applications Log reveals: The Windows Search Service has failed to created the new system catalog. Internal error <7,0x80070002>. Any hints Marek Hello Paul, I just want you to know that reverting back to WDS 2.6.5 works OK. Should you need any more input, please put a post here. Regards, Marek ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Framework proposal and sample code - GameComponents with component-specific "update frequencies"

  Please see https://connect.microsoft.com/feedback/ViewFeedback.aspx FeedbackID=195728&SiteID=226 and give your feedback! Currently the GameComponent class has no mechanisms for having components with a "lower priority" that are not updated as frequently. Examples could include a component that manages game resources, purging unused ones similar to a garbage collector on a less-frequent interval. I've written a rough, prototype implementation. It should be usable right now with minor modifications, provided you use your own class that inherits from GameComponent. public class IntervalGameComponent {     private int updateFrequency = 0;     private TimeSpan componentElapsed;     [Default ...Show All

• SQL Server Flat file return NULL value

  Hi, I am facing problem while extracting data from flat file through query. It return NULL value for the column EmpID for the 3rd row ('x') i have a flat file for eg: EmpID, EmpName, ParentEmpID 1,test1,10 2,test2,13 x,text3,15 Below mentioned two type of query I tried 1) SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\','select * from test.txt') 2) SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\;Extended Properties="text;FMT=Delimited"')...test#txt Pls help me out this issue Hi Gurpreet, thanks a lot. my situation is like i don't know the colname (because flat file is generating daily), ...Show All

• .NET Development How can I parse an SQL statement into a canonical form ?

  Is there any class available (either in the framework or external and in that case preferably open source) that can be used to test whether two sql statements are equivalent or not (equivalent regarding irrelevant white space, parentheses, and upper/lowercase for keywords) Basically, what I would like to do is to find a class (below called SqlParser)that I can use like this: string sql1 = SqlParser.getSqlStatementInCanonicalForm("SELECT mycol1 FROM mytable where mycol2=1 and mycol3='abc'"); string sql2 = SqlParser.getSqlStatementInCanonicalForm(" sEleCT mycol1 frOM mytable where ( mycol2 = 1 ) and ( mycol3 = 'abc' ) "); NUnit.Framework.Assert.AreEqual(sql1, sql2); / Tomas Adamus wrote ...Show All