http://www.asp.net/web-pages/overview/getting-started/introducing-aspnet-web-pages-2/displaying-data @{ var db = Database.Open("WebPagesMovies"); var selectedData = db.Query("SELECT * FROM Movies"); var grid = new WebGrid(source: selectedData); } <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title></title> <style type="text/css"> .grid { margin: 4px; border-collapse: collapse; width: 600px; } .grid th, .grid td { border: 1px solid #C0C0C0; padding: 5px; } .head { background-color: #E8E8E8; font-weight: bold; color: #FFF; } .alt { background-color: #E8E8E8; color: #000; } </style> </head> <body> <h1>Movies</h1> <div> <!-- visualizzo tutte le colonne senza formattazione --> @grid.GetHtml() </div> <hr> <div> <!-- Visualizzo solo tre colonne su quattro --> @grid.GetHtml( columns: grid.Columns( grid.Column("Title"), grid.Column("Genre"), grid.Column("Year") ) ) </div> <hr> <div> <!-- inserisco lo stile della griglia --> @grid.GetHtml( tableStyle: "grid", headerStyle: "head", alternatingRowStyle: "alt", columns: grid.Columns( grid.Column("Title"), grid.Column("Genre"), grid.Column("Year") ) ) </div> </body> </html> |