Jason D. Camp's Q&A profile

• Visual Studio Team System How do i exclude a part of the code from a .cs file?

  I'm doing unit test on native C++ projects with VSTS 2005. To get the code coverage of a DLL, I can select the DLL project for instrumentation so the code coverage is purely product code. However, for code coverage data of a static library, I must select the test project which calls the static library. The code coverage data of test project files are also included. Is there a way that I can exclude test project from code coverage result for a static library Or put it another way, to get the code coverage of product code only. Thanks. Hi Is there a way to exclude a certain part of code from the VSTS Code Coverage tool Let's say there are 3 function ...Show All

• SQL Server Writing data to OLEDb dest with the table name set via a variable. (ValidateExternalMetadata Issue)

    I am using a foreach loop, with the data from an ado recordset, which contains the table name that I wish to write data to an OLEDB data dest.  The table names are retrieved from an execute sql task in the an object var.  Within the foreach loop, for each table name, I then use a datareader to an ado.net source to pull data from that table, via an expression construct into a variable - i.e. "select * from " + @[User::table_name].  This works fine for the first table, in which mappings are setup using the SSIS design environment.  The data is retrieved.  I then use a variable and set the data access mode for the oledb destination to "Table name or view name variable".  This also saves data fine f ...Show All

• SQL Server IE7 + ReportViewer: cuts off export and zoom drop downs

  As I recall, this was a known issue that was meant to be resolved with a future release of IE7. Is there any update on this one or known work-a-round Thanks ...Show All

• SQL Server Trying to use the results of a case statement in my select list in my WHERE clause?

  I am fairly new with SQL and still learning. I have used a case statemtent for a column in my select list and want to use the results of that statement's field in my WHERE clause but it is not working for me. Here is the code I have so far: SELECT l.loanid, p.investorid, l.duedate, case when pc.duedate >= l.duedate then pc.duedate end as RateDueDate , pc.interestrate FROM loan l inner join participation p on p.loanid = l.loanid inner join paymentchange pc on pc.loanid = l.loanid where p.investorid = '12345' and RateDueDate is not null order by l.loanid, pc.duedate I want to put the results of this case statment in my where clause like highlighted above but it is not working because RateDueDate is not an actual column in the table. ...Show All

• Visual Basic PrintForm bug with MDI code

  I have an mdi application into which I slotted PrintForm. This seemd to work well until suddenly I was getting only part of the form printed or previewed. Further testing revealed that this only happens when the mdi container is NOT maximised AND the PrinterOption is ClientAreaOnly or Scrollable (or CompatModeCAO). What appears to be printed is the portion of the form that falls into the rectangle that equates to the position of the form if the mdi container was maximised. It’s easy to replicate this. - Start a new windows application project in Visual Studio - Change Form1’s IsMdiContainer to True - Make the form quite a bit bigger than the default (so there’s no implication of scrolling proble ...Show All

• SQL Server Import wizard

  Hi, I'm trying to import data from Microsoft Access. I already have all the tables in SQL Server and also the relationships, but I can't seem to import any data without deleting the relationships. Is there a way to do this without deleting them Yes, but I can not find any options for importing an Access database in the Copy Database Wizard in SQL Server 2005. Am I missing something ...Show All

• Software Development for Windows Vista Test Case 32: Is WER necessary for this test case

  I am not clear about ThreadHijacker tool to test my application.It inserts /AV in to the app. I think that there must be the code to handle the structerd exception in my app. so i am trying to use following code : #include "stdafx.h" #include <windows.h> #include "errorrep.h" static LONG WINAPI ExceptionFilter( struct _EXCEPTION_POINTERS * pExceptionPointers ); int _tmain( int argc, _TCHAR* argv[]) { DWORD *pdw = NULL; BOOL fUseGlobalExceptionFilter = FALSE; if (argc > 1 && _stricmp(argv[1], "UseGlobalFilter") == 0) { LPTOP_LEVEL_EXCEPTION_FILTER myfunc = SetUnhandledExceptionFilter(ExceptionFilter); if (myfunc == NULL){ exit(0); } // caus ...Show All

• Visual Basic Persist Treeview, How?

  I need to save a TreeView to file and reload it later. How do I do this I don't know what the data structure of a treeview is. Do I just save the fields that I use to an array and then save the array . (I'm using VB 2005) ...Show All

• .NET Development opening and reading text files

  I am new to visual c# and to programming in general. While I have taken a C++ class and have and understanding of if / else, while, for, do-while, etc., I have no clue when it comes to visual c#. Does anyone have a simple application that opens a text file (where the file name and location is entered on the form) and reads the file. Anything close would be appreciated. Ultimately I need to have an application that reads the text file, line by line, and compares it with a string that will also be entered on the form. Thanks! Hi Joseph, Ok, try this. Here's a complete example. Create a new C# project (call it ReadTextFile), drop a button and a textbox onto the form, and double click the button to take you to its event handler. N ...Show All

• Visual Basic How to control the binding navigator with VB code

  Hi, I've made a form linked to a database (by the drag and drop methods). So I have a text box for each of the columns of the database, and the binding navigator toolbar on the form. I want to use a VB 2005 code that use the primary key (numeric) of my data base to display on the form the corresponding data. For example, let say my database has 3000 costumers. I want to display the customer 2067 automaticaly when the form opens. How can I do that Thanks! I'm really new to programmation, please be indulgent! Hi, you probably have your binding navigator connected to your binding source (bindingNavigator.BindingSource). To navigate to the wanted record, try setting the bindingNavigator.Bind ...Show All

• Visual Studio Express Editions New projects fail to run

  xI created a new project today, and for some reason, when I try to run it, it exits as soon as it starts running. I've created other projects with this installtion of VB Express and never had a problem. The old projects even still work and run as I'd expect. As a test ,I created a new Windows Application with nothing in it but the default Form1, and ran it. It also exits as soon as it starts. BUT... If I double-click the exe in the debug folder, the Form1 window pops-up as expected. I even tried installing SP1 for Vb Express and that hasn't helped either. Does anyone have any idea why new projects would suddenly stop working Ok, I've done a bit more testing... I tried uninstalling and reinstalling VB Exp ...Show All

• Visual Studio Tools for Office Visual Studio Pro MSDN

  Hi I wanted to know does Visual Studio Pro MSDN have an MS Access Developers component. And do you get a run time version with the licence. What I’m after is being able to write the databases we do now without having to buy all the Team Leaders MS Access licences and just use a runtime version instead. Thanks in advance for any assistance John Thanks for your prompt and helpful Reply Cindy. Looks as if Office Proffesional 2003 may have to be set up on all the computers. Have a lovely day John ...Show All

• Visual Studio Visual Studio 2005 disapears when

  When I try to get latest code recursevely from VSS at solution level, visual studio 2005 disapears. I have to go to indivisual projects to get latest code from VSS. Has anyone experienced this behaviour Your help will be appreciated. Thanks, Ishfaq Hi Ishfaq, I haven't seen exactly this one, but if I remember correctly from similar scenarios, VS disappearing means a stack overflow somewhere, and Watson dialog doesn't even get a chance to popup and send the error report to Microsoft. I'd try following similar steps as in http://alinconstantin.net/webdocs/scc/UnspecifiedError.htm (attach a debugger, repro the scenario until you get an exception, save a minidump), then open a bug report at http://connect.microsoft.com/s ...Show All

• Visual C++ Funny Error

  Hello, I got this error when I try to view my form in designer mode: The name 'components' is already used by another object. Hide at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.SetName(Object instance, String name) at System.ComponentModel.Design.Serialization.ContainerCodeDomSerializer.DeserializeInstance(IDesignerSerializationManager manager, Type type, Object[] parameters, String name, Boolean addToContainer) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeExpression(IDesignerSerializationManager manager, String name, CodeExpression expression) at System.ComponentModel.Des ...Show All

• Windows Forms DataGridViewTrackBarColumn?

  Hello all, I want to put a trackbar in a datagridcell of datagridview. The trackbar must be visible in both editing and nonediting mode. Is possible Best Regards Sandro Peixoto Sure it's possible. Here's a tutorial on how to host a calendar control: http://msdn2.microsoft.com/en-gb/library/7tas5c80(VS.80).aspx And one for a numeric up down control: http://msdn2.microsoft.com/en-us/library/aa730881(VS.80).aspx I think those should get you started. ...Show All