apierre's Q&A profile

• SQL Server Left Outer Join versus Subquery

  Hello Chaps, I have got question about the performance of subquery and left outer join My scenario is that  I have two tables Customer Mater and address book. Customer Mater and address book  tables hold the record for both carrier and customer. and i want retrieve the record for customer and related carrier as well i have two options 1.  either use left outer join (i.e. Join Customer master to Address Book 2 times, 1 for customer and 1 for carrier) by:        Address book (as customer) Left outer Join Customer Master (on related Key)       AddressBook (as carrier) Left Outer Join Customer master (on related Key) 2.or use 1 join for customer ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture transforms do not appear to be applying translation.

  I am using Direct3D 9 with VS 2003. I have a program where I need to set texture transforms with a scale and a translation components in them. When I check the results of the texture transform using ProcessVertices, only the scale value appears to be applied. Is there something I'm missing about texture transforms Do I have to supply a four component texture coordinate so the w component is around for the translation I currently only specify two component texture coordinates and expect the w = 1 to be implied. With 2D texture coordinates I believe the input to your transformation matrix is actually (u, v, 1, 0). There's actually a small example of using texture transformations to do translation in the SD ...Show All

• .NET Development clone DataReader

  Hello all, I need to loop through DataReader two times, but the second time, I can't read it because it has no row. Here is my code Dim dr as DataReader 'Connect to database and retrieve rows of data Do While dr.Read() 'Process some reading rows of data Loop Do While dr.Read() 'This time the DataReader has no row here Loop So my question how can I process DataReader by using Read() again Do I have to clone DataReader If so how Thanks A datareader usually represents a forward only, read only cursor. You will not be able to use a datareader how you describe the code. I can imagine a few options. Consolidate the iterations to one using a single datareader Load a dataset/datatable in ...Show All

• Visual Studio Team System What WeightedMethods means?

  Hi Friends What WeightedMethods metrics means Someone knows an URL about this Thanks in Advance Washington Moreira Hi, The weighted method metric means the no of methods you implement in a Class. The metric is you should have very less amount of methods. This increases the maintenance costs of a class. Regards, Ajeeth. ...Show All

• Windows Forms Repeater display five rows

  I have Repeater control in my web project and there is a select query that filling the repeater. I want to display only 5 rows in repeater. How can I solve it Not: "Select (Top 5)" is not working that using Access data source. thanks. ...Show All

• Software Development for Windows Vista Differenciate Vista 32-bit and vista 64 bit

  How can I differenciate Windows vista 32-bit from windows vista 64-bit, using GetVersionEx Is there preprocessor define I canu use for that purpose Thanks, it is very useful but if I run vista 32bit on a x64 processor, I will not get the right OS version. Any idea how I can differenciate Vista 32-bit and Vista 64-bit on a 64-bit machine ...Show All

• Smart Device Development How to form a bitmap image in compact framework

  hi all... i am developing an appliction in which i am drawing some rectangles & lines along with some text. I am using .NET compact framework. But whatevr application i have developed it is showing some flickering problem. So can anyone tell me how to remove this flickering. If we form a bitmap image from the rectangles, lines & text then i think we can remove this flickering. So can anybody tell me how to form a bitmap image at runtime in .NET compact framework. Thanks, vinay Ya... but the text whixh i am displaying is changing at run-time. So i have to refresh the screen & redraw the lines & text... Any other way i can avoid flickering... Vinay ...Show All

• .NET Development Encrypt+Config+Section

  static void Main() { //other code // Protect the Connection Strings ProtectConfiguration(); Application .Run( new MainForm ()); } static void ProtectConfiguration() { // TODO: Protect the Connection Strings string provider = "RsaProtectedConfigurationProvider" ; Configuration config = null ; config = ConfigurationManager .OpenExeConfiguration( ConfigurationUserLevel .None); ConfigurationSection section = config.ConnectionStrings; if ((section.SectionInformation.IsProtected == false ) && (section.ElementInformation.IsLocked == false )) { // Protect (encrypt) the "connectionStrings" section. section.SectionInformation.ProtectSecti ...Show All

• SQL Server Getting T-SQL code for a stored procedure

  I need to have my middle tier code get the T-SQL code for a stored procedure. So, I need to create a string something like: string tsqlCode = @"CREATE PROCEDURE \"NSInsertGenerator\"   @GeneratorName      NVARCHAR(255),   @SystemName         NVARCHAR(255),   @ThreadPoolSize     INT,   @ActivationState     TINYINT AS INSERT INTO \"NSGenerators\"       ( GeneratorName,  SystemName,  ThreadPoolSize,  ActivationState) VALUES(@GeneratorName, @SystemName, @ThreadPoolSize, @ActivationState) GO" This string will be analyzed by the middle tier code so that the list of paramet ...Show All

• Visual Studio 2008 (Pre-release) IIS 7 & WAS

  Hi there I just want to find out if my understanding of IIS 7 & WAS (Windows Activation Service) is correct. Does this mean that it is possible to host a WCF service using a NetTcpBinding binding in IIS 7 Thanx in advance Edwin Loubser Yes; with WAS, non-HTTP protocols can leverage the activation mechanism that's usually available only to HTTP protocols. Basically, think of it this way, the code for activation was separated out and made protocol independent. WCF leveraged it by adding extensions for TCP, Named Pipe, MSMQ. You can also write your own protocol - there's a sample in the SDK that shows one for UDP. Steve, who was the Program Manager for WCF activation has a nice wr ...Show All

• Visual C++ Access to the timezone database

  Hi all, is there an API to access the OS's timezone database (like offsets from GMT, DST rules etc.). What timezone names are used, where do I find documentation about it (i.e. the API, not tomezones in general) cheers, aa Simple Samples wrote: The Windows timezone data is in the registry. About a decade ago I spent a few days trying to figure it out but since then someone wrote an article in a magazine describing it. Hopefully it has since been documented by Microsoft. So look in the registry; if you can't find it I will look for the registry key. When you find it, you hopefully can search the MSDN to find the documentation or the internet to find the article. A few days ago I was looking in the MySQL web site and saw som ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problems with MDX 2.0

  I have been programming in Managed DirectX for some time now and my programming has been coming along nicely. Recently, however, I am having considerable trouble with the new Managed DirectX 2.0. The most infuriating thing is that i have no idea what the problem is, my code compiles fine and there are no runtime errors and the device will present. My problem is that it wont render any verticies. Here is my source code: PresentParameters pp = new PresentParameters(); pp.IsWindowed = true; pp.SwapEffect = SwapEffect.Discard; _device = new Device(0,DeviceType.Hardware,this.Handle,CreateFlags.HardwareVertexProcessing,pp); this.SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.Opaque, true); _buf = VertexBuffe ...Show All

• Software Development for Windows Vista Bugcode_USB_Driver error w/USB devices attached

  I just completed installing Windows Vista RC1 on a VMWare 5.5 machine, and everytime I power down Windows Vista when USB devices are attached, I get a BSOD with the Bugcode_USB_Driver error. If I remove the USB devices before powering down, which include a Intellipoint Explorer wireless mouse and a portable storage devices, the BSOD/error does not appear and system shuts down just fine. The following message appears during subsequent startup. Problem signature: Problem Event Name: BlueScreen OS Version: 6.0.5600.2.0.0.256.1 Locale ID: 1033 Additional information about the problem: BCCode: fe BCP1: 00000008 BCP2: 00000006 BCP3: 00000009 BCP4: 837DD5CC OS Version: 6_0_5600 Service Pack: 0_0 Product: 256_1 I get an "Access Denied" e ...Show All

• Windows Forms How do I reduce flickering for a DataGridView when AutoSizeColumnsMode is Fill?

  When the DataGridView.AutoSizeColumnsMode is set to Fill the contents of the grid flickers when the grid is resized. Is there any way to reduce or remove the flickering Solved it by setting the protected DubbleBuffered property to true in a class inheriting from DataGridView. Is this the intended way Why not make the property public if it is needed to make the grid redraw itself without major flickering ...Show All

• Visual Studio Team System TFS Setup failed with "Error 28925.TFServerStatusValidator: Calling the Team Foundation Server ServerStatus Web service failed."

  I am installing on Single Server topology. Everything same as mentioned in installation guide apart from default port 8080. This port was already used on server so I changed the port setting in "msiproperty.ini" file to 8090. During setup, I am getting following error: --------------------------- Microsoft Visual Studio 2005 Team Foundation Server Setup --------------------------- Error 28925.TFServerStatusValidator: Calling the Team Foundation Server ServerStatus Web service failed. Additional details about the problem can be found in the setup log. Verify your network configuration. For more information on troubleshooting this error, see the Microsoft Help and Support Center. Log file: TFServerStatusValidator - Team ...Show All