Andre's's Q&A profile

• SQL Server Date Filtering vs Row placement misbehaviour

  I am using the classic Add Business Intelligence date dimension hierachy and getting correct results when I had my calendar hierachy on the rows expanded to the day level and my dimension calculations on the columns. The results were wrong when I moved the calendar hierachy to the filter area and selected one date. In particular, the [Date].[Date Calculations].[Current Member Name] = [Date].[Reporting Calendar].CurrentMember.Name shows that when you filter the Hierachy down to the day, the Current Member is always incorrectly showing the week (in every cell). It is correct when filtered to all other higher levels than date (week, month...). I have tested this on multiple date dimensions for some days now and it is very consistent. Al ...Show All

• Software Development for Windows Vista Can't install MicrosoftR Visual StudioR 2005 Extensions for WindowsR Workflow Foundation Release Candidate 2

  Hi, I downloaded MicrosoftR Visual StudioR 2005 Extensions for WindowsR Workflow Foundation Release Candidate 2 from Microsoft website ( http://www.microsoft.com/downloads/thankyou.aspx familyId=63A80A4B-BD27-4124-A2A5-61786ADB626E&displayLang=en&oRef=http%3a%2f%2fwf.netfx3.com%2fblogs%2fnews_and_announcements%2farchive%2f2006%2f06%2f23%2fJune-CTP-Available_2C00_-RC-Build-of-WF.aspx ) but when I open it, it starts Active Sync 4.1 installation! What's wrong with that Thanks If you have a setup.exe file in the same directory as the wf exe file, then the installer gets a little confused and starts that setup.exe. So after unzipping, it found the setup.exe for activesync and started t ...Show All

• Visual C# Group by time period which spans two dates!!! HELP

  Lets see if some of you RS Gurus can help me on this. I have a start_time column that returns the date and time. I have converted these out to return the date for one column and the time (24 hours) in another column. I have a report that I need to group by a 24 hour period that starts at 20:00(8pm) and should end again 24 hours later (20:00) 8pm. This should be my time period for each day. The problem is that when I group for each day it is returning the results for the day on a default 00:00 to 00:00 time period. I need to group for each day but I need that days time to be from 8pm to the following 8 pm. If someone could clue me in on this I would be forever greatful. I don't know how to get past the default times for the date groupin ...Show All

• .NET Development What is the List<OdbcParameter>.Enumerator?

  I'm having diffuculty with a memory leak that appears to be related to the System.Data.Odbc class. When the OdbcCommand class is disposed the List<OdbcParameter>.Enumerator classes are not being disposed. Using a memory profiler I can see undisposed instances of them continuing to increase through all the garbage collection cycles. Does anyone know how to get these to release with the other OdbcCommand resources What is the List<OdbcParameter>.Enumerator I'm using .NET 2.0 to connect to a MaxDB database and call a stored procedure via the ODBC data provider (System.Data.Odbc). Here is a piece of example code: OdbcConnection dbConn = new OdbcConnection(connStr); dbConn.Open(); for(int i=1001; i<2001; i++) { ...Show All

• Software Development for Windows Vista Slow startup times

  Hello, I have just installed WWF on my development system. I have noticed that the start/load time for an extremely simply workflow (ie-hello world) is slow. This isn't just the runtime of the application either.. Here is some pseudocode, main print 'in main' workflow.setup print 'wf setup' workflow.start workflow.waitforexit print 'done workflow' The application sits there for about 10 seconds before even entering main. For all intensive purposes please assume that my development machine has never been connected to the internet. Anybody have ideas why this could be happening This seems to be environment/system related. How does the performance compare with against a normal C# console application I can' ...Show All

• Visual C# HtmlDocument on Console

  I'm trying to use an HtmlDocument into a Console application, using an string with all the HTML code to build it. But seams that need a WebBrowser object to create it, and I can't create a WebBrowser object in my application because it's a console application. How can I solve this problem Thanks, TONI. why dont you just use a normal string and place html in it There is also no HtmlDocument property in the webbrowsercontrol but maybe the Document property you could still use the webbrowser control although I wouldnt recommend adding the control to the application since its of a different type of application but if you must, right click references and go to add reference and select Syste ...Show All

• SQL Server Can aggregate functions be used in a check-constraint or a computed-column?

  Hi, Can aggregate functions (e.g. Sum, Avg) be used in a check contraint or in a table's computed column Thanks! evn i dont think its possible...as they r the values that can be entered for a particular column , while aggregate function will need a group....still will check it out soon and confirm.. ...Show All

• Software Development for Windows Vista Modifying custom composite activities at design/runtime time inside of a workflow.

  If I create a composite activity that inherits from SequentialActivity and has a number of other activities added to it and drop this new activity on a workflow is it possible to modify it at design time. So if one of the sub-activities I dropped on my composite activity was a sequential activity can it get modified after it is dropped on to the workflow. Basically what I want is to be able to create custom activities with certain common flows but at some point I want to be able to put a place holder in that flow to allow someone reusing my custom activity to do something custom. 2nd question related to the first. Same situation but instead of a placeholder (i.e. sequential activity) inside of this custom activity I want to use an ...Show All

• Visual Studio Express Editions Saving and Opening files

  I want to save and open a file with a unique extentions. How do I do that are these files you have created you can open any file using the StreamReader and write to any file using the StreamWriter:   Dim theReader as new System.IO.StreamReader("C:\someFile.ext") Dim theContents as String = theReader.ReadToEnd() theReader.Close()   'To write:   Dim theWriter as new System.IO.StreamWriter("C:\somefile") theWriter.Write("hi") theWriter.Close()     there are various other methods also for these classes, check out each class, or visit the following link of achieving common tasks: http://msdn2.microsoft.com/en-us/library/ms404278.aspx   does this he ...Show All

• Architecture what's the best way to capture relating one table to many other tables

  Say I have four tables: 1. people 2. products 3. images each of which can be joined in a 1 to many relationship with a fourth table 4. notes I can add n notes to each row in any of the above tables. The options of which I am aware: a) have a separate notes table for each of the 3 tables (peoplenotes, productsnotes... etc.). b) create a join table for each relationship: peopletonotes (with a compound key of peopleid and noteid), etc. c) in the notes table create a generic foreignkey which along with a tabletype can tell you which is the right parent table notes table has: noteid, foreignkeyid, tabletype (which can be either: 'people', 'products' or 'images'), so you might have two rows in notes: noteid ...Show All

• Visual C++ Specify a DefaultValueAttribute for an enumerated type property

  How does one specify a DefaultValueAttribute for a property of an enumerated type None of the constructor for DefaultValueAttribute take a System::Enum as the type of its parameter. The compiler does let me specify an enumerated value for the enumerated type but it must treat this as a System::Object instead. Try creating a CLR Class Library, add a Component Class, then add your code above to the component class. Build the CLR Class Library. Finally double-click on the Component Class header file to open it in Design mode. What do you see Now go to your component class code for the DefaultValue attribute and instead of: [System::ComponentModel::DefaultValue(Type1)] change it to [System::ComponentModel: ...Show All

• .NET Development unable to find assembly

  I'm having the following setup: A client windows service, A server windows service, An automation (com interop) These are used to send a message from the client to the automation through the server service with .NET remoting. Sending a message class which has a property of type object in which an object resides that comes from a class in a separate library. Client and automation have the same reference to this library. Sending a message from the automation to the client works, the message will be serialized and deserialized. When trying to do the other way around, this results in an error saying "unable to find assembly" I've added the library to the GAC and still I get the same error. I'm rather clueless on this one. ...Show All

• Visual C# Why did I only get part of what I intend to get?

  No error was complained! The following program is to write a whole year's month,day,weekday in a MSSQL table. But somehow, for many times I have tried, but each time I got only part of what I intend to get: the whole year with 12 monthes, instead, I only got 3 or 4 months' content in the table. Can anybody tell me why calendar.dll using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using database; namespace calendar { public class calendar { private int _nian; //year private int _yue; //month private int _ri; //day private int _xingqi; //weekday private string _errorInfo; public int nian { get {return _nian;} set {_nian=value;} } public ...Show All

• .NET Development make an internet dialer in c#.Net

  hello all, I am to make an application using C# .Net which automatically dials the isp(internet service provider) and connects to internet. If the internet disconnects, it redial again automatically and reconnect. It is totally new taks as I am working in web page developement and have almost no idea of such tasks. Please help me and assist me. Thanks to all indeed, Launch app: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=736300&SiteID=1 Ping: http://msdn2.microsoft.com/en-us/library/ms229713.aspx I hope that this help you :) Regards. ...Show All

• Visual C# Where to find an straight to the point/easy/clear/concise sample on controls usage?

  Hi All! Im quite new to C# but was already able to start a decent/simplified accounting system within two weeks but Im quite having some difficulties finding concise ( short and clear ) samples on using the controls (like datagridview, listview). Is there a site where I can view sample codes that are straight to the point . Hope some of you will not be offended but I noticed that some of the samples given here are lengthy and others are just instructions without actually real codes. There are standouts though like the sample on Voice Synthesizer. It was really great! I made the app talk in less than a minute just like what the author said. Thanks to all! search for quickstarts in msdn and also on web. y ...Show All