Puzzled's Q&A profile

• Visual C# To _, or not to _?

  The .NET Framework is littered with private variables preceeded with the _ (underscore) character. Is this good practice Or something Microsoft are trying to stamp out Michael, your reply was a rather laborious, waffle-ish and what some my consider "offencive"... However , [despite your unfortunate manner], you make a good point that the naming of private variable/fields/methods is down to personal preference. Well said! ...Show All

• Smart Device Development file browser for Smartphones

  i want to use a open file dialog in my smartphone application, can somebody temme how can i do tht as the normal GetOpenFileName func is not working for Smartphones. GetOpenFileNameEx is implemented in WM5.0 Smartphones. There is also a third-party GetOpenFileName implementation here:- http://www.tillanosoft.com/ce/tgetfile.html Peter ...Show All

• Visual C++ debug assertion dbgheap.c line 1017

  In general you cannot mix debug and release version of dlls/exe. Doing so results in using different versions of MFC and CRT dlls and this does not work properly. ...Show All

• Visual Studio Team System Database Pro requires local SQL 2005 instance???

  Some of the guys on our team are currently using VSTS for DB Pros.(version 2.0.50727.145) It was installed on a machine where there's a local instance of full SQL 2005. (It installed SQL Express too. We successfully can point it at the full version of SQL) We are going to remove SQLExpress and we don't want people creating DEV db's on this box. Is there a way we can point to another SQL instance on a different machine I think the answer to this question is no, atleast in the most current release. Any idea if this will change in a future release Thanks, Ron RGrizzzz wrote: I want to change that setting to point at a different database server.(Not the local machine) That setting s ...Show All

• SQL Server I couldn't find TRIM function

  Hi, I found rtrim and ltrim functions, but I didn't find trim, so should I use rtrim(ltrim(' a ' )) Am I right cheers, Alessandro Camargo ...Show All

• SQL Server error code from DTEXEC not 0 nor 1

  I would like to send back to MS-DOS (ERRORLEVEL) an error code 2 ( different from 0 and 1) via a scripting Task. Our package are started with the DTEXEC Utility. In general, how can i send back a flag saying "There were warnings" during the execution of a Package Warnings can happen with successful package executions, and for that matter, so can errors. There are a numerous ways to figure out there were warnings though, such that a shell caller is aware of that fact. One, capture the console output from dtexec and look through the captured text for the warning event. Two, create a console utility which calls Package.Execute() and iterates through the .Warnings collection. If the count > 0, return what you wan ...Show All

• SQL Server Remote access to sql server

  Hi, I use a VS2005 application with a sql database. All is working well over a local network but I now want remote access to the system via the internet. Is this possible I have a fixed IP address & am wondering if I can just use the ip address as part of the connection string (And if so - how!) GraemeP wrote: I'm trying to do a mixture I think.. Currently I have a string set that's called "ConnectionString", I can see that I can add other strings and then call the one I want, however my confusion is: - As I don't have a "call" in the project at the moment, I presume that somewhere there is a system "call" that selects this string If I add another st ...Show All

• .NET Development Using "unique" with "field xpath=" value being variable instead of fixed

  Hi, I have a case where my "unique" identifier field name (in an xsd) can take on different values (based on another value in the xml). My case is validating people--which can either be identified by a Social Security Number or a UniqueId. I’d like the xsd to validate based on the SSN or UniqueId specified in the xml. HERE'S THE "FIXED" CASE (which works fine for validating against a fixed field name – SSN in this case): For a "fixed" case (where only SSN is the unique value): [xsd fragment] <xs:unique name="ProfileUnique"> <xs:selector xpath="Profiles/Profile"/> <xs:field xpath="Ssn"/> </xs:unique> ...Show All

• SQL Server Change page title from "Report Viewer/Manager" to the actual report name?

  Can a person change the page title from "Report Viewer/Manager" to the actual report name Yea, that's a possibility, but not do-able for 50 separate reports :/ Maybe there's some hack to set the page name that's shown by default ...Show All

• Visual Studio Express Editions hide tab header

  how do I hide tab header of each tab in tabcontrol I would like control browsing of each tab myself . rgds, charles If you permanently want to hide the tab headers, don't use a TabControl, just use a set of Panel controls. Start out with all Panel.Visible = false except the first one... ...Show All

• Visual FoxPro Dot matrix printers with Visual Foxpro

  Hello all, We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part. Can anybody offer the solution Thanks in advance Open your word document, type some Chinese. See if you have fonts to select, like Kaiti, Songti. Try to send to your dotmatrix printer. If you cannot see regular characters, you have to install a Chinese software. Also test if you can print a Chinese document on a laser printer. ...Show All

• Windows Forms Combobox Autocomplete not recognizing certain characters

  I am having issues with the autocomplete functionality in combobox in Framework 2.0. In particular, certain characters are ignored when the user types them or stop autocomplete from finishing the entry when they are encountered in the list. Case 1: The user types & or q when there is a match in the list. In this case, the character does not display in the text box portion of the combobox. If the autocomplete mode is set to SuggestAppend, the suggest list is filtered by that character. If the TextChanged event is handled, it is evident that the character was in the text box initially but was removed at some point after the event initially fires (and it appears to be in the autocomplete code). I am not certain this is the autocompl ...Show All

• .NET Development direct network traffic to specific network address

  I am developing software for a machine which will have 2 internet connected network interfaces. The first is a DSL broadband connection, the other is a GPRS wireless connection. How can I prevent ALL applications running on the machine from sending and receiving packets over the GPRS connection, except for the specific application I am writing The ideal solution would be to only allow packets being sent and received from a specific IP address on the internet, to pass through the GPRS connection, but everything else goes over the DSL... Any ideas Thanks Alter the routing table the artical at http://www.realdn.net/msblog/PermaLink,guid,864b265c-1615-43bd-81af-de13b5fda780.aspx seemed quite infor ...Show All

• SQL Server Help with Join Syntax

  I have a query where I need to join a table to multiple tables and alias a field from those tables on each join. I tried the syntax below but received a error. Please assist, first time trying to do this. JOIN dbo . AbsenceReason ar ON ar . AbsenceReasonID = sda . AbsenceReasonID WHERE ar . [Name] = 'DailyReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = spa . AbsenceReasonID WHERE ar . [Name] = 'PeriodReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = cio . AbsenceReasonID WHERE ar . [Name] = 'CheckInOutReason' error I receive is : Msg 156, Level 15, State 1, Procedure p_000001_GetAttendanceProfileData, Line 45 Incorrect syntax near the keyword 'LEFT'. Msg ...Show All

• Visual Studio Code and Build metrics with MSBuild

  Hi all, I am new to MSBuild and I am trying to gather various build metrics (such as number of errors/warnings, historical build success measures, etc.) . I also want to format the output from the logger (hopefully a pre-built one) in a structure which cuts out the redundant information but leaves the relevent information, perhaps in XML I also need various code metrics such as No. classes, lines, comments, % of comments, etc. I find MSBuild easy to use but if I could find a way to do all this it would be perfect! Is there anyone out there who knows how do do these things or knows which utilities are needed to do so Any help greatly appreciated! cheers! You can use Exec tasks to run your code coverage program of choice such as NC ...Show All