Robert3234's Q&A profile

• Visual Studio 2008 (Pre-release) Recommended way to do outer joins in LINQ to SQL

  First option: var query = from c in Data.Customers from p in c.Purchases.DefaultIfEmpty() select new { c.Name, p.Price }; This produces the SQL you'd expect, i.e. SELECT [t0].[Name], [t1].[Price] FROM [Customer] AS [t0] LEFT OUTER JOIN [Purchase] AS [t1] ON [t1].[CustomerID] = [t0].[ID] Second option: var query = from c in Data.Customers from p in c.Purchases.DefaultIfEmpty() select new { c.Name, Price = (p == null null : p.Price) }; This type of query works over both IEnumerable and IQueryable, but the SQL it produces seems less efficient: SELECT [t3].[Name], [t3].[value] AS [Price] FROM ( SELECT (CASE WHEN [t2].[test] IS NULL THEN NULL ELSE [t2].[Price] E ...Show All

• Visual Studio Express Editions I need help please, I have a small problem

  This is my code { RegistryKey OurKey = Registry .LocalMachine; OurKey = OurKey.OpenSubKey( ".SOFTWARE/Microsoft/Windows/CurrentVersion/Explorer/VolumeCaches" , true ); } OurKey.DeleteSubKey ( @"SOFTWARE/Microsoft/Windows/CurrentVersion/Explorer/VolumeCaches/Compress Old Files" ); However i have recieved an error saying: Error 1 Invalid token '(' in class, struct, or interface member declaration The instance it is talking about is the bracket i have highlighted in yellow\ Please any help would be amazing Mitch, its because you placed it outside the method/class. place it before the closing curley bracket { RegistryKey OurKey = Registry ...Show All

• Visual Basic My.Settings strange problem

  I have been trying to figure out why one of my settings will not properly save. Here is what the user.config file looks like: < xml version="1.0" encoding="utf-8" > <configuration> <userSettings> <Project_Tracker.My.MySettings> <setting name="MainLocation" serializeAs="String"> <value>86, 112</value> </setting> <setting name="Engineer" serializeAs="String"> <value /> </setting> </Project_Tracker.My.MySettings> </userSettings> </configuration> Notice that the setting for "Engineer" is not propery formatted. If I manually change the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. wierd error messages

  ok im new and just starting out im in highschool neways im working on the tutorial and i do exactly what it tells me but i get 13 error messages froem the lines of coding i copied from the tutorial whats wrong //3d model to draw Model myModel; protected override void LoadGraphicsContent( bool loadAllContent) { if (loadAllContent) { myModel = content.Load< Model >( "Content\\Models\\p1_wedge" ); } } } /// <param name="unloadAllContent"> Which type of content to unload. </param> protected override void UnloadGraphicsContent( bool unloadAllContent) { if (unloadAllContent == true ) { content.Unload(); ...Show All

• Visual Basic User & pwd authentication - Web App using vb2005

  Could anyone please help I need to login authenticating the windows user and password UserName = txtUserName.text UserPassword = txtUserPassword.text MyDomain = txtDomain.text Hi, Show the default web page and drop the LOGIN control from the toolbox LOGIN area onto the default.aspx page. Your aspx.vb code will then need to be something like.>>   Partial Class _Default Inherits System.Web.UI.Page   Protected Sub Login1_Authenticate( ByVal sender As Object , ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate If Login1.UserName = "Admin" And Login1.Password = "myPassword" Then 'Do something. End ...Show All

• SQL Server Report Model Generating Out of Memory Error

  I am creating a report model of a large database with a few hundred tables, the idea being that the users can report on any part of the database and create perspectives for the areas they want users to have access to (In the past the users have moaned about report models in a CA product called Eureka as the models are too small, perspectives seemed a way of allowing one large model but limiting each perspective to a set of users ). Unfortunately presumably due to the size of the model visual studio is giving me an out of memory error when adding new tables. I have a two dual core xeons with 4Gig of ram and I'm running XP Pro 64bit with the developer edition of 2005 with service pack 1 and VS2005 is using around 1/2 a Gb. Is this a known i ...Show All

• SQL Server Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)

  Analysis Services Project deployes with success. When you want to browse the deployed cube by draging an attribute from the Metadata pane to drop it on the DataPane the following takes place. =================================== Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets() at Microsoft.AnalysisServices.Controls.PivotTableHash.get_FieldSetsEnumerator() at Microsoft.AnalysisServices.Controls.PivotTableHash.GetFieldSet(String uniqueName) at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject) at Microsoft.Ana ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Slight Lag in XNA?

  I am new to XNA, but I followed some simple tutorials to load a small image, get it on screen, and move it around. I've noticed that for the most part, the updating of graphics is smooth, but every few seconds the update to the display "misses a beat" or something and the on screen sprite jumps instead of moving smoothly. I have changed the display to show one hundred images and do the same test, and I get the same result (it doesn't even get worse). I've confirmed this happens on a friend's top of the line computer as well. I can't imagine anything I am doing is that intensive...I have made games in DirectX before and have not had this issue. I have a breakpoint in gameTime.IsGameRunningSlowly (forgive me, I forget the exact pro ...Show All

• Visual Basic short cut key

  I use F12 (right mouse click, GoToDefinition) to go to the Definition of a function. What key can be used to go back to the source please Thanks ...Show All

• SQL Server Questions about reportBuilder

  Hi ! We have made a webApplication that use ReportServer. Some of our client would like to be able to make some basic report. They can't use Visual Studio so i thought that reportBuilder will be a good idea. I've tried to create a Model for them but it doesn't work. I have followed the instruction on this page: http://msdn2.microsoft.com/en-US/library/ms345313.aspx I have created my datasource. When i click on Generate and put the name for the model i click on OK and then i always got this error: (rsModelGenerationError) A relation already exists for these child columns. Did i forget something to do Also i would like to know how to do to install ReportBuilder on a Client computer. Those client already have a server wi ...Show All

• Visual Studio Express Editions Windows - No Disk

  I just downloaded Visual Web Developer 2005 Express and am getting a lovely error from the installer. As soon as the "Setup is loading installation components." progress bar completes, I get a dialog entitled "Windows - No Disk" "There is no disk in the drive. Please insert a disk into drive ." (Yes, the drive letter is empty) Anyone have any advice I had a similar problem, but with another program. If I kept hitting "cancel" or "try again" repeatedly, eventually it would continue and work. But obviously, this is annoying. I read this solution on another forum: http://forums1.itrc.hp.com/service/forums/questionanswer.do threadId=1065150&admit=-682735 ...Show All

• Visual C++ Problem migrating to Visual Studios 2005

  I'm trying to convert a project i've been working on from eVC++ to Visual Studios 2005. The header files are in the same folder as the source files but apparently they do not exist when i try to compile. gives me a problem with my include statements saying stuff like "cannot find include file "StdAfx.h" \n Does not exist. Any help on the matter would be much appreciated, thanks. It's probably a case of the elusive property. Check the settings for all .cpp files in your project (precompiled headers are configured per .cpp), especially those noted on in the error message, and make sure they are switched off. ...Show All

• Windows Forms repair install (event id 1001 and 1004) - whats causing this in my case?

  I'm getting eventlog events 1001 and 1004 indicating a repair install. The 1001 event description is: Detection of product '{6C2EFFE6-1A20-4FB8-81D2-2B1A3ADFDC53}', feature 'DefaultFeature' failed during request for component '{ 22056900-C842-11D1-A0DD-00A0C9054277 }' This indicates component Global_Controls_MSCOMCTLOCX, which I install from a standard MS VS6 SP6 MSM file. The 1004 event description is: Detection of product '{6C2EFFE6-1A20-4FB8-81D2-2B1A3ADFDC53}', feature 'DefaultFeature', component '{ EDBDF246-2367-469D-AB3D-6F076F338CA8 }' failed. The resource 'E:\' does not exist and this indicates the following component (Component table of the MSI): Component="_C57571A181C24B139A26CBF7E2E09D ...Show All

• Visual Studio 2008 (Pre-release) Availability of EDM Schema Files for AdventureWorks Samples?

  The "ADO.NET Entity Framework Overview" white paper has many examples of SalesPerson and SalesOrder EntityTypes but the SSDL, CSDL, and MDL schema files to generate them are nowhere to be found. (At least where I've looked so far -- see http://oakleafblog.blogspot.com/2006/08/adonet-vnext-and-entity-framework.html .) I'm not ready to spend a lot of time experimenting with rolling my own schemas with a CTP as a result of my earlier Orca (ObjectSpaces) experiences. I assume the folks who wrote the "Overview" had the schema files to test the code examples. Thanks in advance. Pablo, Only a minor fix to the query script was required (PRIMARY_KEY for SalesOrders), and the schema ...Show All

• Microsoft ISV Community Center Forums Text wraping on edit box of dialogsheet

  I have created a form with an editbox and what I need to do is to make the text content wrap rather than continuing on to the right past the size of the box. Any ideas welcome please. With DialogSheets("FormAdd") .EditBoxes("Edit Box 144").Text = "" .Show End With How exactly would I use this in conjuction with the existing .Text = "" The line of code doesn't work on its own either even in the absence of the .text line. ...Show All