Hooper's Q&A profile

• Visual Basic Easy question: How to avoid stepping into DAAB when debugging

  Hi, I'm sure this is an easy question to answer for someone that has a better understanding about how debugging works in Visual Studio (2005). I've been trying to figure out how to avoid stepping into the DAAB (Enterprise Library Data Access Application Block) when debugging. I have "Just my code" enabled, and I am referencing the compiled versions of the DLLs (i.e. I don't have the DAAB source added to my solution), yet somehow it still steps into the DAAB  when I am pressing F8 to step through the code. Of course, I can hit Shift-F8 at the appropriate times to step over those lines instead of stepping into them, but I would like ...Show All

• SQL Server execute SSIS package stored in remote SQL server from a client machine.

  I have written a VB component to execute a SSIS package stored in SQL server. I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand and executereader and everything works perfect on the local machine. This is descibed in a msdn site . But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL server. My question is: Can you still use dtsclient or do you have to do in some other way rose-marie It depends where your VB component is going to be running. ...Show All

• .NET Development Handling .NET Exceptions in VB6

  Hi, I have a question regarding how VB6 handles Exceptions raised from a .NET component. This is the scenario: I have a legacy VB6 app where I am writing some new functionality in a managed assembly and accessing it through COM. Now in the VB6 code is used On Error GoTo extensively and there are places where it is responding to data access errors - the kind that come from a SqlServer stored procedure. Specifially an SP performs a Raiserror(50000,16,1) and the VB6 code (inside the error routine) handles the Err.Number when it is 50000. My .NET component replaces this direct call to the SP but I wanted to keep the VB6 code as it, i.e. still re ...Show All

• Windows Forms O/R mapping tools

  Hi guys, ADO.NET provides dataset/datatable so that you can store your data you get from databases in your code. But some deem dataset/datatable are not 'real' objects and they don't fit into the object paradigm. (Agree ) So those ppl use O/R mappings tool like ORM.NET. My questsions is do you guys use these kinds of things Michael Cool. Hibernate ...Show All

• .NET Development How do I access the comment on a picture file?

  I'm trying to access the comment on a picture file (when you right click a pic, properties, summary -> comments). I need to know how to do this in VB.NET (preferably the 05 beta 2 version) thanks DAVE Thank you for the question. Thank you for the replies. I have succeeded in this but can't save the altered file. I have worked around it but wonder if there is a better way, and also wonder if the file format resulting is still 100% uncorrupted. The way I have used is open the file as file stream make the alterations save the altered file as temp.jpg - img.save("temp.jpg") close the file stream open ...Show All

• SQL Server Parameters in URL - Problem

  Hi, I am new to Reporting services and have managed to create some reports. I want to pass some parameters in the URL to the report. I know how to do this but some parameters are not passing to the parameter boxes. They are clearly displayed in the URL but are not populating the boxes. I have one report done before i came and this used to work but now it doesnt work. Any ideas Matt http://msdn2.microsoft.com/en-us/library/ms153586(SQL.90).aspx ...Show All

• Visual Studio Team System DoNotCastUnnecessarily

  Hello, Im trying to fire this rule: DoNotCastUnnecessarily using the example in the documentation, but the rule doesnt fire: using System; namespace PerformanceLibrary { public interface IWork { object DoWork(); } public class Work : IWork { object IWork.DoWork() { return 3; } public int DoWork() { return 3; } } public class NeedsWork { public void WeaklyTyped() { IWork iwork = new Work(); // The following call violates the rule. int x = (int)iwork.DoWork(); } public void StronglyTyped() { Work work = new Work(); int x = work.DoWork(); } } ...Show All

• Visual C# What should be the best practice to check the object ?

  Hi, Normally we check a value by this format if ( obj == null ) { //do some code } I know it is good for readability. But for performance reason I am suggested by one of my coleagues that we shuold check the constant value first i.e. if ( null == obj ) { //do some code } What is the best possible way to check the object Could any body give the proper reason to use the later one. your coleagues seem to be wrong :) here the result of my little test :) Left u have (obj == null) right u have (null == obj) There are the time results for 1.000.000.000 checks Object not null 0: 00:00:06.6562500 - 00:00:06.8125000 1: 00:00:06.73 ...Show All

• Visual Studio Express Editions C#: Some equivalent to JavaDoc?

  Hi. I'm a Java developer and I'm in the process of learning .net. There is some kind of documentation generator like JavaDoc Regards. http://ndoc.sourceforge.net/ There are some JavaDoc-like templates, too ...Show All

• Visual Basic Create activex control in vb.net

  I need to create a personal control that work in vb.net and in other plataforms, for example vb6. Because i don't want to have two control one in vb6 and other in vb.net i would like a create a control in vb.net that I can use in vb6. Please any have idea Can i giv e a simple example to do this Very Thanks Excusme for my english, i speek Spanish Hi, I guess the right approach here is to create an activeX control in VB6. Coz VB.Net can also import ActiveX control. Thus you don't need two controls on each platform...     cheers, Paul June A. Domag ...Show All

• Software Development for Windows Vista FaultHandler on State Machine (Beta 2)

  Hi. Can anyone point me to (or send me via email <removed by the post author> an example for a State Machine WF (Beta 2) using the FaultHandler activity. I tried using this activitity on a State Machine WF (Beta 2) but I can't find a place to drag into. Any help is welcome. Joao Lopes Joao - you can use the FaultHandler inside of a FaultsHandlerActivity - you can get the FaultsHanlderActivity to be visible in the designer by highllighting any compositeactivity derived activity - and either right-clicking or going to the description part of the property grid and clicking on "view ...Show All

• Visual Studio .Net Framework CANNOT uninstall or reinstall

  Hi All, My .Net Framework 1.1 does not give me the option to repair. I tried to reinstall, but it did not work because it gives me a message saying that I already have the current version installed. I'm trying to uninstall previous version of .Net Framework before doing a clean install of SQL Server 2005. When I tried to uninstall in Add/Remove, the following file it asked for, and I don't think it is on my harddrive - tmp1DD.tmp - any help that I could manually remove .Net Framework, I would appreciate it!!! or a tool that I can manually run to uninstall all files associated with .Net Framework, I would really apprecate that! Sincere ...Show All

• Smart Device Development Make WM5.0 device barebones?

  I have a dozen WM5.0 smartphones using both the regular lithium ion battery, and a secondary SLA battery, being used as product prototypes for a wireless application; our final WM5.0 device is going to have a dedicated circuit board, CDMA/GSM/etc. combo modem, no screen, etc. etc. In the meantime, however, I'd like to strip my WM5.0 prototype devices to the bare minimums needed to function in order to extend battery life. Can anyone point me in a direction as to how I might best accomplish this, short of manually terminating processes prior to deployment This sounds like an interesting projec ...Show All

• SQL Server 2 independent Column Groups in a matrix?

  Is it possible to get 2 independent column groups in a single matrix Let's take Adventure Works Cube as an example. Row grouping: [Date].[Calendar year] Columns: [Geography].[Country] and [Product].[Category] Measure: [Sales Amount] Idea is to see sales numbers for each year distributed by country and product category in a single row (empty cells possible). Groups and subgroups isn't an option. So is it possible with RDL and Reporting Services at all Regards, Andrei. I assume you want to group by Country and Category (independently) on columns. (if the data from the query is already grouped, then you c ...Show All

• .NET Development What's wrong with this access query? Query Builder doesn't like it?

  I am configuring a Table Adapter using following access query. This is an exact copy of the query that is saved on the access database. Now the Query Builder is complaining about Error in list of function arguments: 'IS' not recognized. Error in list of function arguments: '=' not recognized. Unable to parse query text. and Undefined function '[Year]' in expression what am i doing wrong here's the query SELECT CD.CompanyCode, CF.CompanyKey, CF.PeriodEndDate, IIF(CF.AnalystDate IS NULL, DATESERIAL(YEAR(CF.PeriodEndDate),MONTH(CF.PeriodEndDate)+2,DAY(CF.PeriodEndDate)), CF.AnalystDate) AS [Analysis Date], CF.MonthEndClose * CF.OrdinaryShares ...Show All