Tiny Asp Script

@using WebMatrix.WebData

@* Remove this section if you are using bundling *@
@section Scripts {
    <script src="~/Scripts/jquery.validate.min.js"></script>
    <script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>
}
<style>
       table, th, td {
         border: solid 1px #bbbbbb;
         border-collapse: collapse;
         padding: 2px;
       }
    </style>

  @{
    WebSecurity.RequireAuthenticatedUser();

    Layout = "~/_SiteLayout.cshtml";
    Page.Title = "Manage Account";

    }
@{
    var Char = UrlData[0];
    var db= Database.Open("PS_GameData");
   var sqlQ = "SELECT ci.CharID,i.ItemName,ci.Bag,ci.Slot,ci.ItemUID,ci.Count,ci.Del From PS_GameData.dbo.CharItems ci inner join PS_GameDefs.dbo.Items i on ci.Type=i.Type and ci.TypeID = i.TypeID WHERE CharID=@0 and Del='0'";
   var data = db.Query(sqlQ, Char);
   }


<table>
       <thead>
           <tr>
               
               <th>Item Name</th> 
               <th>Bag Number</th>
               <th>Slot</th>
               <th>Count</th>
           </tr>
       </thead>
       <tbody>
           @foreach(var row in data){
            <tr>
                    
                   <td>@row.ItemName</td>
                   <td>@row.Bag</td>
                   <td>@row.Slot</td>
                   <td>@row.Count</td>
                   
            </tr>
           }
       </tbody>
</table>