Archives

Archives / 2004 / March
  • Visual Studio Tools for the Microsoft Office System 2003 Training

    The training labs in this section step you through the process of creating and working with Microsoft® Office Word 2003 and Microsoft Office Excel 2003 solutions using Microsoft Visual Studio® Tools for the Microsoft Office System. Visual Basic® .NET code is used in all labs except Lab 6, which contains Visual C#® code.

  • Font with Bold and Italic

    This make me so funny when I tried to make listview’s font to bold and italic. The various default properties of node does not allow to make changes because of get methods (No Set) .Here is way how i did it. 

  • V-Days Vs SQL

    Open query analyzer and press Ctrl + T and run this below code.
    See what the magic will be happen.Thanks  Narayan.
    With regards,
    -Suresh ,Microsoft MVP .Net
    -----------------------------------------------------
    /*
    Author: Steve Kass, Drew University
    Hosted by: http://vyaskn.tripod.com
    Script works on SQL Server 7.0 and 2000
    */
    USE tempdb
    GO
    SET NOCOUNT ON
    CREATE TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26] (nbr int IDENTITY)
    DECLARE @i int
    SET @i = 0
    WHILE @i < 25
    BEGIN
    	INSERT INTO [seqA1740E61-1E21-11D6-B831-E02C0D466A26] DEFAULT VALUES
    	SET @i = @i + 1
    END
    DECLARE @heart binary(264)
    SET @heart =
      0x010b0e12220b0108100e25
    + 0x080105120a280501031406
    + 0x2a03010215042b02010116
    + 0x022c010100160201000100
    + 0x1602010001000100010001
    + 0x0001000100010101002c01
    + 0x010201002b020104010029
    + 0x0401060100270601080100
    + 0x2508010a0100230a010c01
    + 0x00210c010e01001f0e0110
    + 0x01001d10011201001b1201
    + 0x1401001914011601001716
    
    SELECT
      STUFF(STUFF(STUFF(
          R,A/256,A%256,SPACE(A%256)),
            B/256,B%256,SPACE(B%256)),
            C/256,C%256,SPACE(C%256))
    AS N'I love you/Eu te amo/Ti amo/Je t''aime/Ya vas lyublyu/Ich liebe Dich!!!'
    FROM (
      SELECT Nbr AS L, SUBSTRING(S,Nbr,2*L) AS R FROM (
        SELECT
          LEN(S+'*') AS L,
          REPLICATE(S+'*',4) AS S
        FROM (
          SELECT 'Happy-Valentine''s-Day' AS S
        ) X
      ) V CROSS JOIN [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
      WHERE Nbr BETWEEN 1 AND L
    ) W JOIN (
      SELECT
        Nbr,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-5,2)) AS A,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-3,2)) AS B,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-1,2)) AS C
      FROM [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
      WHERE Nbr BETWEEN 1 AND 24
    ) X
    ON L = Nbr
    GO
    DROP TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
    

  • Icons on Menus

    I tryed hard to get a icon on menus,unfortunatly the .Net does not gives built in support to add a icon on menu.I found one nice article on msdn.

  • IBM calls Sun's bluff over Open Source

    IBM has called Sun's bluff over open source, responding to a challenge laid down by Simon Phipps (Sun's Chief Technology Evangelist) when talking to at EclipseCon 2004 in which he asked "Why hasn't IBM given its implementation of Java to the open-source community?" by offering to work with Sun to open source Java.