Simple Thoughts on Everything

void Main()
{
   var data = Products.OrderBy(a=>Guid.NewGuid()).Take(1);
   foreach(var item in data)
   {
       Console.WriteLine(string.Concat(item.ProductID,"--", item.ProductName));
   }
}

SELECT TOP (1)
[Project1].[ProductID] AS [ProductID],
[Project1].[ProductName] AS [ProductName],
[Project1].[SupplierID] AS [SupplierID],
[Project1].[QuantityPerUnit] AS [QuantityPerUnit],
[Project1].[UnitPrice] AS [UnitPrice],
[Project1].[UnitsInStock] AS [UnitsInStock],
[Project1].[UnitsOnOrder] AS [UnitsOnOrder],
[Project1].[ReorderLevel] AS [ReorderLevel],
[Project1].[Discontinued] AS [Discontinued],
[Project1].[CategoryID] AS [CategoryID]
FROM ( SELECT
   NEWID() AS [C1],
   [Extent1].[ProductID] AS [ProductID],
   [Extent1].[ProductName] AS [ProductName],
   [Extent1].[SupplierID] AS [SupplierID],
   [Extent1].[CategoryID] AS [CategoryID],
   [Extent1].[QuantityPerUnit] AS [QuantityPerUnit],
   [Extent1].[UnitPrice] AS [UnitPrice],
   [Extent1].[UnitsInStock] AS [UnitsInStock],
   [Extent1].[UnitsOnOrder] AS [UnitsOnOrder],
   [Extent1].[ReorderLevel] AS [ReorderLevel],
   [Extent1].[Discontinued] AS [Discontinued]
   FROM [dbo].[Products] AS [Extent1]
)  AS [Project1]
ORDER BY [Project1].[C1] ASC

/// <summary>
/// Image轉Byte[]
/// </summary>
/// <param name="image"></param>
/// <returns></returns>
private static byte[] GetImageByte(Image image)
{
 Image newImage = image.GetThumbnailImage(image.Width, image.Height,
     new System.Drawing.Image.GetThumbnailImageAbort(callBack), IntPtr.Zero);

 ImageConverter converter = new ImageConverter();
 return (byte[])converter.ConvertTo(newImage, typeof(byte[]));
}
private static bool callBack()
{
 return true;
}

<style type="text/css">
 table
 {
     border: solid 1px red;
     border-collapse: collapse;
 }
 table td
 {
     border: solid 1px red;
     width: 150px;
 }
</style>

<table width="450px" cellpadding="0" cellspacing="0">
     <thead>
         <tr>
             <td>新增時間</td>
             <td>內容</td>
             <td>##</td>
         </tr>
     </thead>
     <tbody>
         <tr>
             <td></td>
             <td>r</td>
             <td><a href="javascript:;">刪除row</a></td>
         </tr>
     </tbody>
     <tfoot>
         <tr>
             <td></td>
             <td></td>
             <td>
                 <%= Ajax.ActionLink("新增一筆", "GetNow",
                        new AjaxOptions() {
                        OnSuccess="CreateRow",
                        HttpMethod="POST",
                    }) %>
             </td>
         </tr>
     </tfoot>
</table>
<script type="text/javascript">
   function CreateRow(data)
   {
       var time = data.get_data();
       var newRow = $('tbody tr:first').clone();
       newRow.find('td:first').append(time);
       $('tbody').append(newRow);
   }
   function DeleteRow(elem)
   {
       var row = $(elem).parents('tr');
       var index = $('tr').index(row);
       if (index != 1)
           row.hide();
   }
   $(document).ready(function ()
   {
       $('tbody a').live('click', function ()
       {
           DeleteRow(this);
       });
   });
</script>

public class TableController : Controller
{
   //
   // GET: /Table/

   public ActionResult Index()
   {
       return View();
   }
   [HttpPost]
   public ActionResult GetNow()
   {
       return Content(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
   }
}