gadgets for your t.v!

Watch and control your favorite TV shows over the Internet from anywhere in the world—whenever you want—on your PC, Mac, laptop or mobile phone. Easily control one DVR, cable set-top box or satellite receiver. The Slingbox SOLO is simple to set up and use, with features such as an on-screen remote control and Electronic Program Guide (EPG).

Learn More >>

Why leave your HDTV at home? The Slingbox PRO-HD delivers your favorite shows and content over the Internet in stunning high definition to your desktop, or laptop—anywhere you go. It gives you the same great features and ease of use as the Slingbox SOLO with the benefit of multiple inputs, a built-in TV tuner, and a true-to-life HD viewing experience.

Learn More >>

Power Point Automation Using C#

1. Start Visual Studio .NET 2008. On the File menu, click New and then click Project. Select Windows Application from the Visual C# Projects types. Form1 is created by default.

2. Add a reference to the Microsoft PowerPoint Object Library and the Microsoft Graph Object Library. To do this, follow these steps:

a. On the Project menu, click Add Reference.

b. On the COM tab, locate the Microsoft PowerPoint Object Library and click Select. Also locate theMicrosoft Graph Object Libraryand click Select.

Note Microsoft Office XP does not include PIAs, but the PIAs may be downloaded. For more information about Office XP PIAs, click the following article number to view the article in the Microsoft Knowledge Base:

328912 (http/support.microsoft.com/kb/328912/ ) Microsoft Office XP primary interop assemblies (PIAs) are available for download

c. Click OK in the Add References dialog box to accept your selections.

3. Create a Form or Class File, In my part i create a class file.

with the following code.

public class PowerPointUtility

{

}

4. I Create a Method.

with following code.

public void ShowMyPresentation()

{

}

5. Inside my method I added a arguments and some code.

the data will coming from the database.

with following code.

public void ShowMyPresentation(System.Data.DataTable PowerPointTable)

{

PowerPoint.Application PPApp = new Microsoft.Office.Interop.PowerPoint.Application();

//this code will set the mircosoft office power point visible.

PPApp.Visible = Microsoft.Office.Core.MsoTriState.msoTrue;

PowerPoint.Slides objSlides;

PowerPoint._Slide objSlide;

PPApp.Presentations.Add(MsoTriState.msoTrue);

objSlides = PPApp.Presentations[1].Slides;

objSlide = objSlides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

objSlide.BackgroundStyle = MsoBackgroundStyleIndex.msoBackgroundStylePreset12;

//add a table to the slide.

PowerPoint.Shape tableFirme = objSlide.Shapes.AddTable(15, 4, 24, 20, 670, 500); ;

for (int j = 0; j <= PowerPointTable.Rows.Count/15; j++)

{

if (PowerPointTable.Rows.Count / 15 >= 1)

{

objSlide = objSlides.Add(j + 2, PowerPoint.PpSlideLayout.ppLayoutBlank);

objSlide.BackgroundStyle = MsoBackgroundStyleIndex.msoBackgroundStylePreset12;

}

tableFirme.Table.Cell(1, 1).Shape.TextFrame.TextRange.Text = "Rank";

tableFirme.Table.Cell(1, 1).Shape.TextFrame.TextRange.Font.Bold = MsoTriState.msoTrue;

tableFirme.Table.Cell(1, 1).Shape.TextFrame.TextRange.Font.Size = 25;

tableFirme.Table.Cell(1, 1).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignCenter;

tableFirme.Table.Cell(1, 2).Shape.TextFrame.TextRange.Text = "Full Name";

tableFirme.Table.Cell(1, 2).Shape.TextFrame.TextRange.Font.Bold = MsoTriState.msoTrue;

tableFirme.Table.Cell(1, 2).Shape.TextFrame.TextRange.Font.Size = 25;

tableFirme.Table.Cell(1, 2).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignCenter;

tableFirme.Table.Cell(1, 3).Shape.TextFrame.TextRange.Text = "Alias";

tableFirme.Table.Cell(1, 3).Shape.TextFrame.TextRange.Font.Bold = MsoTriState.msoTrue;

tableFirme.Table.Cell(1, 3).Shape.TextFrame.TextRange.Font.Size = 25;

tableFirme.Table.Cell(1, 3).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignCenter;

tableFirme.Table.Cell(1, 4).Shape.TextFrame.TextRange.Text = "Points";

tableFirme.Table.Cell(1, 4).Shape.TextFrame.TextRange.Font.Bold = MsoTriState.msoTrue;

tableFirme.Table.Cell(1, 4).Shape.TextFrame.TextRange.Font.Size = 25;

tableFirme.Table.Cell(1, 4).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignCenter;

}

for (int i = 0; i <= PowerPointTable.Rows.Count-1; i++)

{

//------------Data-----------------

int intRank = i + 1;

tableFirme.Table.Cell(i + 2, 1).Shape.TextFrame.TextRange.Text = intRank.ToString();

tableFirme.Table.Cell(i + 2, 1).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignCenter;

tableFirme.Table.Cell(i + 2, 2).Shape.TextFrame.TextRange.Text = PowerPointTable.Rows[i]["fullname"].ToString();

tableFirme.Table.Cell(i + 2 , 2).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignLeft;

tableFirme.Table.Cell(i + 2, 3).Shape.TextFrame.TextRange.Text = PowerPointTable.Rows[i]["alias"].ToString();

tableFirme.Table.Cell(i + 2, 3).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignLeft;

tableFirme.Table.Cell(i + 2, 4).Shape.TextFrame.TextRange.Text = PowerPointTable.Rows[i]["Points"].ToString();

tableFirme.Table.Cell(i + 2, 4).Shape.TextFrame.TextRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.PowerPoint.PpParagraphAlignment.ppAlignLeft;

}

}

OUTPUT WILL THIS: