Chuck McD's Q&A profile

• SQL Server Convert numbers to Month Name

  I have a stupid field in my database that doesn't hold a date but I have to use it to determine the month in my Chart in SSRS 2005. So for example, check this out: http://www.webfound.net/chart_months.jpg Ok, so how can I change those numbers to the Month Name I tried MonthName() around my field in the expression builder, but that's only for a datetime field. Write a UDF with input as int month and return it as varchar month. Use ...Show All

• Visual Studio Team System TFS Source Control History Tags?

  We recently switched our source control from Source Gear Vault to TFS. One feature that I haven't figured out in TFS is the special special tags feature that allows the source control to add history and other info in the source file. Example from .sql file: /*-------------------------------------------------------------------------- * $History: /vsln/path/filename.sql $ ****************** Version 9 ****************** User: bob Dat ...Show All

• Visual Basic VS 2005: How to run Sample "How to: Create Appointments "

  I did a ful install of VS 2005 Pro, created a new project (VB, Windows App), pasted the code from " How to: Create Appointments ", added Reference to Outlook 11.0 Object Library but still get errors: Outlook is not declared, Outlook.Recipient is not defined What do I miss Private Sub AddAppointment()    Dim newAppointment As Outlook.AppointmentItem = Me.CreateItem (Outlook.OlItemType.olAppointmentItem)    &nbs ...Show All

• Windows Forms Menus and Toolbars

  Does anyone know how to change the colors of the menus and toolbars to represent the silver XP style, without changing the display settings through windows xp I know how to, but what are teh colors The colors are actually hard coded into the ProfessionalColorTable class and so all you need to do is use the .NET Reflector tool to see the values in the table within that class. Or to do it the hard way just write ...Show All

• .NET Development Write Text File with the same Culture

  Hi, I developed a windows form application which writes a txt files with portuguese words with accents. The applications was developed in Windows XP in english and it writes the file correctly. But, when it runs in Windows 2000 Portuguese, the portuguese words have the accents changed to ascii simbols. How to fix it Regards, Marcelo. You need to install the font file in the machine under %System32%\fonts. You probably got the fon ...Show All

• Visual Studio Express Editions mp3 tag - reading out and changing information of mp3-tag

  Hello to all! I want to ask you: How can I read out information of a mp3 How can I change the mp3 informations Thanks I recommend the use of the .NET Library available at: www.id3.org Its relatively easy to implement and use. heres an example of how to use it: Imports HundredMilesSoftware.UltraID3Lib 'this will implement the dll for use Private m_FileName As String ...Show All

• Visual Studio 2008 (Pre-release) Error while trying to serialize Cyclic Dependencies

  I have a following cyclic dependencies between two classes in my object graph: [DataContract] [KnownType(typeof(Person))] public class Company {     [DataMember]     private IList employeesList;     private IList EmployeesList     {         get         {          &nbs ...Show All

• Windows Forms i found it. Here it is if anyone wants to know.

  I need to return the CD rom drive so I can copy data off of it. i dont want to prompt the user for the drive. How can I do this in .Net  Thanks Malcolm Okay it's pushing 6:00 AM here and I can't figure this out. Yes as a matter of fact I'm brand new to Win ...Show All

• Windows Forms ListView - OwnerDraw + Background

  I need an OwnerDrawn ListView plus a custom background. SetStyle( ControlStyles .DoubleBuffer, true ); SetStyle( ControlStyles .UserPaint, true ); SetStyle( ControlStyles .AllPaintingInWmPaint, true ); ...works, causing OnPaint and OnPaintBackground to be called. Have used this frequently. Trying to use the new .NET 2.0 OwnerDraw feature, however, causes problems. Adding this .OwnerDraw = true ; Causes OnDrawItem to be c ...Show All

• .NET Development Passing Dictionary in WebService

  I tried to pass Dictionary as a return value of a webservice Here's a snippet of the code:    //I marked BL.Customer class as serializable.    [Webmethod]     public Dictionary<string, BL.Customer> GetAllCustomer()     {         Dictionary<string, BL.Customer> customers = new Dictionary<string,  BL.Customer>();     &nbs ...Show All

• Visual FoxPro How to using Microsoft Office Chart 10

  Hi, Please help me ... How to using olecontrol microsoft office chart 10 in visual foxpro. How to define data type, data series and others. Madces ...   Akhmad wrote: Please help me ... How to using olecontrol microsoft office chart 10 in visual foxpro. How to define data type, data series and others. Ted Roche has written a paper on using Chart at http://www.tedroche.com/Present/2003/ADX304.html - hopefully that will help ...Show All

• .NET Development some suggestions

  HI guys. I was wondering how I could send some suggestions about the .net languages. Since the new version is gonig to be released very soon, I was wondering if I could pass these comments to the dot net dev team. Does anybody know any email addresses any web forms There are two issues anyways, which are listed below. Please do not hesitate to contact me. Thanks. /Ali Please contact ali at jannatpour d0t c0m; (please do not spam) ======== ...Show All

• SQL Server Programmatic generation of History snapshots with varying parameters

  When you call CreateReportHistorySnapshot it generates a snapshot of the specified report with only the default parameter values. How would I generate snapshots based on parameters specified at runtime I've done this before using a Linked Report. If you first call CreateLinkedReport() you can pass in the properties for the Report. Then Create a Snapshot of that. If that is not enough to get you going let ...Show All

• Visual C# Add "Help" button

  How can I add "Help" button to my forms Like the picture: http://img.majidonline.com/thumb/39010/Untitled-3.gif Where is the picture Where and how you want to have Help implemented ...Show All

• Visual C# How to Show Code Line Numbering in the Editor?

  How to Show Code Line Numbering in the Editor to show like this 1 2 3 4 5 6 7 etc.. i am using VS 2005 C# express August ...Show All