i have System.Data.DataRows with several fields, most of them just plain types like int, single, string.
what is the best way to make them editable using a propertygrid? it should work automatically no matter what kind of fields the datarow has, but it should not display all of them. i want to provide a list of properties that should be hidden.
since the DataTable is autogenerated i cannot add custom attributes like [Browsable(false)]
thanks a lot!
Edited to handle filtering; much tricker: in addition to getting the DataRowView
, we need to provide a custom component that pretends (via pass-thru PropetyDescriptor
s) to be the DataRowView
(which is itself pretending to be the DataRow
) - and filter out the properties that we don't want.
Very interesting problem ;-p Easier to solve in classic classes, but the below works for DataRow
;-p
Note that you could do other things in this area to make some of the properties non-editable (IsReadOnly
), or have a different caption (DisplayName
), or category (Category
) - by overriding other members in RowWrapperDescriptor
.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Windows.Forms;
static class program
{
[STAThread]
static void Main()
{
DataTable table = new DataTable();
table.Columns.Add("ID", typeof(int));
table.Columns.Add("Foo", typeof(int));
table.Columns.Add("Bar", typeof(string));
table.Columns.Add("Audit", typeof(DateTime));
table.Rows.Add(1, 14, "abc", DateTime.MinValue);
DataRow row = table.Rows.Add(2,13,"def", DateTime.MinValue);
table.Rows.Add(3, 24, "ghi", DateTime.MinValue);
RowWrapper wrapper = new RowWrapper(row);
wrapper.Exclude.Add("ID");
wrapper.Exclude.Add("Bar");
Application.EnableVisualStyles();
Application.Run(new Form {Controls = {
new PropertyGrid { Dock = DockStyle.Fill,
SelectedObject = wrapper}}});
}
}
[TypeConverter(typeof(RowWrapper.RowWrapperConverter))]
class RowWrapper
{
private readonly List<string> exclude = new List<string>();
public List<string> Exclude { get { return exclude; } }
private readonly DataRowView rowView;
public RowWrapper(DataRow row)
{
DataView view = new DataView(row.Table);
foreach (DataRowView tmp in view)
{
if (tmp.Row == row)
{
rowView = tmp;
break;
}
}
}
static DataRowView GetRowView(object component)
{
return ((RowWrapper)component).rowView;
}
class RowWrapperConverter : TypeConverter
{
public override bool GetPropertiesSupported(ITypeDescriptorContext context)
{
return true;
}
public override PropertyDescriptorCollection GetProperties(
ITypeDescriptorContext context, object value, Attribute[] attributes)
{
RowWrapper rw = (RowWrapper)value;
PropertyDescriptorCollection props = TypeDescriptor.GetProperties(
GetRowView(value), attributes);
List<PropertyDescriptor> result = new List<PropertyDescriptor>(props.Count);
foreach (PropertyDescriptor prop in props)
{
if (rw.Exclude.Contains(prop.Name)) continue;
result.Add(new RowWrapperDescriptor(prop));
}
return new PropertyDescriptorCollection(result.ToArray());
}
}
class RowWrapperDescriptor : PropertyDescriptor
{
static Attribute[] GetAttribs(AttributeCollection value)
{
if (value == null) return null;
Attribute[] result = new Attribute[value.Count];
value.CopyTo(result, 0);
return result;
}
readonly PropertyDescriptor innerProp;
public RowWrapperDescriptor(PropertyDescriptor innerProperty)
: base(
innerProperty.Name, GetAttribs(innerProperty.Attributes))
{
this.innerProp = innerProperty;
}
public override bool ShouldSerializeValue(object component)
{
return innerProp.ShouldSerializeValue(GetRowView(component));
}
public override void ResetValue(object component)
{
innerProp.ResetValue(GetRowView(component));
}
public override bool CanResetValue(object component)
{
return innerProp.CanResetValue(GetRowView(component));
}
public override void SetValue(object component, object value)
{
innerProp.SetValue(GetRowView(component), value);
}
public override object GetValue(object component)
{
return innerProp.GetValue(GetRowView(component));
}
public override Type PropertyType
{
get { return innerProp.PropertyType; }
}
public override Type ComponentType
{
get { return typeof(RowWrapper); }
}
public override bool IsReadOnly
{
get { return innerProp.IsReadOnly; }
}
}
}