public ActionResult Test(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Word word = db.Word.Find(id); if (word == null) { return HttpNotFound(); } int _id = id.Value; var meaning = db.Meanings; var query = from x in db.Word join y in meaning on x.ID equals y.WordID where x.ID.Equals(_id) select new WordDetail { ID = x.ID, Spelling = x.Spelling, Meaning = y.Meaning }; return View("Details", query.FirstOrDefault()); }
private WordLearnerDataContext db = new WordLearnerDataContext();
public ActionResult Index()
{
var words = db.Words;
var meanings = db.Meanings;
var query = from x in words
join y in meanings on x.ID equals y.WordID
select new { ID = x.ID, Word = x.Word, Meaning = y.Meaning };
foreach (var item in query)
{
Debug.WriteLine("{0}: {1} = {2}", item.ID, item.Word, item.Meaning);
}
return View(query.AsQueryable());
}
901: deposit = (お金を)預ける 902: evolve = 進化する
select 社員コード, 氏名, 在籍支社,/* テーブルに既存の列 */ case 在籍支社 when '東京本社' then '関東' when '大阪支社' then '関西' else 'その他' end as '在籍地域' /*CASE 式で取得した列の名前*/ from 社員
public Form1() { InitializeComponent(); this.id.GotFocus += GotFocus; } private void GotFocus(object sender, EventArgs e) { TextBox t = sender as TextBox; t.SelectAll(); }
<Window x:Class="WpfApplication5.CommandTest"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:WpfApplication5"
mc:Ignorable="d"
Title="CommandTest" Height="150" Width="300">
<Grid>
<TextBox x:Name="textBox"
HorizontalAlignment="Left"
Height="23"
Text="{Binding MyText}"
Width="120"/>
<Button x:Name="button"
Content="Clear Text"
Command="{Binding ClearText}"
CommandParameter="{Binding ElementName=textBox}"
HorizontalAlignment="Left"
Width="75"
Margin="125,0,0,0" Height="23"/>
</Grid>
</Window>
using System;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
namespace WpfApplication5
{
public partial class CommandTest : Window
{
public CommandTest()
{
InitializeComponent();
MyData data = new MyData();
data.MyText = "123 test";
this.DataContext = data;
}
}
public class MyData : NotificationObject
{
private string _MyText;
public string MyText
{
get
{
return _MyText;
}
set
{
this._MyText = value;
this.OnPropertyChanged();
}
}
private ClearTextCommand _ClearText;
public ClearTextCommand ClearText {
get{
if(_ClearText == null)
{
_ClearText = new ClearTextCommand();
}
return _ClearText;
}
}
}
public class ClearTextCommand : ICommand
{
public event EventHandler CanExecuteChanged;
public bool CanExecute(object parameter)
{
return true;
}
public void Execute(object parameter)
{
TextBox textBox = parameter as TextBox;
textBox?.Clear();
}
}
}
public class NotificationObject : INotifyPropertyChanged { /// <summary> /// プロパティ値の変更をクライアントに通知する。 /// </summary> public event PropertyChangedEventHandler PropertyChanged; /// <summary> /// PropertyChanged イベント を発生させる。 /// </summary> /// <param name="propertyName">変更されたプロパティ名</param> protected void OnPropertyChanged([CallerMemberName] string propertyName = "") { // C# 6 の Null 条件演算子を利用 this.PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName)); // C# 6 以前 //if (this.PropertyChanged != null) //{ // this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); //} } }
public class MyClass : NotificationObject { private string _text; public string Text { get { return _text; } set { this._text = value; this.OnPropertyChanged(); } } public MyClass() { } }Null 条件演算子 (C# および Visual Basic)
<ItemsControl
VirtualizingStackPanel.IsVirtualizing="True"
ScrollViewer.CanContentScroll="True"
ItemsSource="{Binding Tasks}">
<ItemsControl.ItemTemplate>
<DataTemplate>
<StackPanel Orientation="Horizontal">
<TextBlock Text="{Binding Path=ID}" />
<TextBlock Text="{Binding Path=Title}" />
</StackPanel>
</DataTemplate>
</ItemsControl.ItemTemplate>
<ItemsControl.ItemsPanel>
<ItemsPanelTemplate>
<VirtualizingStackPanel />
</ItemsPanelTemplate>
</ItemsControl.ItemsPanel>
<ItemsControl.Template>
<ControlTemplate>
<Border x:Name="Bd" BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Background="{TemplateBinding Background}" Padding="1" SnapsToDevicePixels="true">
<ScrollViewer Focusable="false" Padding="{TemplateBinding Padding}">
<ItemsPresenter SnapsToDevicePixels="{TemplateBinding SnapsToDevicePixels}"/>
</ScrollViewer>
</Border>
</ControlTemplate>
</ItemsControl.Template>
</ItemsControl>
public partial class LabelInput : UserControl { public LabelInput() { InitializeComponent(); } public string Text { get { return (string)GetValue(TextProperty); } set { SetValue(TextProperty, value); } } // Using a DependencyProperty as the backing store for Text. This enables animation, styling, binding, etc... public static readonly DependencyProperty TextProperty = DependencyProperty.Register("Text", typeof(string), typeof(LabelInput), new PropertyMetadata("Text", TextChanged)); private static void TextChanged(DependencyObject d, DependencyPropertyChangedEventArgs e) { } public string Value { get { return (string)GetValue(ValueProperty); } set { SetValue(ValueProperty, value); } } // Using a DependencyProperty as the backing store for Value. This enables animation, styling, binding, etc... public static readonly DependencyProperty ValueProperty = DependencyProperty.Register("Value", typeof(string), typeof(LabelInput), new PropertyMetadata("Value", ValueChanged)); private static void ValueChanged(DependencyObject d, DependencyPropertyChangedEventArgs e) { } }
<UserControl x:Class="MyPropertyTest.LabelInput" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:local="clr-namespace:MyPropertyTest" mc:Ignorable="d" Height="24.812" Width="173.684"> <Grid> <Grid.ColumnDefinitions> <ColumnDefinition Width="28*"/> <ColumnDefinition Width="59*"/> </Grid.ColumnDefinitions> <TextBlock x:Name="label" Text="{Binding Text, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type local:LabelInput}}, StringFormat='{}{0} : '}" Grid.Column="0"/> <TextBox x:Name="textBox" TextWrapping="Wrap" Text="{Binding Value, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type local:LabelInput}}}" Grid.Column="1"/> </Grid> </UserControl>
<local:LabelInput HorizontalAlignment="Left" VerticalAlignment="Top" Text="名前" Value="としひこ"/> <local:LabelInput HorizontalAlignment="Left" VerticalAlignment="Top" Text="名前" Value="よしひこ" Width="174" Margin="0,25,0,0"/>
<div id="myDiv"> <div>Lorem ipsum dolor sit amet, consectetur</div> <script>console.log("aaa---aaa");</script> <style>*{background-color:transparent;}</style> <div style="visibility:hidden"> adipiscing elit</div> </div> <input type="button" id="button1" value="innerText"/> <input type="button" id="button2" value="textContent"/>