/// <summary> /// キーから、リクエストのクッキーを取得します /// </summary> /// <param name="key"></param> /// <returns></returns> private string GetCookieValueByKey(string key) { HttpCookie cookie = Request.Cookies[key]; if (cookie == null) return null; return cookie.Value; } /// <summary> /// レスポンスにクッキーを設定します /// </summary> /// <param name="key">キー</param> /// <param name="value">値</param> /// <returns></returns> private void SetCookie(string key, string value) { var cookie = new HttpCookie(key); cookie.Value = value; Response.Cookies.Add(cookie); }
- using LinqToEntitySample.Models;
- ...
- static void Main(string[] args) {
- using (var db = new NorthwindContext()) {
- var query = from product in db.Products
- select product;
- foreach (Product p in query)
- Console.WriteLine("{0} | {1} | {2} | {3}",
- p.ProductID, p.ProductName, p.UnitPrice, p.QuantityPerUnit);
- Console.ReadLine();
- }
- }
- 1 | Chai | 18.0000 | 10 boxes x 20 bags
- 2 | Chang | 19.0000 | 24 - 12 oz bottles
- 3 | Aniseed Syrup | 10.0000 | 12 - 550 ml bottles
- 4 | Chef Anton's Cajun Seasoning | 22.0000 | 48 - 6 oz jars
- 5 | Chef Anton's Gumbo Mix | 21.3500 | 36 boxes
- 6 | Grandma's Boysenberry Spread | 25.0000 | 12 - 8 oz jars
- 7 | Uncle Bob's Organic Dried Pears | 30.0000 | 12 - 1 lb pkgs.
- .
- .
- .
- public partial class NorthwindContext : DbContext {
- public NorthwindContext()
- : base("name=NorthwindContext") {
- }
- public virtual DbSet Categories { get; set; }
- public virtual DbSet CustomerDemographics { get; set; }
- public virtual DbSet Customers { get; set; }
- public virtual DbSet Employees { get; set; }
- public virtual DbSet Order_Details { get; set; }
- public virtual DbSet Orders { get; set; }
- public virtual DbSet Products { get; set; }
- public virtual DbSet Regions { get; set; }
- 以下省略
ClaimsIdentityを生成する方法が分からんので、単純にセッション変数を使ってログインを使用かな～と思ったがusing Microsoft.AspNet.Identity;
using Microsoft.Owin.Security;
using System.Security.Claims;
using System.Web;
using System.Web.Mvc;
namespace Mvc5AuthSample.Controllers
{
public class AccountController : Controller
{
public ActionResult Login()
{
return View();
}
[HttpPost]
public ActionResult Login(string username, string password)
{
if (username == "alice" && password == "supersecret")
{
HttpContext.GetOwinContext().Authentication
.SignOut(DefaultAuthenticationTypes.ExternalCookie);
Claim claim1 = new Claim(ClaimTypes.Name, username);
Claim[] claims = new Claim[] { claim1 };
ClaimsIdentity claimsIdentity =
new ClaimsIdentity(claims,
DefaultAuthenticationTypes.ApplicationCookie);
HttpContext.GetOwinContext().Authentication
.SignIn(new AuthenticationProperties()
{ IsPersistent = false }, claimsIdentity);
return Redirect("/Home");
}
else
{
ModelState.AddModelError("",
"Invalid username or password.");
}
return View();
}
}
}| <!-- " "を挿入する。xamDataGridの要素でもOK。--> | |
| <igDP:Field Column="7" Name="Cmt" Label="コメ ント"> | |
| <!-- "
"でもいけるっぽい。--> | |
| <igDP:Field Column="7" Name="Cmt" Label="コメ
ント"> | |
| <!-- タグ内で書く場合はLineBreakタグを入れる。--> | |
| <TextBox> | |
| My name is<LineBreak/> | |
| aikazu yendo. | |
| </TextBox> |
<script src="./js/cultures/kendo.culture.ja-JP.min.js"></script>
上記のJavascriptを読ませることで、datePcikerのカレンダーが日本語になる
select namefrom 製品マスタwhereUTL_I18N.TRANSLITERATE(UPPER(TO_MULTI_BYTE(name'kana_fwkatakana')like '%' || UTL_I18N.TRANSLITERATE(UPPER(TO_MULTI_BYTE( 検索文字 )),'kana_fwkatakana') || '%'※'kana_fwkatakana'はすべてのタイプの仮名文字を全角カタカナに変換します。$("#grid").kendoGrid({ dataSource: { type: "odata", transport: { read: "http://demos.kendoui.com/service/Northwind.svc/Orders" }, pageSize: 10, serverPaging: true }, height: 250, pageable: true, selectable: "row multiple", columns: [ "OrderID", "Freight", "ShipName", "ShipCity" ], change: function() { var text = ""; var grid = this; grid.select().each(function() { var dataItem = grid.dataItem($(this)); text += "OrderID: " + dataItem.OrderID + "\n"; }); alert(text); } });
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
columns: [
{ hidden: true, field: "id" },
{ field: "name" }
],
dataSource: [ { id: 1, name: "Jane Doe" }, { id: 2, name: "John Doe" } ]
});
</script><html>
<head>
<link rel="stylesheet" href="[file path]/kendo.common.min.css" />
<link rel="stylesheet" href="[file path]/kendo.default.min.css" />
</head> これをシルバーのテーマに変更する場合は 'mysql:host=yourhost;dbname=yourdb;charset=utf8'
, 'user', 'password');
