Confused4130's Q&A profile

• SQL Server Grand Total Needed

  I have two subreports (Revenue and Expense) that each have subtotals. This works just fine, but I need a Grand Total that would sum the two subtotals. How would I go about doing this So it looks something like this: Revenue Report (matrix) Subtotal Expense Report (matrix) Subtotal <~~~~ Need Grand Total here. Greg, It would be difficult across two data regions, myself, I create Calculated GrandTotal field in my dataset and then use that field for display. Ham ...Show All

• Visual Studio Tools for Office Retrieve Outlook calendar

  Can anybody tell me how does one retrieve an Outlook calendar and store it in a database I would like my app. to detect appointements from outlook, display them in a datagridview in my app., and store the info in a DB. I looked at this: ms-help://MS.MSDN.vAug06.en/enu_kbvbnetkb/vbnetkb/313801.htm#2  and it doesn't seem to be working. Just as I get to the line below, I get an error saying: 'type outlook.application not defined'. Dim olApp As New outlook.application Which namespace(s) should I use to accomplish this. I've already added a reference to the outlook object and am using MS Outlook 2003. Any help appreciatd, thanks in advance. Outlook appointment details can be obta ...Show All

• SQL Server SP2 y SQL Native Client

  Hello. Does anybody knowk if it's necessary to upgrade Sql Native Client to conect to a Server when you has upgrade it to Sql 2005 SP2 That is to say, can you conect to a Sql server 2005 SP1 and to a Sql Server 2005 SP2 from a client with the same Sql Native client or you have also to upgrade it Thanks. No, you don't have to do anything special. When you upgrade to SP2, SQL Native Client has also been upgraded. Btw, any version of SQL Native Client can connect to any version of SQL Server 2005 without problem. ...Show All

• SQL Server Weird error DBSTATUS_UNAVAILABLE

  Hello I have an issue with a data flow task that is reporting DBSTATUS_UNAVAILABLE. The data flow task consists of a Data Reader source which splits the rows off into 1 of 3 categories; update, insert, delete. Each destination is an OLEDB Command which respectively performs the needed operation. The insert works fine as we just ran it yesterday and loaded 800,000 records into the table, the update is reporting the error, yet the data types match, both are nvarchar(25). Does anyone have any idea why this might be occurring We use this same method for all of our packages and yet this is the only one that seems to have this problem. Any help would be greatly appreciated. Thank you! Hello Phil, Thanks for the suggestion. I have gone ove ...Show All

• Visual Studio 2008 (Pre-release) Am I wrong about WCF usage?

  I have been experimenting with WCF, on and off, for some time and it 'seems' that 99% of the design effort is around B2B communication with 1% on a self-contained applications. I say this because the assumption with WCF interface contracts is that the client-side knows nothing about the business model; thus, the operation contract requires explicit declaration of types. This, from my view, is horrible for uses where a developer is designing a self-contained application. I have hundreds to thousands of classes where 90%+ only need a two interfaces between client and server when generics are applied. Declaring 500+ classes as known types for a data contract is rediculous. Now - thank goodness - there is the NetDataContract which all ...Show All

• Visual C++ place for code

  maybe this is a stupid question, but I have started microsoft visual C++ today (c++ itself also for the first time) and i dont know where to put the code. i'm making the program hello world, but it doesnt work it asks if i want to 'build' the programm and i dont know what it means. i named the program hello and i put the code in the place where it says: hello.cpp is this the right place if so, what am i doing wrong this is the code: // hello.cpp : Defines the entry point for the console application. // #include "stdafx.h" int _tmain( int argc, _TCHAR* argv[]) { return 0; } #include <iostream.h> int main() { cout << "Hello World!\n" ; return 0; } ...Show All

• Windows Forms How can I bind a treeview to data returned by a CTE (Common Table Expression) in SQL-2005

  Just out of curiosity is it possible to bind a treeview control to data returned from a CTE Ken is right, treeview does not support databinding. But you can customize/extend it. The following links will be useful http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnwinforms/html/custcntrlsamp3.asp http://www.codeproject.com/cs/miscctrl/dbTree.asp ...Show All

• Visual Studio 2008 (Pre-release) Package/ZipPackage: VERY BAD behavior with low disk space

  I already posted this in the 'MSDN Connect' feedback center, but this is bad enough that I hope someone here can provide more immediate feedback. Essentially, ZipPackage.Close can fault in low disk space conditions meaning that you can't successfully Close ('Dispose') the Package. In turn, this leaves a FileStream instance lying around (internally owned by the ZipPackage), and that FileStream will throw an IOException (out of disk space) when the finalizer thread runs. Since the finalizer thread can run at any time, this means this un-Disposed Package (and its accompanying FileStream) is a time bomb waiting to happen! Here's the simple code sample. You'll need to compile it with a reference to WindowsBase (for packaging support), ...Show All

• .NET Development No row at position 0.

  I am trying to show/hide a control based on the value of a boolean DB field with the code below: Dim dsAdmin As New DataSet Try DBCon.ConnectionString = csWBoard DBCon.Open() userAdpt.SelectCommand = New OleDbCommand _ ( "SELECT admin FROM [User] WHERE (userID = '" & userName & "')" , DBCon) userAdpt.Fill(dsAdmin, "User" ) If dsAdmin.Tables( "User" ).Rows(0).Item( "admin" ) = True Then mnuAdmin.Visible = False Else mnuAdmin.Visible = True End If DBCon.Close() DBCon.Dispose() Catch ex As Exception MsgBox(ex.Message) End Try The field is of type Yes/No in my MS Access DB and the format property ...Show All

• Visual Studio Exception thrown on Register SCSF

  I can install the Smart Client Software Factory using the setup, except that it runs into a problem because I'm using source control over a VPN. Based on the gotdotnet forums, I'm trying to build a new version of the SCSF that should fix that problem. The SCSF builds fine, but it will not register. GAX: 1.0.51104 GAT: 1.0.51104 When I go to Register or QuickInstall, I get an exception thrown of System.TypeLoadException: EnvDTE.Project, EnvDTE ---> System.IO.FileNotFoundException: Couldn't find assembly EnvDTE. at Microsoft.Practices.Common.Services.TypeResolutionService.GetAssembly(AssemblyName assemblyName, Boolean throwOnError) at Microsoft.Practices.Common.Services.TypeResolutionService.GetType(String typeName, Boolean ...Show All

• Visual Studio Express Editions Use forms and build windows application?

  Hallo I'm new to VS2005. I have found that it is possbile to use windows SDK, but I couldn't found an answer that I'm interested in: If I install SDK, is it possible to use forms and to build a windows native application It is for sure possbile to build forms using the PSDK and hence your code will be native. But if you meant winforms, winforms is a managed technology and hence the code generate will be managed. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual C++ graphics in visual c++

  does visual c++ support the graphics.h header file on its own or do we need to install the software seperately. the coding which is being done by me is in visual c++ and have included #include<graphics.h>. the error which am constantly getting is cannot open the include file: graphics.h. am not using the graph.h, graphview.h which are inbuilt in visual c++. I think you are trying to compile Turbo C/C++ program in VC++ compiler. (Are you trying to compile programs from Yashvant Kanitkar's book ) I have never seen graphics.h in VC++. VC++ has enough graphics functions. If you want to do more in graphics programming, just google for a good graphics library. My suggestion is, consider OpenGL. :) Purusothaman A ...Show All

• SQL Server Install Sql 2005 instance with Reporting Service 2005 on Sql 2000 with RS 2000 server

  Hi We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup. If we do that then what will happen to my earlier sql 2000 reporting service Will it be upgraded to sql 2005 reporting service I heard that reporting services are instance unaware application. Where will be the default reporting service database available Please help us. Regards, Sankar N Hi, That depends on your input during the setup process. If you choose a new reporting database, a ...Show All

• Visual Studio Team System Forward integrating (parent-to-child) bug fixes always causes conflicts

  Hi everyone: I have the following branching scenario: BranchA - Version 1.0 of the product, currently in production, currently being maintained - Branch B - Version 1.1 of the product, currently under development (child of BranchA) Obviously, bug fixes in branch A need to be forward integrated into branch B. This works, but the scenario below is confusing, and can potentially cause devs to merge incorrectly: Branch V 1.0 into V 1.1 Make changes to code in V 1.1; file class1.cs Check in changes Make changes to code in V 1.0 (e.g. bug fix); file class1.cs Check in changes Merge V 1.0 to V 1.1; latest version Conflict window pops up => understandable, both versions of class1.cs have changed Merge the fil ...Show All

• Visual Studio Team System Unable to see information when user added to project administrator group

  I add three user to Builtin Project administrator group and try to loging with that user, i am not able to see any information of project and it give error that u not have enough permission on TFS. Then i made custom group and give all permission for project then everything goes fine. Can some one guide me what would be wrong Thanks for taking interest and reply. But the problem is different now I am writing in detail what I did. For more Granularity in permission we perform following steps: Create Global group on Team Foundation Server according to different role given for CMMI in the Visual Studio Team Foundation Administrator Guide. We give permission according to role on Server, P ...Show All