C# – Get filtered result from BindingSource to table/dataset

bindingsourceccombobox

I'm using a BindingSource connected to a DataGridView to filter the data shown.

I would like to know what is the best way to get the filtered result to some other thing than a GridView?

I ask this as I would like to use the filtered result for a few ComboBoxes. Right now I populate these by the DataTable that gets filtered by the BindingSource.

So in short, how do I get filtered BindingSource result as source for something else than a DataGridView?

Best Answer

Actually I believe I finally found a solution.

sourceDataTable.DefaultView.RowFilter = bindingSource.Filter;
DataTable destinationDataTable = sourceDataTable.DefaultView.ToTable();

Related Solutions

C# – Get int value from enum in C#

Just cast the enum, e.g.

int something = (int) Question.Role;

The above will work for the vast majority of enums you see in the wild, as the default underlying type for an enum is int.

However, as cecilphillip points out, enums can have different underlying types. If an enum is declared as a uint, long, or ulong, it should be cast to the type of the enum; e.g. for

enum StarsInMilkyWay:long {Sun = 1, V645Centauri = 2 .. Wolf424B = 2147483649};

you should use

long something = (long)StarsInMilkyWay.Wolf424B;

C# – Get property value from string using reflection

 public static object GetPropValue(object src, string propName)
 {
     return src.GetType().GetProperty(propName).GetValue(src, null);
 }

Of course, you will want to add validation and whatnot, but that is the gist of it.

Best Answer

Related Solutions

C# – Get int value from enum in C#

C# – Get property value from string using reflection

Related Topic