sbussinger's Q&A profile

• SQL Server Using CASE statement within GROUP BY

  Just a simple question, is it possible to somehow assign an alias to a case statement so that it does not need to be repeated within both the SELECT and GROUP BY clause For example... SELECT CASE WHEN Order_Date IS NULL THEN 'Unknown' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 0 AND 6 THEN 'Recent' WHEN DATEDIFF(mm,Order_Date, GETDATE()) BETWEEN 6 AND 18 THEN 'Old' ELSE 'Ancient' END AS Recency, count(*) FROM Ord ...Show All

• Windows Forms Can I display any text on RowHeaders in the DataGridView?

  I want to display time on all RowHeaders of DataGridView, I'm using VS2005. Loop through the rows to set text for the row header cell would be only work when the DataGridView is first populated, however, if ordering is applied, the row header text would disappear, so it's better to handle CellFormatting event, as, Code Snippet void dataGridView1_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) ...Show All

• Windows Forms Calculate Width of a String in Pixels

  hallo, Given a Font and a string, is there any ready-to-use function in .NET which can compute the resulting width of the string in pixels So that I can adapt say a Label, MenuItem or Textbox to the new size of a string. thx, Steve ...Show All

• Windows Forms DataGridView and Context Menu

  Hi, I have a DataGridView and a ContextMenuStrip associated with it. On right clicking the grid, the ContextMenuStrip is displayed. I want to control which items in my menu are enabled/disabled. For this I have to know which row was right clicked. Which event handler will I have to use for this Regards, Kunal ...Show All

• .NET Development About Encoding Problem in getting pop3 message(data)

  . i am a newbie please help me) When i get pop3 message like below: and how to display the message to Big5 format ., And why when i display the data like below from pop3 server on a label and a textbox both have different style ,in text box the message is very tidy,different type of data in different line) but in label all meaasge is combin together and no any alternate lines,and i cant split the message with text.split(vbcrlf) or text. ...Show All

• .NET Development Code not working on German OS

  We have a dll which was developed on English OS of windows. When I try to run the same dll on the German OS for windows I am facing following problems. The GetTickCount() function returns 0.00 . Also the PdhCollectQueryData() function returns PDH_NO_DATA. However when we change the language settings on German OS to English the code seems to work properly. Please let me know if anybody has faced similar problems before. Thanks  :) ...Show All

• SQL Server How to attach an .MDF file to another server?

  Hi all I am having trouble moving an .mdf file from a dev machine to a production machine. On the dev machine(windows xp sp2 login <MyName>) I have an SSE instance - part of VisualStudio installation.  on the production machine I have only one full version SS instance called "PROD"(windows server 2k3, login Administrator) I do have SSMS installed too. I create a website in VS on my dev machine. C:\Websites\W ...Show All

• .NET Development FTP to IP address

  I need to send a text file on the local machine to a unix server. I know the IP address, username & password to connect. I have tried using the following line of code: My .Computer.Network.UploadFile( "c:\test.txt" , "10.2.2.10" , "username" , "password" ) This gives me the following error: '10.2.2.10' is not a valid remote file address. A valid address should include a protocol, a path a ...Show All

• Software Development for Windows Vista program manager

  is there more than one program manager @ MSFT that's responsible for WWF I've seen at least 2 names already. There are several program managers on the team (I believe 10-12 off the top of my head).   James Conard Architect Evangelist - Windows Workflow Foundation http://www.WindowsWorkflow.net http://blogs.msdn.com/jamescon     ...Show All

• SQL Server Database restores using Enterprise Manager

  Good afternoon. I am using MS SQL 2K and was wondering if it is possible to restore multiple back-up files (database and transaction logs) to a database, if you haven't created a back-up set, using Enterprise Manager. I know that you can write T-SQL to first restore the back-up file and each of the transaction log files, except the last one, with the option of norecovery, and then the last transaction log file, with recovery. Any help would be g ...Show All

• .NET Development How to detach properly using SQL Server Express?

  Does anyone know of a good pattern on how an application should detach (preferably using a managed SqlConnection) Is there maybe a connection string property that auto-detaches when the connection is closed Here is how far I got: It’s easy to attach a database file in the connection string using AttachDbFilename . And that file gets closed when all connections to that database are closed (one might have to clear the conn ...Show All

• Visual Studio Team System Error 28940.TFServerStatusValidator: Calling the Team Foundation Server ServerStatus Web service failed with 503 HTTP

  >>>> Error 28940.TFServerStatusValidator: Calling the Team Foundation Server ServerStatus Web service failed with 503 HTTP ServiceUnavailable status. Verify that Internet Information Services, Windows SharePoint Services, and ASP.NET are configured correctly and that ASP. NET v2.0 Web Service Extensions are allowed . For more information on troubleshooting this error, see the Microsoft Help and Support Center. <<<< I t ...Show All

• Visual Studio Team System How can I find out what my team has checked out?

  I am a team leader and new to TFS-VC. I am familiar with the Pending Changes window to show what I have checked out, but how can I find out what the rest of the team has checked out I’m looking for something equivalent to the old SourceSafe “search for status” dialog, that allows you to view either all checked out files or those checked out to a particular user. Also, I have seen the command-line statement tf /status /user:* and ...Show All

• .NET Development Accessing a client id from within a web service

  Hi I am using Visual Studio 2005 with VB 2005 and investigating Web Services. I have a VB client application that accesses a Web Service. This works fine, but I would like to know if there is a way to obtain some kind of unique id/reference of the VB client application from within the Web Service. I would like to save this id/reference somewhere (possibly in a file or database) and then, when the Web Service responds back to the client ...Show All

• Visual Studio Express Editions C++ or C#

  Whats the difference Is one better then the other. It probably depends so say I want to make games, which I do, but Im a newb to C++ so thats a long ways from now. Ive been learning about C++ and taking tutorials, but should I be using C# You can use C# but i want to share my experience regarding language performance differences. Once i had to built a very complex application which contain a module to do ...Show All