UPDATE Table
SET
fio = SUBSTRING(fio, 1, LEN(fio) - 2) + '.' + SUBSTRING(fio, LEN(fio), 1) + '.'
WHERE SUBSTRING(fio, LEN(fio) - 3, 1) = ' ' and SUBSTRING(fio, LEN(fio) - 1, 1) = ' 'Regex rg = new Regex("a(a)|b(b)");
Console.WriteLine(rg.Match("aa"));
Console.WriteLine(rg.Match("aa").Groups[1].Value);
Console.WriteLine(rg.Match("bb"));
Console.WriteLine(rg.Match("bb").Groups[1].Value);
Console.WriteLine(rg.Match("bb").Groups[2].Value);aa
a
bb
b<Button >
<Run>
<Run.Style>
<Style TargetType="Run">
<Style.Triggers>
<Trigger Property="IsMouseOver" Value="True">
<Setter Property="TextDecorations" Value="Underline" />
</Trigger>
</Style.Triggers>
</Style>
</Run.Style>
Текст
</Run>
</Button>000016684862 270391
000016684862 551062000015A859D4 107225
00050091C090 107225
000015A8B162 117855
0000163BC57E 117855
0005008DEFEB 177271
0000163BEE37 177271
000015A8E2C9 180954
000015A83E90 180954
0000163BB839 190908
0000163BC9A4 190908
00050090A2E9 199580
0000163C08D1 199580
000015ADA449 229974
00001667703A 229974
00050091F9A6 236959
0005007A2E8F 236959
0005007A027C 270222
0000163C262B 270222
00001648857E 270222
00050090C005 291448
0000163BC742 291448
0005008E2BBE 297563
000015B523E6 297563
0005008E53E2 385039
00050091F990 385039<UserControl x:Class="WpfApplication3.UserControl1"
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"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="300">
<Grid>
<Grid.RowDefinitions>
<RowDefinition />
<RowDefinition />
</Grid.RowDefinitions>
<TextBox />
<ListBox Grid.Row="1" />
</Grid>
</UserControl>public MyTextBox : TextBox
{
}<TextBox x:Class="WpfApplication1.MyTextBox"
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"
mc:Ignorable="d" >
</TextBox><Window x:Class="WpfApplication3.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="MainWindow" Height="350" Width="525">
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="47*"/>
<RowDefinition Height="275*"/>
</Grid.RowDefinitions>
<TextBox x:Name="filter" TextChanged="filter_TextChanged"/>
<ListBox x:Name="lst" Grid.Row="1" />
</Grid>
</Window>public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
List<string> lstSource = new List<string>() { "1", "2","3" };
viewSource = new CollectionViewSource();
viewSource.Source = lstSource;
viewSource.Filter += viewSource_Filter;
lst.ItemsSource = viewSource.View;
}
CollectionViewSource viewSource;
void viewSource_Filter(object sender, FilterEventArgs e)
{
e.Accepted = ((string)e.Item).IndexOf(filter.Text) >=0;
}
private void filter_TextChanged(object sender, TextChangedEventArgs e)
{
viewSource.View.Refresh();
}
}