start:visualstudio2019:programmieren:dotnet:component:dataview

anonymous@undisclosed.example.com (Anonymous) — Mon, 05 Dec 2022 11:34:42 +0000

1670236451		aktuell
Zeile 1:		Zeile 1:
	====== How to filter your row data ======		====== How to filter your row data ======
	This document briefly explains how to use the data filter syntax.		This document briefly explains how to use the data filter syntax.
		+
	[[https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=net-7.0#system-data-datacolumn-expression\|Dot Net 7.0 C# ]]		[[https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=net-7.0#system-data-datacolumn-expression\|Dot Net 7.0 C# ]]
	=== Column names ===		=== Column names ===

start:visualstudio2019:programmieren:dotnet:component:programmierbeispiele

anonymous@undisclosed.example.com (Anonymous) — Mon, 19 Dec 2022 16:32:45 +0000

1671462276		aktuell
Zeile 87:		Zeile 87:
	[[https://stackoverflow.com/questions/701223/net-convert-generic-collection-to-datatable\|Example B]]		[[https://stackoverflow.com/questions/701223/net-convert-generic-collection-to-datatable\|Example B]]
	==== From IList<T> to DataTable ====		==== From IList<T> to DataTable ====
		+
		+	<code c# [enable_line_numbers="true",highlight_lines_extra="12"]>
		+	public DataTable ConvertToDataTable<T>(IList<T> data)
		+	{
		+	PropertyDescriptorCollection properties =
		+	TypeDescriptor.GetProperties(typeof(T));
		+	DataTable table = new DataTable();
		+	foreach (PropertyDescriptor prop in properties)
		+	table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
		+	foreach (T item in data)
		+	{
		+	DataRow row = table.NewRow();
		+	foreach (PropertyDescriptor prop in properties)
		+	row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
		+	table.Rows.Add(row);
		+	}
		+	return table;
		+
		+	}
		+	</code>