BindingSource Filter

[shafiullah123]

I have to list boxes...and i have a datagrid with binded to complete table..and i am using DataGridCombocolumn with displaystyle as nothing to display the values from master tables in relation instead of their IDs... On selection change event of second list box i put this filter...values in both list boxes are selected...it shows correct values in debug mode........ MyBindingSource.Filter = "Column1="+cbCol1.SelectedValue+" AND Column2= "+cbCol2.SelectedValue; it gives following error Syntax error: Missing operand before 'And' operator.

[ABitSmart]

You might be missing the ' (quote). Try it this way, MyBindingSource.Filter = "Column1='"+cbCol1.SelectedValue+"' AND Column2= '"+cbCol2.SelectedValue+"'"; See the example here, Link[^]

[shafiullah123]

When i am doing it like that it gives error cannot convert System.Int32 to System.String Actually both are Primary key IDs in individual master tables....but the value coming here is string...If i am not using AND clause this is working fine with individual listbox filtering it is auto converting those strings...Its only then when i want to filter by values from both columns its creating prob...I am not facing any prob with combo box in the same situation.......Its the only list box thats irritating

[jaypatel512]

(("Column1="+cbCol1.SelectedValue.ToString()+") AND (Column2= "+cbCol2.SelectedValue.ToString())); This might work... And one more thing. it might be && inspite of AND But not so sure. .