SteveMcD's Q&A profile

• Visual Studio 2008 (Pre-release) Would it be hard to add support for SQL IN (...,...) ?

  i.e. string[] cities = { "London", "Paris", "Seattle" }; var query = dataContext.Customers.Where (c => cities.Contains (c.City)); LINQ to SQL gives this error: NotSupportedException: Queries with local collections are not supported It should instead convert this query to: select * from customers where City in ('London', 'Paris', 'Seattle') Without this kind of support from LINQ to SQL, what it the best way to support what Joe is trying to achieve, where a field is to be compared to a dynamically provided small set of values ...Show All

• SQL Server Drillthrough returning sets of duplicate rows

  Drillthrough appears to be showing multiple rows for each single record that should be displayed. For example, in my fact table, there is a single record for each trip. The following MDX query returns a single cell with a trip count of three. SELECT NON EMPTY { [CP Date].[Date by Month].[Year].&[2002] } ON COLUMNS , NON EMPTY { [Commodity].[Commodity by Type and Group].[Commodity Type].&[Other] } ON ROWS FROM [Barge Trip] WHERE ( [Measures].[Trip Count] ) 2002 Other 3 If I drill through on that cell, exactly three records should be returned. However, in actuality, 12 rows are returned - three sets each having four identical rows. To drill through, I am simply adding the D ...Show All

• Visual Studio Error Visual Studio 2003 . NET

  I try install the VS2003 SP1 . And the message box said: Error 1606: Could not acess network location VS Developers (could not create group) I am using Windows Vista. Whats problem Marcos Eike I have the same problem.. Any solution Junior ...Show All

• Smart Device Development selectedIndexChanged fires 3 times unnecessarily

  I have a Smart Device Application project and using VB.NET. in my project I have a form with two combo boxes I have some code in the selectedIndexChanged of a combo box ( cboCategories ). The code will take the value from the combo box ( cboCategories ) and then filters another combo box ( cboProducts ) When I run the form on the Pocket Pc Emulator, selectedIndexChanged of the combo box ( cboCategories ) fires 3 times!!! How can I stop this Or is there any alternative methods/events that I can use for this purpose See my code below Private Sub cboCategories_SelectedIndexChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboCategories.SelectedIndexChanged ...Show All

• Visual Studio Team System Time-tracking for TFS work items?

  Does anyone know if there is a way to track the time spent working on a work item   I'm thinking of something like a "clock-in/clock-out" feature, so a developer can record the actual time spent working on a particular task, etc. I assume that if there isn't a built-in way to do this, there might be a way to build this in as custom functionality.  Any ideas/guidance Updated Question:  Perhaps I should have stated this better earlier... TFS work items obviously have a field or two in which a developer can enter the total time spent on a project, but what I'm looking for is a way to help track and calculate that total time, based on a mechanism (like a chess timer, for example) which would allow a user to "clock in" ...Show All

• SQL Server Back button does not regenerate original report

  When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report. I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen. I forgot to mention that I am using Report Manager to deploy the reports. Please assist. ...Show All

• Visual Studio Team System size of session objects from webtests

  Yes, the dreaded question that needs to be asked once again: How do I measure the size (in bytes) of a non-serializable object I am pusing into the Session Object (ASP.NET) Or even more generally, how can I determine the average size of the session objects (per user) being stored on the server There is no obvious performance counter/metric I am aware that can tell me the size of my collective objects in session, let alone an individual object. The best ideas I have for now are i) using the Available MBytes counter (under Memory) and subtracting the last value from the first value and dividing by the number of active user sessions, ii) same as i) but using #Bytes in All Heaps (.NET CLR) instead of Available MBytes. These ideas might ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Free 2d assets?

  Anyone know of any good sites for grabbing some good free 2d assets sprites and the like (preferably space shooter type 8) I would also have a look at www.gamedev.net in there visual arts forums, there is an FAQ at the top that lists various resources for artwork and such. ...Show All

• .NET Development Replacing <img ... sources with regEx?

  Hi all, how is it possible to extract and modify the src-Attributes of html-image tags. The img-tags are parts of a normal html document and may occur multiple times Example: string sourceText = @"<html><body>....<p> <img src='http://Servername/Webname/Imagelist/myImage.jpg' />"; sourceText+= @"<br><img src='http://Servername/Webname/AnotherImagelist/anontherImage.jpg' />"; sourceText += @"...</body></html>"; // 1. Task: Find all matches of <img src="http://Servername/Webname/....jpg" and create // a local folderstructure, where the folders have the same names like the server, web, and list structure // ...Show All

• SQL Server show changes between records in main table and audit table

  Hallo i have two tables, MainTable and MainTableAudit: the second one keeps DML auditing via triggers. I'm trying to build a query to highlight changes occurred to fields between the MainTable record and its audited records in MainTableAudit, for example, let's suppose i entered an item with some wrong attributes, and edited it three times: MainTable record contains the latest and current version ID002|Hitchhikers Guide to the Galaxy|Sci-fi|240 pages MainTableAudit contains edited ID002 versions ID002|Hitchhikers Guide to the Galaxy|Sci-fi|232 pages|2006-07-08 08:32:12 ID002|Hitchhikers Guide to the Galaxy|Sci-fi|212 pages|2006-05-08 10:54:02 ID002|Hitchhikers Guide to Galaxy|Sci-fi|222 pages|2006-07-04 11:42:16 I would like to build a rep ...Show All

• Visual Studio Express Editions Regular experssion in VB

  Hi, I want to build a regular experssion in VB, format like {db code}-{command},{num},{status} where db code is a single character which should be 'D' or "N" Command - string should be - "DELETE" or "INSERT" num - integer status - string it should be formatted in the same way like -(hyphen) and comma seprated between command, num and status. please help me to solve this. not in .net. i want it in VB. Thank you With a reference to "Microsoft VBScript Regular Expressions 5.5" Dim re As VBScript_RegExp_55.RegExp Dim mc As VBScript_RegExp_55.MatchCollection Dim m As VBScript_RegExp_55.Match Dim sm As ...Show All

• SQL Server Assigning default aggregate function to calculated member

  Is there any way to assign a default aggregate function (e.g. SUM) to a calculated member just like we can do this with a regular measure What I need to do is assign a custom calculation in my calculated member at the lowest grain (e.g. scoped at Date.Members and Customer.Members). Everything above this should be summed by default, e.g. Sales Territory. Hi, Mosha Assuming the workaround, Is there difference in performance between a calculated member and a regular measure ...Show All

• Visual C++ When "It just works!" doesn't. :(

  Hi, To test out "C++ Interop", I created a static library in VC++ 6.0: Here is the contents of the header file (staticLibrary.h): #ifndef STATICLIBTEST_H #define STATICLIBTEST_H #include <string> using std::string; int add352(int value); string sayHello(string name); #endif Here is the implementation (staticLibrary.cpp): #include "staticLibrary.h" int add352(int value) { return value + 352; } string sayHello(string name) { string s1("Hello, you are the greatest, "); return (s1 + name + "!\n"); } This code compiles fine in VC++ 6.0 and it produces an object called "staticLibrary.lib ...Show All

• Visual Basic registering filetypes to an app

  Hello, I'd like to know how to register filetypes to my application. It is a picture viewer program, and i'd like to register eg jpg files to it through an option in my program. the main problem is how to register the filetype. could anyone help thnx Hi Slyke, To do what your asking your program needs to have a main method, the main method is the first method to get called in all applications, VB hides it from you. You will need to create one. The main method is passed an array of strings that define the arguments used to open the application. You need to check the length and value of the arguments and process the applications parameters depending on what your looking to do. Here's an example... Public Modul ...Show All

• SQL Server get timezone specific date

  Hello, I am struggling with one algo i.e. I want to retrieve the date according to time zone I have table called TIMEZONe in which i have the information about the hours difference (+12 to -12) from GMT... now my scenario is that I want to get the date, using information from timezone area table (time difference from GMT), of any particluar time zone can any one tell me, how will I able to achieve this task. for example: it 4:00 AM in the mornign in GMT TIME and date is 11-08-2006 but in US it 11:00 PM and date is 10-08-2006 Note: Server date is set to GMT (System date) regards, Anas Where is the problem If you have a TimeZone table you could use a query like this select dateadd ( hour , T ...Show All