Shahedul Huq Khandkar's Q&A profile

• SQL Server Unpivot Transformation Null Values

  Hi, I am trying to use the Unpivot Transformation, and I have the following mapped out, following the example from the SQL Server 2005 BOL Unpivot Transformation: Input Destination Column Subject ValueNumeric ValueString ValueNumeric Pivot Key Value RACE OTHRRACE GENDER Column Name Subject RACE OTHRRACE GENDER Data Records 99999 1 NULL 1 88888 NULL Hispanic 2 77777 2 NULL 2 Desired Output Pivot Key FALSE TRUE ...Show All

• Windows Forms New and open

  hey, in order for me to be able to do new and open options on my text program, I need to know how to make it so the program has a certain text file type for it's documents...how do you make this with Visual studio 2005 express ya, so when you press Open it opens the open dialog, then you can chose from all files, .txt, .yptf, and so on... .yptf if the main file type for my program that I want to "invent"... I dont see a FileDialog.Filter property ...Show All

• Visual Studio Team System ASP.net Unit tests and web application set up using a header.

  I have tried to use ASP.net unit tests against a web appilcation. The web applications URL looks somthing like, vdir.localhost .domain.com . IE is able to access the website, no problem. But the unit tests are unable to find the directory. I notice that none of the help files discuss testing against a web application that has been created using host headers. The question is, is it posible to test a web application using host headers If so, what might I be doing wrong Thanks guys!! Dan I'm having the same problem and would like to pickup the conversation. The problem: When I run the unit test I've created it fai ...Show All

• Visual C++ strcpy_s / strcat_s / sprintf_s

  I have found out the hard way that these functions pad the output buffer to its maximum extent with character 0xfd That's great, but could the documentation say something to make it clear this happens I'd probably recommend switching even before those functions included in Standard. For other platforms you always can write wrappers yourself, e.g. #if not defined(_MSC_VER) errno_t memcpy_s(    void * dest ,    size_t sizeInBytes ,    const void * src ,    size_t count ) {     assert( count <= sizeInBytes );     memcpy(dest, src, count); #if defined(DEBU ...Show All

• .NET Development SQL Connection Problem

  Hi, I have an ASP.NET 1.1 and MSSQL 2000 installation hosted with the same provider. Normally, I have no trouble connecting to the database, but roughly once per day, I get an exception train that starts with a 'General network error'. Mysteriously, this usually seems to happen at roughly the same time each day. My connection string and the code causing the exception are given below (values replaced by 'X'). I am sure you will agree, they are very simply; I am not trying to do anything clever. My question is fairly simple: is it normal to expect sporadic exceptions when trying to access an SQL DB in a live multi-user environment If this ...Show All

• Windows Forms Auto Generated Columns

  This feature of the DataGridView is really starting to piss me off, I optimize the positioning, labels and other aspects of my DataGridView, run it to make sure everything is ok, and when I come back to it the thing has added back 20 new unformatted columns that are exactly the same as the ones I already had. How can I disable this 'feature' DataGridView.AutoGenerateColumns = False ...Show All

• SQL Server VB.net 2005 and SQL

  Hello, I'm relitively new to the VS.net 2005 platform and need to create an SQL database for my current project to work properly, but I keep being told that I can't access the SQL Server 2005 Express to create an database. Has anyone else had this problem, and how can I get around this Thanks N. Rawe Did you install SQL Server Express during the Install of Visual Studio Even user instances need SQL Server Express as a hosting instance. See if a service with the appropiate Express name is running in the SCM. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Form Designer problem

  While using VB 2005 Express edition I periodically have a problem that occurs when I select View Designer for any one of my forms I get the following example error: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer could not be shown for this file because none of the classes within it can be designed. The designer inspected the following classes in the file frmFunctions --- The base clase 'Pw_Barcode_Scanner_v4.frmBase' could not be loaded. Ensure the assembly has been referenced and that all pr ...Show All

• .NET Development msxml6, xslt and preserving newlines

  Hello, after the upgrade from MSXML4 SP2 to MSXML6 a simple XSLT (performed in C++) does not preserve newlines anymore... I just changed the document instance creation (DOMDocument40 to DOMDocument60) and the #import (msxml4.dll to msxml6.dll). with MSXML4 SP2 my simple XSLT generated the output: alpha bravo charlie now the same code (with just the changes described above) generates: alphabravocharlie what has changed many thanks andrea Thanks Anton and Sergey, now it is easier to explain the observed behaviour using MSXML6 and using the method put_resolve ...Show All

• Visual Studio Team System Team Project Creation Failed

  Hello, We tried creating new team project but failed with the following error: Team Project Creation Failed <snipped> Error: Unable to connect to the Windows SharePoint Services at DAGOBAH Some info to further help in troubleshooting this problem: (installed in the following order) - installed SQL Server 2005 - installed Visual Studio 2005 - installed Team Foundation 2005 (single server installation) - installed Windows SharePoint Services SP2 - installed Team Foundation client - for testing purposes, we installed both the foundation server and visual studio on the same box (yup, you guessed it, DAGOBAH) - SharePoint IS running as I ca ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What the difference about IDirect3DDevice9::GetRenderTarget and IDirect3DDevice9::GetBackBuffer?

  when I finish the render, but before Present, I want to get the render result, but I don't know which function I should call. Can anyone tell me about the difference about the two functions thanks. Hi, the difference between those two functions is that GetRenderTarget returns the render target surface and GetBackBuffer returns the back buffer of the device's swapchain and these can be different. For example, you're rendering something to a render target that you'll use as a texture in other part of your scene, the render target will be that surface that holds/will hold what you're rendering right now while the back buffer contai ...Show All

• Windows Forms Build Errors - Is this a bug in Visual Studio?

  When I compile from the command line, everything builds great. But when I compile from  within Visual Studio, I get errors on a couple of files because it seems like Visual Studio is  holding onto my files and won't let go. Here is the error message I get in my Output window. The file 'ADRE.ConfigStore.dll' cannot be copied to the run directory. & ...Show All

• .NET Development Reading TextFile and execute command for SQL

  Hi. I was not sure where to post this, if it should be here or in the SQL subforum but I thought it would be here since it is an IO thing. OK, I am creating a "management" panel for a WinForms app, C# .NET 2.0 and running SQL Server 2000 SP4 Now I have generated an SQL Script from SQL to create a database. This works fine, as I have copied the text into clipboard then pasting it in the Query Analyzer, did a syntax check and executed the script, works perfect no errors. So I then save this to a textfile. My application will create the database. In order to create the database, it needs the script commands. So I u ...Show All

• Visual FoxPro VFP to show UPS tracking info.

  Hi; I have a place in my app where I populate a grid with various info including a txtbox that stores a UPS tracking #. I'd like to make this 'clickable' so it opens up a web browser to show the ups tracking info from the UPS site. I would need to do the same for fedex. I have no idea where to begin. Any pointers and ideas would be greatly apreciated. Aleniko. Aleniko, There are some foundation classes you may want to look at that are use the hyperlink control. They all have a property called lNewWindow that looks like it should do what you want if set to .T. - Just check out the Internet ...Show All

• Windows Live Developer Forums Accessing the "personal message"

  Not 100% sure what it´s called in english version but you know, the "tagline" that doubles as "now playing". (i wanna use both "now playing" and "tagline") I´ve tried looking trough APIs but sofar no luck. Anyone have any idea on how to do it As described in the linked thread , the message to send to the Messenger now omits the format part. Why did you change the spec Even if this API isn't officially supported, there are many applications using it. If you just don't support the format part in Live Messenger anymore, it's not an excuse to break the API, but you could just skip it. Regards, Thoma ...Show All