genuine_tuffguy's Q&A profile

• SQL Server Converting T-SQL *= OUTER JOINS to ANSI-92 syntax

  Hello all.  I have an application that has worked smoothly using the following query syntax: FROM tbl_participation, tbl_adult, tbl_month, tbl_school_year WHERE tbl_participation.adult_ID =* tbl_adult.ID AND tbl_participation.month_ID =* tbl_month.ID AND tbl_participation.year_id =* tbl_school_year.ID AND tbl_adult.ID = 8 AND tbl_school_year.ID = 5 It works just fine, as I want the results to include a ta ...Show All

• .NET Development GAC Assembly is There, But Where's the DLL?

  Hi all, I'm still a .NET newbie so this is probably easy. In the GAC I see an assembly, "Microsoft.VisualStudio.Shell". The properties for this assembly indicate its "original filename" is "Microsoft.VisualStudio.Shell.dll". When I look for this file on my hard drive, however, it is nowhere to be found. Is it possible for an assembly to be in the GAC but for the underlying DLL to not exist Can someone point me to ...Show All

• Visual Basic DirectX confusion?

  Hi There, I have been trying to integrate some Direct X functionality into my VB.NET application and am finding it incredibly difficult to find code samples with VB.NET code instead of C# examples which are everywhere! When I have found a few VB.NET code samples that I can understand, they won't run on my machine because I am running a newer version of Direct X (DirectX 9c) and this version is apparently not backwards compatible with the previou ...Show All

• Visual Studio Team System Error 28918 - error calling Tfs Registration web service

  Anyone else get this error on install of the Application tier This is on a dual server setup New OS install w/ IIS & WSS (yes, I installed WSS in Server Farm mode) The message text: "Either IIS is not running or is not configured properly" concerns me.  This is an out of the box install. Can you post the install error log please   This should have a little more information. Can you also check if you can browse the Sharepoint ...Show All

• SQL Server MergeSynchronizationAgent must be instantiated on a Single-Threaded Apartment (STA) thread

  I am using the exactly same sample code on http://msdn2.microsoft.com/zh-cn/library/microsoft.sqlserver.replication.mergesynchronizationagent.synchronize(SQL.90).aspx to synchronize a push subscription and get this error while executing the statement: subscription.SynchronizationAgent.Synchronize(); I even added a [STAThread] attribute on the method but still no luck, anybody can share a light on it Thanks! mengruts Hi Mengruts, ...Show All

• .NET Development Replace info in XML doc of xls spreadsheet with live data???

  I want to read through my excel spreadsheet that i have as an XML document and replace my data information with my information from my sql tables and i really dont know how to accomplish this any help would be great! Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim conn As SqlConnection Dim drsql As SqlDataReader Dim cmmd As SqlCommand ...Show All

• Visual FoxPro coming back to foxpro

  used foxpro 2.5 and now have visual fp.  am having trouble lwith iff and if then syntax.  i want to have user enter a zip code and then the city and state are filled in.  thanks for any help there are many 3rd party controls available that do this, you might save yourself a lot of time. I used one about a year ago, it was under $100.00 and worked very well. ...Show All

• Visual Studio Tools for Office Is there anyway I could get the position of a control(FormField) relative to the screen edges instead of the window edges?

  Hi, I could not get the position of a control relative to the screen edges instead of the window edges, is it possible I have a word application in which Form Fields are getting created at runtime, on selection of a particular form field, I want to display win form exactly at the position where form field has been placed. Thanks in advance. Saurin I think you can use one of the following : Screen ...Show All

• Software Development for Windows Vista Questions about state machine workflow and parameters

  Hi there. I have some questions about how to deal with parameters in a State Machine workflow. Parameters as far I know should be passed in the form of Event Arguments in a State Machine, that’s right The example is "inspirated" in the Expense Report sample application, except the workflow type (mostly because the WCF communication)... In the case Event Arguments are OK to pass parameters, I have this EventArgs class: [Seria ...Show All

• SQL Server OTP: help

  I just want to know how I increase my virtual memory. I know i can, I did it on my old PC, but can't remember how. Please help stop the frezzing of my gameing. As you may have guessed when you posted in a 'SQL Server replication' forum, this forum is not the right place for this question. In fact, none of these forums are right for this question. You need to find a forum dedicated to consumer level questions. An ...Show All

• Visual Studio Team System List of TF commands that don't require checkin (commit)

  It seems that most of the TF commands don't do anything on the repository until you actually commit (oops, I mean checkin) your changes.  I know there are a few commands that act immediately.  Could we get a list of all the commands that don't require checkin   I believe labelling is one of the commands that acts immediately. Good point- resolve actually doesn't require a checkin to complete, thou ...Show All

• Windows Forms debug mode - can't drill into instances

  When debugging, I used to be able to click on the little "plus" icon next to an object instance name in the Autos window, and it would expand to show the values of that object's members, it's parent types, etc.  Now it never  ...Show All

• Software Development for Windows Vista Custom Activity with timer does not execute after timer expired

  I have created a custom activity that has a timer.  The activity executes, creates the timer and then idles.  After the timer has expired, the workflow is reloaded and scheduled for execution.  My problem is that the custom activity doesn't get executed again.  I am not sure what is being executed by the scheduled callback.  I have a custom persistence and scheduler service so I know the workflow is being reloaded and ...Show All

• Visual C# Pass by Whatever

  Hi! I am confused by the insistence of both Java and C# that passing a reference type is not pass-by-reference but pass-by-value. I take it that since you get a copy of the reference, they consider it pass-by-value Then, what is passed in pass-by-reference A handle (pointer to a pointer) And, if so, isn't it a copy of the handle that's being passed As you can see, I am missing something. Please, lay it out simply for me. (Pass-by-value--I ...Show All

• Visual Studio 2008 (Pre-release) Cannot use AND in the where clause

  For the code... Dim rawTables = From tables In dq.SystemObjects _ Where (Tables.Type = "U" And tables.Name <> "sysdiagrams") _ Select Name, Id ...the query I get is... exec sp_executesql N'SELECT [t0].[id], [t0].[name] FROM [sysobjects] AS [t0] WHERE ( (CASE WHEN [t0].[type] = @p0 THEN 1 ELSE 0 END)) & ( (CASE WHEN [t0].[name] <> @p1 THEN 1 ELSE 0 END)) ',N'@p0 nvarc ...Show All