WPF ComboBox 动态创建并动态显示数据库内容

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Media;
//using System.Windows.Forms;
namespace x
{
public class ValueSelector : DataTemplateSelector //模板选择器
{
public override DataTemplate SelectTemplate(object item, DependencyObject container)
{
DataTemplate dt = new DataTemplate();
if (item != null && item is DataRec)
{
DataRec dataRec = item as DataRec;
Window window = Application.Current.MainWindow;
if (dataRec.Type.Equals("1"))
{
FrameworkElementFactory comboBox = new FrameworkElementFactory(typeof(ComboBox)); //实例化下拉框控件
if (dataRec.Val.Equals("")) //如果当前数据为空，绑定list
{
comboBox.SetBinding(ComboBox.ItemsSourceProperty, new Binding()
{
Path = new PropertyPath("ValueList"),
Mode = BindingMode.TwoWay,
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged
});
comboBox.SetValue(ComboBox.SelectedIndexProperty, 0); //默认显示请选择
comboBox.SetValue(ComboBox.NameProperty, "comboBox_val");
//comboBox.SetValue(ComboBox.SelectionChangedEvent, new EventHandler(ComboBox_val_SelectedIndexChanged))
}
else //绑定当前值，用户不可再选择
{
comboBox.SetBinding(ComboBox.TextProperty, new Binding()
{
Path = new PropertyPath("Val"),
Mode = BindingMode.TwoWay,
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged
});
//comboBox.SetValue(ComboBox.NameProperty, "comboBox_val");
}
//HyperlinkStyle
comboBox.SetValue(ComboBox.StyleProperty, Application.Current.Resources["AduComboBox"]); //style
//comboBox.SetValue(ComboBox.MarginProperty, new Thickness(5));
//comboBox.SetValue(ComboBox.BackgroundProperty, new SolidColorBrush(Colors.Red));
//comboBox.SetValue(ComboBox.ForegroundProperty, Brushes.DarkBlue);
//comboBox.SetValue(ComboBox.BorderThicknessProperty, new Thickness(1));
//comboBox.SetValue(ComboBox.SelectionChangedEvent)
//System.Windows.Forms.ComboBox.hand
dt.VisualTree = comboBox;
}
else
{
FrameworkElementFactory txtBox = new FrameworkElementFactory(typeof(TextBox)); //实例化文本控件
txtBox.SetBinding(TextBox.TextProperty, new Binding()
{
Path = new PropertyPath("Val"),
Mode = BindingMode.TwoWay,
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged
});
//HyperlinkStyle
//textBlock.SetValue(TextBlock.StyleProperty, ); //style
txtBox.SetValue(TextBox.ForegroundProperty, new SolidColorBrush((Color)ColorConverter.ConvertFromString("#FF134584")));
txtBox.SetValue(TextBox.BackgroundProperty, new SolidColorBrush(Colors.Transparent));
txtBox.SetValue(TextBox.NameProperty, "textBox_val");
dt.VisualTree = txtBox;
}
}
return dt;
}
//private void ComboBox_val_SelectedIndexChanged(object sender, System.EventArgs e)
//{
//
ComboBox comboBox = (ComboBox)sender;
//
string selectedEmployee = (string)ComboBox_val.SelectedItem;
//}
}
}

1
2
<DataGridTemplateColumn Width="150" Header="x" CellTemplateSelector="{StaticResource selector}" IsReadOnly="False"/>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<Page.Resources>
<!--#region 动态可视-->
<local:TextConverter x:Key="TextCvn"/>
<local:ComboBoxConverter x:Key="ComboBoxCvn"/>
<DataTemplate x:Key="GridType">
<Grid
x:Name="TypeGrid">
<ComboBox SelectionChanged="ComboBox_val_SelectionChanged" ItemsSource="{Binding ValueList}" SelectedItem="{Binding Val}" x:Name="comboBox_val" Visibility="{Binding Type,Converter={StaticResource ComboBoxCvn}}" Width="130" Style="{StaticResource AduComboBox}" HorizontalAlignment="Left">
</ComboBox>
<TextBox x:Name="textBox_val" Background="Transparent" Foreground="{StaticResource BlueColor2}" Text="{Binding Val}" Width="130" Visibility="{Binding Type,Converter={StaticResource TextCvn}}" HorizontalAlignment="Left" ></TextBox>
</Grid>
</DataTemplate>
</Page.Resources>
<DataGridTemplateColumn Width="150" Header="x" CellTemplate="{StaticResource GridType}" IsReadOnly="False"/>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
public class ComboBoxConverter : IValueConverter
{
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
if (value.ToString() != "1")
{
return Visibility.Hidden;
}
else
{
return Visibility.Visible;
}
}
public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
return value;
}
}