Dan Crevier's Q&A profile

• Visual FoxPro table manipulation

  Two tables exist, call them tableA and tableB. They share some data. which was easy to get select a.work_id, a.sp_id, b.work_id, b.sp_id; from tableA a inner join table b on (a.work_id = b.work_id); order by work_id; into cursor hold1 there is still a matter of getting all the data from tableA and tableB that they don't share. i tried doing a left outer join, but i still get duplicates. Any ideas MP Here you go: SELECT A.CITY,SUM(A. ...Show All

• Visual Studio Team System How to get the name of a .vb file

  Hi Guys, I developed the rule below to get the name of all *.vb files that are inside a projet and wanna verify if the name has an especif construction. But, when I debug the rule method, I get the name of the .dll of the project and not the files inside it. How can I verify each file in a project I am analysing in fxCop the project dll. Is it correct Public Overloads Overrides Function Check( ByVal Modulo As Microsoft.Cci.Mod ...Show All

• Visual Studio Express Editions Where is the web page dll?

  Hello! Installed VWD beta 2 yesterday and started building a web page. Works fine but I am wondering where the the dll is VWD seems to build a temporary dll instead of an ordinary dll like VS2003. Cannot find any setting to change this... Anyone who knows more about this // Regards Marcus Ok, guess it is the new Dynamic Compilation Model... http://msdn2.microsoft.com/library/s57a598e(en-us,vs.80).aspx ...Show All

• Visual Studio Team System How to publish test result to TFS by programming

  I know how to publish a test result to TFS by myself in VS now. What I wanna know is if there is a way to publish the result by some programming approach It seems I can use the PublishTestResultsBuildService.asmx in TFS, I tried but failed, can any one give me an example for that. Thanks I don't think there is an API that you can call to publish the results file to TFS. If you are looking to publish results file outside of VS IDE win ...Show All

• Architecture Architecting BLL, DAL and DB for bulk entity updates

  Hi all, My situation is as follows: I have a service that receives a list of some entity in order to do some kind of operation on each of the entities in the list: 1. The operation is the same for each of the entities (updates one of the fields) 2. There is a logical test to perform on each entity in order to know if the operation can be made or not 3. The response of the service is the original list of entities, where for each of ...Show All

• Windows Forms Balloon ToolTip at ToolStripStatusLabel

  Hello, how can add a BalloonToolTip to ToolStripStatusLabel This Code works only of StatusStrip: Dim tt As New System.Windows.Forms.ToolTip With tt .IsBalloon = True .SetToolTip(Me.StatusStrip, "test") End With Please Help! Blade68 ...Show All

• Windows Forms How to use javascript in vb.net window application

  I added a javascript in my window aplication(VB.NET). Now i dont know how to user that javascript in my form plzzzzzzz help Why do you need javascript in a Windows application Everyting is dynamic and can be done with VB.NET. I don't think it's possible to do it. ...Show All

• .NET Development .Net Framework Beta 2 - Write access problem on Temporary ASP.NET Files folder for ASPNET account

  We have installed .net framework beta 2 version and when we browse any .aspx page we are getting the below error message ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Server Error in '/WitsWeb' Application. -------------------------------------------------------------------------------- The current identity (<Computer Name>\ASPNET) does not have write access to 'C:\WINNT\Microsoft.NET\Framework\v2.0.50215\Temporary ASP.NET Files'. Description: An u ...Show All

• SQL Server 2 minutes after one datetime vs. another datetime

  when I run the query now using and calldatetime >=  dateadd(minute,2, a.stop1) , I am getting for example: calltime                                  time2 2006-02-23 15:45:20.000         1899-12-30 21:00:00.000 this doesn't seem to be working, I want all r ...Show All

• SQL Server The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• Visual Studio Team System MSSCCI provider for VB6

  I have read that there will be an MSSCCI provider that allows TFS source control in VB6. Does anyone know if this is available yet and where I could get it Regards Graham No, you didn't miss it.  We been help up getting the End User License Agreement in place.  I appologize for the delay.  It pains me because the software has been ready for weeks.  I'm told the EULA will be ready this week s ...Show All

• Visual Basic Compiler Problems even though code is sound.

  Hi, I'm having a strange problem with Visual Studio 2003 and I'm hoping someone can help. The problem is I'm getting compiler errors even though the code is fine. Here's an example.... This is code from a form I have... Public Class frmGasDiagram Dim udtGasDiagram As clsGasDiagram In some methods of the form I get errors saying the type udtGasDiagram cannot be used as it hasn't been defined, but it is. If I change the ac ...Show All

• Software Development for Windows Vista Monitor example throws: "Could not load file or assembly DefaultSQLServices, Version=1.0.0.0"

  I am trying to run the Monitor sample that comes with WWF Beta 2.2. When I have it synch, I get this error: "Could not load file or assembly 'DefaultSQLServices, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified." I can't find where this is trying to be loaded.  It is obviously trying to reference early Beta version since all the new versions are 3.0.0.0. ...Show All

• Visual Studio Document Explorer filters have been overwritten!

  Hi there, Yesterday I installed the Enterprise Library (Nov 2005 CTP) and was reading through the help files via MS Document Explorer.  To that end the only filter available is "Enterprise Library - Nov 2005 CTP" in my contents filter list. But now when I'm trying to access help from VS 2005 Professional (with MSDN installed) it still only shows the "Enterprise Library - Nov 2005 CTP" filter and none of the Visual Basic or C++ or any ...Show All

• SQL Server can't modify stored proc which is in a publication

  Hi SQL 2005 sp1 - merge replication - HTTPS. We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic and another with SyncType = SubscriptionSyncType.None. The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data. When we try to modify a proc which is in the publication with SyncType = Automatic, the query never ...Show All