Pages

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