Friday, June 7, 2013

Test Highlighter

<ul class='maketea'>
<li>Tea</li>
<li>Water</li>
<li>Sugar</li>
<li>Milk</li>
</ul>
IF OBJECT_ID('dbo.test') IS NOT NULL
    DROP TABLE dbo.test;

CREATE TABLE dbo.test
    (
      id INT PRIMARY KEY
    , prodName VARCHAR(20)
    );
Dim fileName As String = "C:\mydir\test.txt"
SELECT CASE Row.dayNoOfWeek
            Case 1
                Row.NameOfWeekDay = "Sunday"
            Case 2
                Row.NameOfWeekDay = "Monday"
            Case 3
                Row.NameOfWeekDay = "Tuesday"
            Case 4
                Row.NameOfWeekDay = "Wednesday"
            Case 5
                Row.NameOfWeekDay = "Thursday"
            Case 6
                Row.NameOfWeekDay = "Friday"
            Case 7
                Row.NameOfWeekDay = "Saturday"
END SELECT
public override void Input0_ProcessInputRow(Input0Buffer Row)
    {

        switch (Row.dayNoOfWeek) {              
            case 1: Row.NameOfWeekDay = "Sunday";       break;
            case 2: Row.NameOfWeekDay = "Monday";       break;
            case 3: Row.NameOfWeekDay = "Tuesday";      break;
            case 4: Row.NameOfWeekDay = "Wednesday";    break;
            case 5: Row.NameOfWeekDay = "Thursday";     break;
            case 6: Row.NameOfWeekDay = "Friday";       break;
            case 7: Row.NameOfWeekDay = "Saturday";     break;
        }
   }

No comments:

Post a Comment