I have a bindingsource which has been filled out by 

tableadapter.fill(DS, param1); 

lets say that this bindingsource has : 

```
char num
A     1
B     2
C     3

```

how do I get num value with given char 'A' using linq? 

I could literate using 
foreach (DataRowView data in this.p\_EM\_Select\_Event\_TypeBindingSource)
but I would like to know how to do this in linq

Thanks,