foxystar's Q&A profile

• Visual Studio 2008 (Pre-release) Possible to implement Standard Query Operators in C# 2.0?

  Hi I have tried to implement the query language syntaks in C# 2.0 in a static Query class i.e public static IEnumerable<T> Where<T>(IEnumerable<T> source, Func<T, bool> predicate) { foreach (T obj in source) { if (predicate(obj)) { yield return obj; } } } as I find the new syntaks very impressive. But my code tens to become very "ugly" as I cannot extend the IEnumerable<T> interface with new static methods. Is it possible to implement in 2.0 And the obvious: How Cheers I think that technically, parts of it could be accomplished, but it would be ugly, hard to read, and some parts just wouldn't be possib ...Show All

• SQL Server showing nulls- UPDATED

  Hi All, Ok in an effort to work why the NULL values of my OUTER JOIN are not being shown... I've stripped the query down as best I can The only thing that's a little complicated is the CASE statement to correctly format one of the postcode values from one tbl to the other.. apart from that I can't see why they wouldn't show... Any ideas anyone SELECT ISNULL(COUNT(CASE LEN(REPLACE(dbo.Customers_Trade.PostCode, ' ', '')) WHEN 5 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 2) WHEN 6 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 3) ELSE LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 4) END), 0) AS PCCount, dbo.UkPostcodes.Postcode, dbo.UkPostcodes.Town, dbo.UkPostcod ...Show All

• SQL Server SQL Server Xpress remote connections

  Hello I've installed the SQL Server 2005 Xpress Edition on a server. On other machine I've got the SQL Server 2005 Enterprise Edition. From this, I'm trying to connect to the SQL server witch has the SQL Server Xpress Edition but gives me the follow error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 I've ...Show All

• Visual Studio Tools for Office Outlook 2007 Beta error

  Outlook 2007 now cannot be started due to a corrupted MAPI32.DLL file. It suggest that this may have been couse by installing foreigh messageing software. Is the Outlook MAPI32.dll file available for download This would be much easier than the instruction to reinstall Outlook 2007 beta -- I think. Please advise. Thank you. Hi Gregory, Have you tried repairing the installation to see if that fixes the DLL Thanks and regards, Darryn Lavery [MSFT] ...Show All

• Visual Studio Team System CTP5 patch bug - Object reference not set to an instance of an object.

  I consistenly get an error dialog that says "Object reference not set to an instance of an object." whenever I invoke the SQL Server 2005 Wizard after installing the CTP5 patch. Without the patch, everything is fine. I've done this three times and a coworker has done this once. OK that is probably the route of the issue. By changing this, to point to a SQL Server Dev or SQL Server entreprise edition, does the issue go away mairead ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Survey: Use Xbox 360 Controller with PC Game?

  I'm just curious what the community thinks... For my upcoming XNA-based game -- which will almost certainly be released for the PC before the Xbox 360 -- should I require users to use an Xbox 360 controller Reasons to use the Xbox 360 controller: 1. I will need only ONE input routine. I won't have to worry about checking the keyboard or mouse so I can optimize the routine to be as fast as possible for the Xbox 360 controller. 2. All functionality can be accessed via the Xbox 360 controller via menus or the virtual keyboard (which is pretty much standard for any game on the Xbox 360). 3. Once I get everything running on the PC, porting my game to the Xbox 360 will be fairly painless. (I hope!) Reasons NOT to use ...Show All

• Connected Services Framework The participant 'HelloWorldParticipant' does not support action

  Hello As per the readme I am executing the helloworld example and am getting this error <FaultMessage>Failed to create session. The participant 'HelloWorldParticipant' does not support action 'http://tempuri.org/HelloWorld'.</FaultMessage> I searched the forum also and realised only I am getting this error :(. Can anyone please point out what I am missing here Regards Paul Hi Sid, The internal server error is a very generic error.It might me due to some other problem too.I faced it once and I solved it by reinstalling the CSF Framework. It would be great if you refer the installation guide and check what changes you have to do in the session config files.( C:\Program Files\Micros ...Show All

• Visual Studio Express Editions Web Browser Help

  Hi, I'm trying to add alot of stuff to my web browser. I searched in google, but I didn't find anything. I tryed writting codes to see if I can get it, but I can't get it :( 1. Favorites 2. View Text Size 3. Web Browser site Name something like this (Visual Basic General - MSDN Forums - Mozilla Firefox) 4. History 5. Enter button when you type in the URL 6. Show the URl in the URL bar for every link. And I'll try to figure out the rest, because I have alot of stuff that I want to learn, but I think it's rude to ask for too much. Thanks. There is a sample VB express web browser program at http://msdn2.microsoft.com/en-us/library/3tst62z1.aspx That should help some. I have tryed it, it works. ...Show All

• SharePoint Products and Technologies Passing the Excel parameters to the backend

  I can define parameters in Excel Services, but I couldn't find any directions on how to pass those parameters to the back-end SQL Server relational database. Our users may see different set of data depending on their position. The Asia manager isn't allowed to see New York data for instance. I need to identify the user currently viewing the Excel sheet, and pass it's name as a parameter to the SQL server, so that SQL will filter out the data that the user isn't allowed to see. Is there an article out there that shows how to pass parameters to an SQL data source from Excel Services Seems like you should be using SSO: http://technet2.microsoft.com/Office/en-us/library/7e6ce086-57b6-4ef2-8117-e7 ...Show All

• SharePoint Products and Technologies ListInstance ID is ignored in Feature

  I am trying to deploy a custom list containing countries, with its content - to another site collection - using a Feature. I use that particular list for a lookup field. My countries list is being created just fine, but the Id of the list is changed causing my lookup field to fail. It appears that the Id property of the ListInstance is ignored, when i look at the online documentation http://msdn2.microsoft.com/en-gb/library/ms476062.aspx it tells me that the Id property is supposed to be an Integer Can anybody tell me how to acomplish this < Elements xmlns = " http://schemas.microsoft.com/sharepoint/ " > < ListTemplate Name = " countries " Type = " 4000 " BaseType = " 0 &quo ...Show All

• SQL Server “AcquireConnection method call to the OLEDB Connection Manager for SQL Server failed” Error

  I have an SSIS package which takes input from Flat file and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use SQL Server Authentication for the user ‘sa’. The package works fine without enabling the configurations. But when I enable package configuration and save the configuration of the various connection managers in an XML configuration file and then run the package it gives the following error in the validation phase: [OLE DB Destination [21]] Error: The AcquireConnection method call to the connection manager "<Connection Manager Name>" failed with error code 0xC0202009. And after the validation phase is comp ...Show All

• SQL Server Slicer and axes interaction in MDX Part 1 - coordinate overwrites

  A question regarding this Blog post by Mosha. I have tried the MDX examples with SP2 CTP 1 (November) and still get the wrong results. Is this fixed in a later release of SP2 Regards Thomas Ivarsson Thank you Mosha. I should be able to see this in CTP1 What version of the Adventure Works cube are you using(Standard or Enterprise) Have there been any changes in this cube since the RTM of SSAS2005 one year ago I will check again with a never version of Adventure Works. Regards Thomas Ivarsson ...Show All

• Visual Basic read special characters from textfile in visual basic .net 2005

  Hi, I am trying to load a simple textfile into my program. The file contains some swedish characters (aaoAAO) which for some outlandish reason isn't loaded. So the text looks very weird, looks like the StreamReader just skips them. Here is the code that tries to read the textfile: Partik. Amazing.. Thanks a lot . it worked like a charm cheers. Karthik ...Show All

• SQL Server ConnectionManagerOleDb usage in a Script Component

  Hi, I have a need to use a shared connection manager of type OLEDB inside a Script Component. I guess that the right way to get the OLEDB connection is to override the AcquireConnections method, case the shared connection manager to the ConnectionManagerOleDb interface and call the AcquireConnection method. The problem is in the return value of the AcquireConnection method (it’s Object). My assumption is that in case of OLEDB connection usage, the AcquireConnection method returns some OLE DB COM interface. Does some of you tried to cast it to some interface/class exposed by DTS (or some standard COM interface from MDAC) PS I’m aware about the possibility to use ADO.NET connection managers, however it’s n ...Show All

• Visual Basic How to add data to an Access database using code only

  I have a program which I created in VB6 and I am trying to replicate it in vb 2005. I have been able to replicate most of the code but have hit a brick wall when it comes to modifying data in the Access 2000 database I am using. I am only using code, ie creating my own connections via code and not the database connection wizard. How do I add data to an Access database using only code (for example using an INSERT query if possible) Hi, I think the 2nd post from the 1st link here may be the most useful.> http://forums.microsoft.com/MSDN/Search/Search.aspx words=access&searchKey=&lcid=1033&searchscope=forumgroupscope&siteid=1&ForumID=-1&ForumGroupID=10 http://forums.microsoft.com/ ...Show All